IRC Chat : 2008-11-11 - OpenMRS

00:11:52 *** bmckown has quit IRC
00:31:29 *** nribeka has quit IRC
01:02:43 *** nribeka has joined #openmrs
01:21:14 *** kapten_yuba has joined #openmrs
01:21:25 *** kapten_yuba has left #openmrs
02:15:30 *** bwolfe has joined #openmrs
02:15:30 *** ChanServ sets mode: +o bwolfe
03:25:19 *** bwolfe has quit IRC
03:27:58 *** bwolfe has joined #openmrs
03:27:58 *** ChanServ sets mode: +o bwolfe
03:30:32 *** bwolfe has quit IRC
03:33:38 *** bwolfe has joined #openmrs
03:33:38 *** ChanServ sets mode: +o bwolfe
04:17:16 *** bwolfe has quit IRC
04:32:17 *** njero has joined #openmrs
04:32:17 *** ChanServ sets mode: +v njero
06:06:57 *** njero has quit IRC
06:24:21 *** njero has joined #openmrs
06:24:21 *** ChanServ sets mode: +v njero
07:38:24 *** jacobb has quit IRC
08:17:00 *** Echidna_ has joined #openmrs
08:17:21 *** Echidna has quit IRC
08:55:41 *** Echidna has joined #openmrs
08:55:42 *** Echidna_ has quit IRC
09:00:47 *** nribeka has quit IRC
09:49:33 *** Echidna has quit IRC
10:15:51 *** njero has quit IRC
10:22:44 *** njero has joined #openmrs
10:22:44 *** ChanServ sets mode: +v njero
10:33:19 *** njero has quit IRC
10:43:17 *** njero has joined #openmrs
10:43:17 *** ChanServ sets mode: +v njero
10:57:23 *** njero has quit IRC
11:09:12 *** njero has joined #openmrs
11:09:12 *** ChanServ sets mode: +v njero
11:34:16 *** kapten_yuba has joined #openmrs
11:35:08 *** kapten_yuba has left #openmrs
12:24:06 *** Echidna has joined #openmrs
12:24:58 *** james_regen has joined #openmrs
12:24:58 *** ChanServ sets mode: +v james_regen
12:35:31 *** Echidna_ has joined #openmrs
12:47:14 *** Echidna has quit IRC
13:07:13 *** nribeka has joined #openmrs
13:09:29 *** bwolfe has joined #openmrs
13:09:29 *** ChanServ sets mode: +o bwolfe
13:12:12 *** bwolfe has quit IRC
13:12:51 *** james_regen has quit IRC
13:13:09 *** james_regen has joined #openmrs
13:13:09 *** ChanServ sets mode: +v james_regen
13:15:36 *** njero has quit IRC
13:18:40 *** bwolfe has joined #openmrs
13:18:40 *** ChanServ sets mode: +o bwolfe
13:28:30 *** njero has joined #openmrs
13:28:30 *** ChanServ sets mode: +v njero
13:30:47 *** Echidna_ has quit IRC
13:32:14 *** Echidna has joined #openmrs
13:35:02 *** bmckown has joined #openmrs
13:35:02 *** ChanServ sets mode: +o bmckown
14:53:59 *** Echidna has quit IRC
14:54:33 *** kapten_yuba has joined #openmrs
14:54:41 *** kapten_yuba has left #openmrs
15:10:54 *** njero has quit IRC
15:23:57 *** Echidna has joined #openmrs
15:46:25 *** Echidna has quit IRC
15:50:06 *** Echidna has joined #openmrs
15:55:54 <nribeka> bwolfe
15:56:13 <bwolfe> nribeka
15:56:46 <nribeka> how do openmrs handle 0000-00-00 data?
15:57:05 <nribeka> :D
15:57:30 <nribeka> *not talking about steelers*
15:58:47 <bwolfe> heh
15:58:52 <bwolfe> it doesn't handle t
15:59:11 <bwolfe> its an invalid date to make sure that it gets filled in
15:59:39 <nribeka> so, there will be no chance a 0000-00-00 data get in to database?
15:59:51 <nribeka> is that what it means bwolfe?
16:00:39 <bwolfe> yeah
16:01:04 *** Echidna has quit IRC
16:01:05 <bwolfe> if it does, openmrs error's out because 0000-00-00 can't be turned into a SqlDate object (and then a Date object)
16:01:51 <nribeka> hmm james arbaugh have 0000-00-00 data
16:02:13 <james_regen> bwolfe: when testing our module, it's failing and the log has a message of: Value '0000-00-00' can not be represented as java.sql.Timestamp
16:03:21 <bwolfe> right, so something was inserted with a null value and so the default of 000-00-00 was put into the table
16:03:32 <bwolfe> its on the date_created, date_changed, etc
16:03:35 <bwolfe> are you blocking on those ?
16:04:18 <james_regen> we want to make our module work. do we try to handle this exceptional case, or tell james that he needs to fix his database before our module works?
16:04:41 <james_regen> i think we're ignoring the fields such as date_created and date_changed . . . right, nribeka?
16:05:13 <nribeka> right
16:06:07 <nribeka> we exclude all field that has void,change,create,creator in their name
16:09:09 <bwolfe> I'd guess there was an error in something that got imported into his database
16:09:13 <bwolfe> so he needs to fix it
16:09:28 <bwolfe> but you guys should also be able to see it or catch the error
16:10:41 <nribeka> it's in list() method of the hibernate Criteria
16:10:56 <nribeka> any suggestion on handling it bwolfe :D
16:11:51 <bwolfe> hmm
16:12:09 <bwolfe> not really :-/
16:12:25 <bwolfe> can you tell which column is causing it at least ?
16:12:37 <bwolfe> or do you have more than one date column in that criteria ?
16:14:45 <nribeka> just two i think: death_date or birthdate in the person table
16:18:48 <basic`> bwolfe: i setup an init script and sudo access to stop/start/restart the bot yesterday
16:19:03 <basic`> sudo service supybot
16:19:14 <basic`> it should start automatically on boot now too though
16:19:48 <bwolfe> basic`: awesome, thanks!
16:20:03 <bwolfe> basic`: so its sudo service supybot start ?
16:20:11 <basic`> yep!
16:20:18 <basic`> it should say it's already started if you run that though
16:21:37 *** Echidna has joined #openmrs
17:09:18 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Tutorial or Help for Begginers <http://forum.openmrs.org/viewtopic.php?f=3&t=411#p1429>
17:37:18 *** nribeka has quit IRC
17:43:53 *** bmckown has quit IRC
17:59:21 *** nribeka has joined #openmrs
18:03:45 *** bwolfe has quit IRC
18:41:24 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Re: Tutorial or Help for Begginers <http://forum.openmrs.org/viewtopic.php?f=3&t=411#p1430>
18:48:50 *** jacobb has joined #openmrs
19:02:48 *** Echidna has quit IRC
19:22:09 *** Echidna has joined #openmrs
19:31:24 *** Echidna_ has joined #openmrs
19:50:53 *** Echidna has quit IRC
19:51:12 *** Echidna has joined #openmrs
19:54:31 *** Echidna_ has quit IRC
19:56:11 *** bwolfe has joined #openmrs
19:56:11 *** ChanServ sets mode: +o bwolfe
20:02:20 *** bwolfe has quit IRC
20:11:11 *** bwolfe has joined #openmrs
20:11:11 *** ChanServ sets mode: +o bwolfe
20:22:40 *** bwolfe has quit IRC
20:33:10 *** bwolfe has joined #openmrs
20:33:10 *** ChanServ sets mode: +o bwolfe
21:09:35 *** james_regen has quit IRC
21:38:03 *** bmckown has joined #openmrs
21:38:03 *** ChanServ sets mode: +o bmckown
21:41:37 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Point of Contact near the North East US <http://forum.openmrs.org/viewtopic.php?f=11&t=412#p1431>
21:55:24 <bwolfe> nribeka: that forum post is looking for you :-)
21:57:10 <nribeka> hahahahaha
21:57:13 <nribeka> thanks bwolfe :d
21:57:17 <nribeka> i will reply it :d
21:57:28 <nribeka> but not sure if i could be much of a help :P
21:57:32 <nribeka> hopefully i do :D
21:57:34 <nribeka> anyway
21:57:37 <nribeka> i'm off
21:58:01 <nribeka> ttyl :D
21:58:09 *** nribeka has left #openmrs
22:03:41 *** njero has joined #openmrs
22:03:41 *** ChanServ sets mode: +v njero
22:52:28 *** njero has quit IRC
23:01:10 *** bmckown has quit IRC
23:15:19 *** nribeka has joined #openmrs
23:54:11 *** nribeka1 has joined #openmrs
23:54:26 *** nribeka1 has left #openmrs
23:54:30 *** nribeka1 has joined #openmrs