[Care2002-developers] Doctors and Nurses list problems
Hi Good people. I do have a serious problem with our care2x System.On the main Menu,When I select Doctor and Doctors's list,The same issue happened to Nurse,It complained about MYSQL.See the error massege Below. mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'do' at line 5] in EXECUTE(INSERT INTO care_accesslog ( DATETIME, IP, LOGNOTE, USERID, USERNAME, PASSWORD, THISFILE, FILEFORWARD, LOGIN_SUCCESS ) VALUES ( '2009-07-22/14:05', '10.128.79.108', 'Direct access Doctors Doctors' list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'doctors-dienst-personalliste.php?sid=32a3e479f5c631d126afd31b9c10deb7〈=enipath=menuretpath=menu', '1' );) Best Regards Given -- *** STATE INFORMATION TECHNOLOGY AGENCY *** MIYELANI GIVEN SHIRINDA. E-LEARNING CONSULTANT [SAKAI] DEPARTMENT: TECHNOLOGY LAB ___ Tel :012 470 1526 Cell:0730133879 E-Mail 1:given.shiri...@sita.co.za E-Mail 2:mgshiri...@webmail.co.za ___ Failure is simply the opportunity to begin again,this time more intelligently. -- ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
Re: [Care2002-developers] Doctors and Nurses list problems
hi, could you please post a bug on the trac bugtacker : https://sourceforge.net/apps/trac/care2002/ gj. given.shiri...@sita.co.za wrote: Hi Good people. I do have a serious problem with our care2x System.On the main Menu,When I select Doctor and Doctors's list,The same issue happened to Nurse,It complained about MYSQL.See the error massege Below. mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'do' at line 5] in EXECUTE(INSERT INTO care_accesslog ( DATETIME, IP, LOGNOTE, USERID, USERNAME, PASSWORD, THISFILE, FILEFORWARD, LOGIN_SUCCESS ) VALUES ( '2009-07-22/14:05', '10.128.79.108', 'Direct access Doctors Doctors' list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'doctors-dienst-personalliste.php?sid=32a3e479f5c631d126afd31b9c10deb7〈=enipath=menuretpath=menu', '1' );) Best Regards Given -- ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
Re: [Care2002-developers] Doctors and Nurses list problems
hi, what version are you using ? given.shiri...@sita.co.za wrote: Hi Good people. I do have a serious problem with our care2x System.On the main Menu,When I select Doctor and Doctors's list,The same issue happened to Nurse,It complained about MYSQL.See the error massege Below. mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'do' at line 5] in EXECUTE(INSERT INTO care_accesslog ( DATETIME, IP, LOGNOTE, USERID, USERNAME, PASSWORD, THISFILE, FILEFORWARD, LOGIN_SUCCESS ) VALUES ( '2009-07-22/14:05', '10.128.79.108', 'Direct access Doctors Doctors' list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'doctors-dienst-personalliste.php?sid=32a3e479f5c631d126afd31b9c10deb7〈=enipath=menuretpath=menu', '1' );) Best Regards Given -- ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
Re: [Care2002-developers] Doctors and Nurses list problems
please try to change language. - Original Message From: given.shiri...@sita.co.za given.shiri...@sita.co.za To: care2002-developers@lists.sourceforge.net Sent: Wednesday, July 22, 2009 8:05:39 PM Subject: [Care2002-developers] Doctors and Nurses list problems Hi Good people. I do have a serious problem with our care2x System.On the main Menu,When I select Doctor and Doctors's list,The same issue happened to Nurse,It complained about MYSQL.See the error massege Below. mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'do' at line 5] in EXECUTE(INSERT INTO care_accesslog ( DATETIME, IP, LOGNOTE, USERID, USERNAME, PASSWORD, THISFILE, FILEFORWARD, LOGIN_SUCCESS ) VALUES ( '2009-07-22/14:05', '10.128.79.108', 'Direct access Doctors Doctors' list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'doctors-dienst-personalliste.php?sid=32a3e479f5c631d126afd31b9c10deb7〈=enipath=menuretpath=menu', '1' );) Best Regards Given -- *** STATE INFORMATION TECHNOLOGY AGENCY *** MIYELANI GIVEN SHIRINDA. E-LEARNING CONSULTANT [SAKAI] DEPARTMENT: TECHNOLOGY LAB ___ Tel :012 470 1526 Cell:0730133879 E-Mail 1:given.shiri...@sita.co.za E-Mail 2:mgshiri...@webmail.co.za ___ Failure is simply the opportunity to begin again,this time more intelligently. -- ___ 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] Doctors and Nurses list problems
can you try with the last patch ? #6222 from the svn gj. herman syam wrote: please try to change language. - Original Message From: given.shiri...@sita.co.za given.shiri...@sita.co.za To: care2002-developers@lists.sourceforge.net Sent: Wednesday, July 22, 2009 8:05:39 PM Subject: [Care2002-developers] Doctors and Nurses list problems Hi Good people. I do have a serious problem with our care2x System.On the main Menu,When I select Doctor and Doctors's list,The same issue happened to Nurse,It complained about MYSQL.See the error massege Below. mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'do' at line 5] in EXECUTE(INSERT INTO care_accesslog ( DATETIME, IP, LOGNOTE, USERID, USERNAME, PASSWORD, THISFILE, FILEFORWARD, LOGIN_SUCCESS ) VALUES ( '2009-07-22/14:05', '10.128.79.108', 'Direct access Doctors Doctors' list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'doctors-dienst-personalliste.php?sid=32a3e479f5c631d126afd31b9c10deb7〈=enipath=menuretpath=menu', '1' );) Best Regards Given -- ___ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
Re: [Care2002-developers] Doctors and Nurses list problems
I just find the solution. the problem is file lang_en_stdpass.php line 43 $LDDocsList='Doctors\' list'; i change $LDDocsList='Doctors list'; - Original Message From: herman syam herman_s...@yahoo.com To: care2002-developers@lists.sourceforge.net Sent: Wednesday, July 22, 2009 9:22:38 PM Subject: Re: [Care2002-developers] Doctors and Nurses list problems please try to change language. - Original Message From: given.shiri...@sita.co.za given.shiri...@sita.co.za To: care2002-developers@lists.sourceforge.net Sent: Wednesday, July 22, 2009 8:05:39 PM Subject: [Care2002-developers] Doctors and Nurses list problems Hi Good people. I do have a serious problem with our care2x System.On the main Menu,When I select Doctor and Doctors's list,The same issue happened to Nurse,It complained about MYSQL.See the error massege Below. mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'do' at line 5] in EXECUTE(INSERT INTO care_accesslog ( DATETIME, IP, LOGNOTE, USERID, USERNAME, PASSWORD, THISFILE, FILEFORWARD, LOGIN_SUCCESS ) VALUES ( '2009-07-22/14:05', '10.128.79.108', 'Direct access Doctors Doctors' list ok', 'given', 'admin', '', 'doctors-main-pass.php', 'doctors-dienst-personalliste.php?sid=32a3e479f5c631d126afd31b9c10deb7〈=enipath=menuretpath=menu', '1' );) Best Regards Given -- *** STATE INFORMATION TECHNOLOGY AGENCY *** MIYELANI GIVEN SHIRINDA. E-LEARNING CONSULTANT [SAKAI] DEPARTMENT: TECHNOLOGY LAB ___ Tel :012 470 1526 Cell:0730133879 E-Mail 1:given.shiri...@sita.co.za E-Mail 2:mgshiri...@webmail.co.za ___ Failure is simply the opportunity to begin again,this time more intelligently. -- ___ 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 mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
