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
|