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