BMS-HOSxP Community
HOSxP => แจ้งข้อผิดพลาดการทำงานของ HOSxP V3 => ข้อความที่เริ่มโดย: pop_hosxp ที่ กรกฎาคม 06, 2009, 14:35:31 PM
-
เจอ error script แบบนี้ครับ อาจารย์ MN
06/07/2552 12:40:01 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_anes where operation_id = and wait_save = 'Y'
06/07/2552 12:40:02 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_anes where operation_id = and wait_save = 'Y'
06/07/2552 12:40:02 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_team where operation_id = and wait_save = 'Y'
06/07/2552 12:40:02 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_detail where operation_id = and wait_save = 'Y'
06/07/2552 12:40:02 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_invent where operation_id = and wait_save = 'Y'
06/07/2552 12:40:04 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_team where operation_id = and wait_save = 'Y'
06/07/2552 12:40:04 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_detail where operation_id = and wait_save = 'Y'
06/07/2552 12:40:04 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_invent where operation_id = and wait_save = 'Y'
06/07/2552 12:40:29 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_anes where operation_id = and wait_save = 'Y'
06/07/2552 12:40:29 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_team where operation_id = and wait_save = 'Y'
06/07/2552 12:40:29 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_detail where operation_id = and wait_save = 'Y'
06/07/2552 12:40:29 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_invent where operation_id = and wait_save = 'Y'
06/07/2552 12:40:30 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_anes where operation_id = and wait_save = 'Y'
06/07/2552 12:40:30 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_team where operation_id = and wait_save = 'Y'
06/07/2552 12:40:30 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_detail where operation_id = and wait_save = 'Y'
06/07/2552 12:40:30 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_invent where operation_id = and wait_save = 'Y'
-
ตอนนี้ รพ. เปิดใช้ ห้องผ่าตัด แล้ว
ที่ replicate ก็เป็นเหมือนกันครับ
-
ของผมเจอแบบนี้ครับ
13/07/2552 10:44:38 192.168.0.5/hos #HY000Table './hos/ksklog' is marked as crashed and last (automatic?) repair failed CLI>HOME-EDA79A55E7 SQL>INSERT INTO ksklog (ksklog_id,logtime,loginname,tablename,modifytype,detail,old_delta,new_delta,log_id,computer_name) VALUES (3824012,'2009-07-13 10:33:44','nitaya','RX','EDIT','520713065227',NULL,NULL,NULL,'HOME-EDA79A55E7')
13/07/2552 10:44:38 192.168.0.5/hos #HY000Table './hos/ksklog' is marked as crashed and last (automatic?) repair failed CLI>ห้องตรวจครรภ์26 SQL>INSERT INTO ksklog (ksklog_id,logtime,loginname,tablename,modifytype,detail,old_delta,new_delta,log_id,computer_name) VALUES (3824013,'2009-07-13 10:33:14','more','DOCTOR','EDIT','520713083316',NULL,NULL,NULL,'ห้องตรวจครรภ์26')
13/07/2552 10:45:21 192.168.0.5/hos #HY000Table './hos/ksklog' is marked as crashed and last (automatic?) repair failed CLI>ยานอก04 SQL>INSERT INTO ksklog (ksklog_id,logtime,loginname,tablename,modifytype,detail,old_delta,new_delta,log_id,computer_name) VALUES (3824014,'2009-07-13 10:33:16','pharmacy','RX','EDIT','520713090050',NULL,NULL,NULL,'ยานอก04')
14/07/2552 08:30:50 192.168.0.5/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where hos_guid in ('{A44C381D-3EC7-481A-A3FD-AAA3F4393C1C}')' at line 1 CLI>ห้องบัตร13 SQL>update ovst set pt_subtype= where hos_guid in ('{A44C381D-3EC7-481A-A3FD-AAA3F4393C1C}') ??? ??? ???
-
14/07/2552 08:30:50 192.168.0.5/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where hos_guid in ('{A44C381D-3EC7-481A-A3FD-AAA3F4393C1C}')' at line 1 CLI>ห้องบัตร13 SQL>update ovst set pt_subtype= where hos_guid in ('{A44C381D-3EC7-481A-A3FD-AAA3F4393C1C}')
แบบนี้ของผมก็เจอครับ
เมื่อก่อนไม่เคยมีเลย หมายถึงตั้งแต่เป็น 3.52.3.25 ก็ไม่เคยมี แต่มาระยะหลัง ๆ มีให้เห็นทุกวันเลย
ไม่รู้ว่าจะไปดูพฤติกรรมการคีย์ข้อมูลเข้าของผู้ใช้อย่างไรดี :( :(
-
เป็นความไม่สมบูรณ์ ของการ replication
ต้องระวัง ว่าข้อมูลบางส่วนไม่เข้าเครื่องสำรอง
-
มีคนช่วยดันแล้วครับ อาจารย์ MN รบกวนด้วยครับ
-
ของผมก็มีคล้าย ๆ กัน แต่ตรงที่ เรื่องของการลง หรือเปลี่ยนแปลงปรับปรุงค่าใช้จ่าย ในกรณีคนไข้ที่จะต้อง
admit เกิดจาก ทาง opd ลงข้อมูลยังไม่ครบหรือ ต้องการเปลี่ยนแปลงข้อมูลใหม่ หลังจากที่ตึกรับคนไข้เข้าตึกแล้วออก AN ทำให้มันหา hos_guid หรือ vn ไม่เจอบ้าง เป็นต้น
ดังนั้นทาง รพ.ของผมจึงทำความตกลงกับผู้ใช้ให้ตามขั้นตอนให้ถูกต้อง
-
เจอ error script แบบนี้ครับ อาจารย์ MN
06/07/2552 12:40:01 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_anes where operation_id = and wait_save = 'Y'
06/07/2552 12:40:02 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_anes where operation_id = and wait_save = 'Y'
06/07/2552 12:40:02 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_team where operation_id = and wait_save = 'Y'
06/07/2552 12:40:02 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_detail where operation_id = and wait_save = 'Y'
06/07/2552 12:40:02 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_invent where operation_id = and wait_save = 'Y'
06/07/2552 12:40:04 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_team where operation_id = and wait_save = 'Y'
06/07/2552 12:40:04 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_detail where operation_id = and wait_save = 'Y'
06/07/2552 12:40:04 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_invent where operation_id = and wait_save = 'Y'
06/07/2552 12:40:29 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_anes where operation_id = and wait_save = 'Y'
06/07/2552 12:40:29 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_team where operation_id = and wait_save = 'Y'
06/07/2552 12:40:29 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_detail where operation_id = and wait_save = 'Y'
06/07/2552 12:40:29 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_invent where operation_id = and wait_save = 'Y'
06/07/2552 12:40:30 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_anes where operation_id = and wait_save = 'Y'
06/07/2552 12:40:30 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_team where operation_id = and wait_save = 'Y'
06/07/2552 12:40:30 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_detail where operation_id = and wait_save = 'Y'
06/07/2552 12:40:30 192.168.0.4/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-2 SQL>delete from operation_invent where operation_id = and wait_save = 'Y'
เป็นชุดคำสั่งที่เกิดจากโปรแกรมรุ่นเก่าครับ จะส่งคำสั่งนี้ไปยัง MySQL แต่ตอนใช้งานจะไม่แสดง Error ครับ แต่ชุดคำสั่งนี้จะถูกเก็บไว้ใน replicate_log พอนำมา forward ไป slave ตัว Replication manager จึงแสดง Error ให้เห็นครับ ลองเปลี่ยนไปใช้ระบบห้องผ่าตัดแบบใหม่ แล้วจะไม่แสดง Error นี้ครับ
-
:'(
-
14/07/2552 08:30:50 192.168.0.5/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where hos_guid in ('{A44C381D-3EC7-481A-A3FD-AAA3F4393C1C}')' at line 1 CLI>ห้องบัตร13 SQL>update ovst set pt_subtype= where hos_guid in ('{A44C381D-3EC7-481A-A3FD-AAA3F4393C1C}')
แบบนี้ของผมก็เจอครับ
เมื่อก่อนไม่เคยมีเลย หมายถึงตั้งแต่เป็น 3.52.3.25 ก็ไม่เคยมี แต่มาระยะหลัง ๆ มีให้เห็นทุกวันเลย
ไม่รู้ว่าจะไปดูพฤติกรรมการคีย์ข้อมูลเข้าของผู้ใช้อย่างไรดี :( :(
2 วันมาแล้ว ไม่มี error ครับ ทั้งห้องผ่าตัด และ เวชระเบียน ;D ;D
-
วันนี้ก็ยังเจออยู่ครับ ???
15/07/2552 10:25:15 192.168.0.5/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where hos_guid in ('{FA872D10-AB34-4A98-8A08-E43A317FF8D5}')' at line 1 CLI>โต๊ะ0 SQL>update ovst set pt_subtype= where hos_guid in ('{FA872D10-AB34-4A98-8A08-E43A317FF8D5}')
15/07/2552 10:26:25 192.168.0.5/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where hos_guid in ('{140009F0-7E55-4F95-9900-A83BFE3671B6}')' at line 1 CLI>UC999 SQL>update ovst set pt_subtype= where hos_guid in ('{140009F0-7E55-4F95-9900-A83BFE3671B6}')
เพราะเหตุใดครับ อ. ???
-
เป็นชุดคำสั่งที่เกิดจากโปรแกรมรุ่นเก่าครับ จะส่งคำสั่งนี้ไปยัง MySQL แต่ตอนใช้งานจะไม่แสดง Error ครับ แต่ชุดคำสั่งนี้จะถูกเก็บไว้ใน replicate_log พอนำมา forward ไป slave ตัว Replication manager จึงแสดง Error ให้เห็นครับ ลองเปลี่ยนไปใช้ระบบห้องผ่าตัดแบบใหม่ แล้วจะไม่แสดง Error นี้ครับ
ตอนนี้ผมเปลี่ยนไปใช้ระบบห้องผ่าตัดแบบใหม่ ก็ยังแสดง error อยู่ครับ
21/05/2553 18:55:27 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-1 SQL>delete from operation_anes where operation_id = and wait_save = 'Y'
21/05/2553 18:55:27 192.168.0.2/hos #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and wait_save = 'Y'' at line 1 CLI>OR-1 SQL>delete from operation_team where operation_id = and wait_save = 'Y'