Re: [Care2002-developers] Labaratories
Sounds like you are using the TZ version... If you are - Hi :-) I'm Beth and I am in the middle of some work on this module... let me know if you are before I say more...LOL frank tilugulilwa wrote: > Hello friends, > > Under LABORATORIES menu, i tried to view "Pending requests" and got the > following error > > == > SELECT care_person.pid, care_person.selian_pid, name_first, name_last, > batch_nr, tr.encounter_nr,tr.send_date,dept_nr,room_nr, tr.priority FROM > care_test_request_chemlabor tr, care_encounter, care_person WHERE > (tr.status='pending' OR tr.status='') AND tr.encounter_nr = > care_encounter.encounter_nr AND care_encounter.pid = care_person.pid > ORDER BY tr.send_date ASC > > Read attempt to DB failed! > > == > > Any idea on what might be the cause of this? > > - > Frank > > > > _ > > University Computing Centre - 'Professionalism, Customer Care and > Technological foresight' > > -- > ___ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers > -- ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
Re: [Care2002-developers] Labaratories
Hi Frank, There are some updates under install/mysql/db_updates/ and I suspect one of these is missing. Try running the query directly and see why it fails. Thanks Tim 2009/6/26 frank tilugulilwa : > Hello friends, > > Under LABORATORIES menu, i tried to view "Pending requests" and got the > following error > > == > SELECT care_person.pid, care_person.selian_pid, name_first, name_last, > batch_nr, tr.encounter_nr,tr.send_date,dept_nr,room_nr, tr.priority FROM > care_test_request_chemlabor tr, care_encounter, care_person WHERE > (tr.status='pending' OR tr.status='') AND tr.encounter_nr = > care_encounter.encounter_nr AND care_encounter.pid = care_person.pid > ORDER BY tr.send_date ASC > > Read attempt to DB failed! > > == > > Any idea on what might be the cause of this? > > - > Frank > > > > _ > > University Computing Centre - 'Professionalism, Customer Care and > Technological foresight' > > -- > ___ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers > -- ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
[Care2002-developers] Labaratories
Hello friends, Under LABORATORIES menu, i tried to view "Pending requests" and got the following error == SELECT care_person.pid, care_person.selian_pid, name_first, name_last, batch_nr, tr.encounter_nr,tr.send_date,dept_nr,room_nr, tr.priority FROM care_test_request_chemlabor tr, care_encounter, care_person WHERE (tr.status='pending' OR tr.status='') AND tr.encounter_nr = care_encounter.encounter_nr AND care_encounter.pid = care_person.pid ORDER BY tr.send_date ASC Read attempt to DB failed! == Any idea on what might be the cause of this? - Frank _ University Computing Centre - 'Professionalism, Customer Care and Technological foresight' -- ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers