Wiki Spaces

Documentation
Projects
Resources

Get Help from Others

Q&A: Ask OpenMRS »
Discussion: OpenMRS Talk »
Real-Time: IRC Chat

IRC Logs

Child pages
  • 2009-11-19 - OpenMRS
Skip to end of metadata
Go to start of metadata
00:37:27 *** atomicturtle1 has joined #openmrs
00:46:33 *** r0bby|android has quit IRC
01:10:23 *** Mkop has joined #openmrs
01:18:09 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11255]: patientflags: adding flag scheduling functionality (not yet … <http://dev.openmrs.org/changeset/11255>
02:18:04 *** bwolfe has joined #openmrs
02:18:04 *** ChanServ sets mode: +o bwolfe
02:27:00 *** upul has joined #openmrs
02:27:00 *** ChanServ sets mode: +v upul
02:45:10 *** bwolfe has quit IRC
03:36:29 *** atomicturtle has joined #openmrs
03:36:29 *** atomicturtle1 has quit IRC
03:39:30 *** atomicturtle has left #openmrs
04:03:26 *** upul has quit IRC
04:10:25 *** upul has joined #openmrs
04:10:25 *** ChanServ sets mode: +v upul
06:37:49 *** atomicturtle has joined #openmrs
06:39:52 *** pascal` has joined #openmrs
06:43:43 <pascal`> hi
06:45:44 <r0bby> bai
06:58:52 *** pbrandt has joined #openmrs
06:59:09 *** pascal` has quit IRC
06:59:15 *** pbrandt is now known as pascal`
07:00:41 *** mkulumadzi has joined #openmrs
07:06:09 <pascal`> morning mkulumadzi
07:06:16 <pascal`> hey upul, long time no see
07:35:59 <mkulumadzi> hey pascal`
07:46:40 *** Mkop has quit IRC
08:24:09 *** pbrandt has joined #openmrs
08:26:00 *** pascal` has quit IRC
08:26:52 <upul> hi mr. pbrandt
08:27:05 *** pbrandt is now known as pascal`
08:27:08 <pascal`> hi upul
09:36:24 *** pascal` has quit IRC
09:36:25 *** atomicturtle has quit IRC
09:37:54 *** atomicturtle has joined #openmrs
09:51:16 *** pascal` has joined #openmrs
10:02:06 *** pascal` has quit IRC
10:06:45 *** pascal` has joined #openmrs
11:10:20 *** pascal` has quit IRC
11:21:54 *** r0bby|android has joined #openmrs
11:21:54 *** ChanServ sets mode: +v r0bby|android
11:22:41 *** r0bby|android has quit IRC
11:22:48 *** r0bby|android has joined #openmrs
11:22:48 *** ChanServ sets mode: +v r0bby|android
11:23:23 *** r0bby|android has quit IRC
11:23:32 *** r0bby|android has joined #openmrs
11:23:32 *** ChanServ sets mode: +v r0bby|android
11:23:33 *** r0bby|android has quit IRC
11:24:24 *** r0bby|android has joined #openmrs
11:24:24 *** ChanServ sets mode: +v r0bby|android
11:24:46 *** r0bby|android has quit IRC
11:25:05 *** r0bby|android has joined #openmrs
11:25:05 *** ChanServ sets mode: +v r0bby|android
11:26:06 *** upul has quit IRC
11:34:45 *** r0bby|android has quit IRC
11:37:11 *** r0bby|android has joined #openmrs
11:37:11 *** ChanServ sets mode: +v r0bby|android
11:38:40 *** r0bby|android has quit IRC
11:55:06 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: use a frame set in the module <http://forum.openmrs.org/viewtopic.php?f=8&t=528#p1942>
12:18:52 *** pascal` has joined #openmrs
12:20:56 *** atomicturtle has left #openmrs
12:27:11 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Forum: Regarding the look and feel of openmrs <http://forum.openmrs.org/viewtopic.php?f=10&t=529#p1943>
12:38:32 *** atomicturtle1 has joined #openmrs
12:44:19 *** atomicturtle1 has left #openmrs
12:48:04 *** pascal` has quit IRC
12:48:57 *** pascal` has joined #openmrs
12:49:25 <pascal`> hi jmiranda
12:59:12 <jmiranda> hola pascal
13:21:38 *** jmiranda has quit IRC
13:23:30 *** pascal` has quit IRC
13:44:24 *** pascal` has joined #openmrs
13:52:57 *** jmiranda has joined #openmrs
13:52:57 *** ChanServ sets mode: +o jmiranda
14:13:18 *** pascal` has quit IRC
14:35:36 *** pbrandt has joined #openmrs
15:18:44 *** pbrandt is now known as pascal`
15:34:19 <pascal`> quiet today
15:39:05 *** atomicturtle has joined #openmrs
15:54:29 *** mkulumadzi has quit IRC
15:59:14 *** atomicturtle has left #openmrs
16:14:00 *** Mkop has joined #openmrs
16:41:36 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11256]: pihmalawireports: Added some more indicators to the Pre-ART weekly report. <http://dev.openmrs.org/changeset/11256>
16:51:41 *** mkulumadzi has joined #openmrs
18:36:52 *** atomicturtle1 has joined #openmrs
18:50:25 *** Mkop has quit IRC
19:21:51 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Changesets: Changeset [11257]: ncd: Fixed parsing of numeric results such as "<1". <http://dev.openmrs.org/changeset/11257>
19:40:02 <mkulumadzi> hey pascal`
19:40:06 <mkulumadzi> you still here?
19:42:20 <mkulumadzi> jmiranda, you here?
19:42:30 <jmiranda> yes
19:42:34 <jmiranda> what's up ev
19:42:44 <mkulumadzi> am trying to switch our production server over to 1.5
19:42:48 <jmiranda> pascal`, jetted a little while ago
19:42:52 <mkulumadzi> (jeff has a working version of mateme for 1.5)
19:42:58 <jmiranda> sweet
19:43:06 <pascal`> hey
19:43:20 <pascal`> just needed a break (=
19:43:31 <jmiranda> pascal`, your brain is fried ... go to bed :)
19:43:33 <pascal`> how's it going mkulumadzi, the upgrade?
19:43:34 <mkulumadzi> i am running into the old "ALTER TABLE location ADD CONSTRAINT parent_location FOREIGN KEY (parent_location) REFERENCES location(location_id
19:43:52 <mkulumadzi> looking over my notes i thought i got around this by just dropping the existing constraint
19:43:59 <mkulumadzi> but now i am getting a 'precondition failed' error
19:44:23 <jmiranda> remind me what the error was
19:44:38 <jmiranda> it was saying something about "cannot rename blah"
19:44:40 <pascal`> yeah, you need to drop the one column aswell i think
19:45:04 <mkulumadzi> this one:
19:45:05 <mkulumadzi> Error executing SQL ALTER TABLE `location` ADD CONSTRAINT `parent_location` FOREIGN KEY (`parent_location`) REFERENCES `location`(`location_id`)
19:45:15 <pascal`> what's the full error again? i'll look in the liquibase script
19:45:16 <mkulumadzi> yeah, i also dropped parent_location_id
19:45:51 <mkulumadzi> full stack trace here:
19:45:51 <mkulumadzi> http://www.pastie.org/706408
19:46:00 <mkulumadzi> (first error)
19:46:32 <mkulumadzi> new error is here:
19:46:33 <mkulumadzi> http://www.pastie.org/706409
19:46:33 <pascal`> it's a different one i think
19:47:04 <mkulumadzi> this is what i have done since the first error:
19:47:06 <pascal`> so you dropped the parent_location column from the location table?
19:47:08 <mkulumadzi> ALTER TABLE location DROP FOREIGN KEY parent_location;
19:47:16 <pascal`> no, you need to drop the column too
19:47:26 <pascal`> the precondition checks to make the sure the column doesn't exist
19:47:32 <pascal`> then it creates the column and the key
19:47:34 <mkulumadzi> alter table location drop parent_location_id;
19:47:54 <mkulumadzi> i dropped only the key
19:47:57 <mkulumadzi> then tried
19:48:01 <pascal`> just parent_location
19:48:02 <mkulumadzi> then dropped the column
19:48:06 <mkulumadzi> ok
19:48:19 <pascal`> not parent_location_id
19:48:19 <jmiranda> this is what i was looking for "Can't create table './openmrs/#sql-115d_a6c7.frm'"
19:48:19 <mkulumadzi> will try again
19:49:06 <jmiranda> not sure if you need the ticket
19:49:07 <jmiranda> http://dev.openmrs.org/ticket/1462
19:49:55 <pascal`> yeah, from the ticket, it's because the column and the key need to be dropped
19:50:03 <jmiranda> right
19:50:28 <jmiranda> but it's bad that this is necessary
19:50:47 <jmiranda> we should not be running into that mysql error
19:50:48 <pascal`> yeah, it's because Evan's DB is a bit b0rked
19:50:51 <pascal`> nothing serious tho
19:51:06 <mkulumadzi> passed!
19:51:16 <jmiranda> nice
19:51:20 <pascal`> it's because a previous upgrade was attempted to be rolled back, but the liquibase table remained, with some stuff in it
19:51:26 <pascal`> sweet, good news mkulumadzi! (=
19:51:31 <mkulumadzi> jeff and i were trying to remember and we can't think of when we would have created this problem
19:51:43 <mkulumadzi> pascal`, i've never tried to upgrade the production database
19:51:52 <mkulumadzi> previously was running on the problem on my test env
19:51:53 <jmiranda> it was due to a bad sql diff script i think
19:51:54 <pascal`> i see
19:51:59 <mkulumadzi> this is the first go for this one
19:52:02 <jmiranda> you were one of the only people that ran into it
19:52:03 <pascal`> could be that too
19:52:15 <mkulumadzi> we are bleeding edge here
19:52:35 <jmiranda> yeah, it was probably due to the fact that you were on trunk for a while :)
19:52:53 <mkulumadzi> i don't think that lasted more than a day...
19:52:59 <pascal`> totally bleeding edge :)
19:53:06 <pascal`> anyway, gotta catch some Zzz's
19:53:11 <mkulumadzi> it was so long ago
19:53:13 <mkulumadzi> later pascal`
19:53:15 <pascal`> chat tomorrow guys
19:53:16 <mkulumadzi> thanks for the help
19:53:19 <jmiranda> mkulumadzi, no you were on it much longer than a day
19:53:23 <pascal`> np
19:53:43 <mkulumadzi> i think you guys just thought i was :)
19:53:49 <jmiranda> i remember coming back to boston after my trip to malawi and telling darius that we needed to get everyone on 1.4.x asap
19:53:50 <mkulumadzi> i think i switched back earlier than you realize
19:53:56 <mkulumadzi> at least in my revisionist history i id
19:53:59 <jmiranda> ok
19:54:01 <mkulumadzi> *did
19:54:16 <jmiranda> :)
19:54:26 <jmiranda> you know better than i do
19:54:34 <mkulumadzi> also the patriots beat the giants in the super bowl
19:54:41 <jmiranda> but i'm just saying it wasn't really your fault that the database was corrupt
19:54:55 <jmiranda> and iraq is a flourishing democracy
19:55:09 <mkulumadzi> yes, exactly
19:55:14 <jmiranda> afganistan just held the olympics
19:55:15 <mkulumadzi> if only, if only
19:55:25 <jmiranda> someday
19:55:29 <jmiranda> and all because of you and W
19:55:54 <jmiranda> anyway, let me know how the testing goes
19:56:11 <mkulumadzi> will do
19:56:19 <jmiranda> did you really just migrate your "production" server to 1.5.x
19:56:21 <mkulumadzi> have tested on my laptop and seems to be working fine
19:56:23 <jmiranda> or is this another test server
19:56:28 <mkulumadzi> trying to
19:56:35 <jmiranda> encouraging
19:56:38 <mkulumadzi> like i said, things seem to be working fine in test
19:57:22 <mkulumadzi> fingers crossed
20:17:35 <pascal`> 1.5x is rock solid
20:22:23 <mkulumadzi> jmiranda ever seen this one:
20:22:24 <mkulumadzi> ERROR - errorhandler_jsp._jspService(61) |2009-11-19 15:18:03,709| Error on page /openmrs/errorhandler.jsp
20:22:25 <mkulumadzi> java.lang.ArrayIndexOutOfBoundsException: 2
20:22:25 <mkulumadzi> at java.util.ArrayList.add(ArrayList.java:352)
20:22:25 <mkulumadzi> ?
20:22:30 *** jmiranda has quit IRC
20:30:16 <njero> hey, all of the fun is happening in this channel!
20:41:40 <njero> mkulumadzi: http://forum.openmrs.org/viewtopic.php?f=11&t=452
20:41:44 <OpenMRSBot> <http://ln-s.net/4bBb> (at forum.openmrs.org)
20:42:00 <njero> pascal`: you still here?
20:42:51 <njero> hmm, that link is not too helpful
20:46:28 <mkulumadzi> working with justin in skype
20:47:01 <njero> k
20:49:58 *** jmiranda has joined #openmrs
20:49:58 *** ChanServ sets mode: +o jmiranda
20:57:17 *** pascal` has quit IRC
20:57:17 *** Echidna has quit IRC
20:59:11 *** pascal` has joined #openmrs
20:59:11 *** Echidna has joined #openmrs
21:11:10 *** r0bby|android has joined #openmrs
21:11:10 *** ChanServ sets mode: +v r0bby|android
21:11:37 *** r0bby|android has quit IRC
21:12:46 *** r0bby|android has joined #openmrs
21:12:46 *** ChanServ sets mode: +v r0bby|android
21:17:43 *** Echidna has quit IRC
21:17:43 *** pascal` has quit IRC
21:21:47 *** pascal` has joined #openmrs
21:21:47 *** Echidna has joined #openmrs
21:26:07 <OpenMRSBot> Recent updates in the world of openmrs: OpenMRS Tickets: Ticket #1935 (task created): Customization files should be updated/removed when migrating to OpenMRS 1.5 <http://dev.openmrs.org/ticket/1935>
21:36:48 *** atomicturtle1 has quit IRC
21:37:55 *** atomicturtle has joined #openmrs
21:39:28 *** r0bby|android has quit IRC
21:39:43 *** pascal` has quit IRC
21:40:05 *** pascal` has joined #openmrs
22:12:23 *** atomicturtle1 has joined #openmrs
22:24:57 *** atomicturtle has quit IRC
22:43:46 *** mkulumadzi has quit IRC
23:58:25 *** Echidna has quit IRC
23:59:28 *** njero_ has joined #openmrs
  • No labels