| 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 |