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 tiluguli...@udsm.ac.tz: 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
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