ผู้เขียน หัวข้อ: แบบนี้มีปัญหาไหมครับ  (อ่าน 1890 ครั้ง)

0 สมาชิก และ 1 บุคคลทั่วไป กำลังดูหัวข้อนี้

ออฟไลน์ Apiruk_Jbhos

  • Sr. Member
  • ****
  • กระทู้: 386
  • Respect: +1
    • ดูรายละเอียด
    • โรงพยาบาล สมเด็จพระยุพราช จอมบึง
แบบนี้มีปัญหาไหมครับ
« เมื่อ: พฤษภาคม 30, 2008, 15:21:44 PM »
0
30/05/2551 13:26:52 192.168.1.10/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 'dou' at line 21
30/05/2551 13:27:02 192.168.1.10/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 '' at line 17
30/05/2551 13:27:41 192.168.1.10/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 '' at line 9
30/05/2551 13:27:51 192.168.1.10/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 '' at line 17
30/05/2551 13:28:28 192.168.1.10/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 'dou' at line 21
30/05/2551 13:28:37 192.168.1.10/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 '' at line 17
30/05/2551 13:30:24 192.168.1.10/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 'dou' at line 21
30/05/2551 13:30:33 192.168.1.10/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 '' at line 17
30/05/2551 13:32:23 192.168.1.10/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 'dou' at line 21
30/05/2551 13:32:32 192.168.1.10/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 '' at line 17
30/05/2551 13:33:21 192.168.1.10/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 '' at line 17
30/05/2551 13:34:13 192.168.1.10/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 '' at line 17
30/05/2551 13:34:58 192.168.1.10/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 'dou' at line 21
30/05/2551 13:35:10 192.168.1.10/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 '' at line 17
30/05/2551 13:38:08 192.168.1.10/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 '' at line 17
30/05/2551 13:39:10 192.168.1.10/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 '' at line 17
30/05/2551 13:40:14 192.168.1.10/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 '' at line 17
30/05/2551 13:41:17 192.168.1.10/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 '' at line 17
30/05/2551 13:42:13 192.168.1.10/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 '' at line 17
30/05/2551 13:43:10 192.168.1.10/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 '' at line 17
30/05/2551 13:44:12 192.168.1.10/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 '' at line 17
30/05/2551 13:46:36 192.168.1.10/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 '' at line 17
30/05/2551 13:47:30 192.168.1.10/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 '' at line 17
30/05/2551 13:48:53 192.168.1.10/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 'dou' at line 21
30/05/2551 13:49:04 192.168.1.10/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 '' at line 17
30/05/2551 13:50:03 192.168.1.10/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 '' at line 17
30/05/2551 13:50:19 192.168.1.10/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 '' at line 9
30/05/2551 13:50:28 192.168.1.10/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 '' at line 17
30/05/2551 13:53:32 192.168.1.10/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 '' at line 17
30/05/2551 13:54:32 192.168.1.10/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 '' at line 17
30/05/2551 13:55:28 192.168.1.10/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 '' at line 17
30/05/2551 14:13:30 192.168.1.10/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 '' at line 17
30/05/2551 14:14:18 192.168.1.10/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 '' at line 17
30/05/2551 14:15:40 192.168.1.10/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 '' at line 17
30/05/2551 14:16:16 192.168.1.10/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 'dou' at line 21
30/05/2551 14:16:26 192.168.1.10/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 '' at line 17
30/05/2551 14:18:56 192.168.1.10/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 '' at line 17
30/05/2551 14:20:51 192.168.1.10/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 '' at line 17
30/05/2551 14:21:40 192.168.1.10/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 '' at line 17
30/05/2551 14:22:31 192.168.1.10/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 '' at line 17
30/05/2551 14:23:22 192.168.1.10/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 '' at line 17
30/05/2551 14:24:10 192.168.1.10/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 '' at line 17
30/05/2551 14:25:04 192.168.1.10/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 '' at line 17
30/05/2551 14:25:54 192.168.1.10/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 '' at line 17
30/05/2551 14:26:23 192.168.1.10/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 'DEFA' at line 10
30/05/2551 14:26:31 192.168.1.10/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 '' at line 17
30/05/2551 14:27:53 192.168.1.10/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 '' at line 17
30/05/2551 14:28:43 192.168.1.10/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 '' at line 17
30/05/2551 14:30:06 192.168.1.10/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 '' at line 17
30/05/2551 14:32:08 192.168.1.10/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 '' at line 17
30/05/2551 14:32:46 192.168.1.10/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 'dou' at line 21
30/05/2551 14:32:55 192.168.1.10/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 '' at line 17
30/05/2551 14:33:44 192.168.1.10/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 '' at line 17
30/05/2551 14:34:35 192.168.1.10/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 '' at line 17
30/05/2551 14:34:38 192.168.1.10/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 set vn = '510530104334' where hos_guid in ('{C7973527-D1FD-47B7-8336-AB988' at line 1 CLI>INDEX3 SQL>update opitemrece where set vn = '510530104334' where hos_guid in ('{C7973527-D1FD-47B7-8336-AB9883474FC8}','{E0334C19-1F07-4B92-BB49-3A26BA2CB8E2}','{B5D33C23-9CD4-4DE0-BF93-2C80C1DFA646}','{97EACE94-4F50-429F-AA8F-6466B44B26FE}','{0EA8EB74-E1A0-4DC9-8C90-860E42C4AF59}')
30/05/2551 14:34:38 192.168.1.10/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 set an = '' where hos_guid in ('{C7973527-D1FD-47B7-8336-AB9883474FC8}','{' at line 1 CLI>INDEX3 SQL>update opitemrece where set an = '' where hos_guid in ('{C7973527-D1FD-47B7-8336-AB9883474FC8}','{E0334C19-1F07-4B92-BB49-3A26BA2CB8E2}','{B5D33C23-9CD4-4DE0-BF93-2C80C1DFA646}','{97EACE94-4F50-429F-AA8F-6466B44B26FE}','{0EA8EB74-E1A0-4DC9-8C90-860E42C4AF59}')
30/05/2551 14:35:22 192.168.1.10/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 '' at line 17
30/05/2551 14:36:11 192.168.1.10/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 '' at line 17
30/05/2551 14:37:01 192.168.1.10/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 '' at line 17
30/05/2551 14:37:49 192.168.1.10/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 '' at line 17
30/05/2551 14:38:38 192.168.1.10/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 '' at line 17
30/05/2551 14:41:09 192.168.1.10/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 '' at line 17
30/05/2551 14:42:31 192.168.1.10/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 '' at line 17
30/05/2551 14:43:53 192.168.1.10/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 '' at line 17
30/05/2551 14:44:41 192.168.1.10/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 '' at line 17
30/05/2551 14:45:30 192.168.1.10/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 '' at line 17
30/05/2551 14:46:06 192.168.1.10/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 'dou' at line 21
30/05/2551 14:46:16 192.168.1.10/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 '' at line 17
30/05/2551 14:47:04 192.168.1.10/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 '' at line 17
30/05/2551 14:47:53 192.168.1.10/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 '' at line 17
30/05/2551 14:48:42 192.168.1.10/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 '' at line 17
30/05/2551 14:50:38 192.168.1.10/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 '' at line 17
30/05/2551 14:51:27 192.168.1.10/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 '' at line 17
30/05/2551 14:52:14 192.168.1.10/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 '' at line 17
30/05/2551 14:53:01 192.168.1.10/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 '' at line 17
30/05/2551 14:54:04 192.168.1.10/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 'DEFA' at line 10
30/05/2551 14:54:13 192.168.1.10/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 '' at line 17
30/05/2551 14:55:02 192.168.1.10/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 '' at line 17
30/05/2551 14:55:31 192.168.1.10/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 'DEFA' at line 10
30/05/2551 14:55:40 192.168.1.10/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 '' at line 17
30/05/2551 14:56:19 192.168.1.10/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 'dou' at line 21
30/05/2551 14:56:27 192.168.1.10/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 '' at line 17
30/05/2551 14:57:16 192.168.1.10/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 '' at line 17

ถ้าตอนทำ repication มันขึ้นว่าแบบนี้คับ เท่าที่ทำ Server Mysql คนละ vertion กันครับ จะมีปัญหาไหมครับ
Server เป็น  5.1.23rc และ อีdเครื่องที่ Backup เป็น 5.0.45 หรือว่า ต้อง up ให้เป็น รุ่นเดียวกันครับ
นาย อภิรักษ์ ชุ่มชะอุ่ม
Mail advance_pro@hotmail.com
โรงพยาบาล สมเด็จพระยุพราช จอมบึง

Server 1 : SR550 Ram 64G
OS1 : CentOS Linux 7.6
MariaDB version 10.1.19

Server 2 : IBM X3500 Ram 6G
OS2 : CentOS 7.6


ขึ้นระบบ เดือน กรกฎาคม 50
http://www.ChomBungHospital.com/

doramon

  • บุคคลทั่วไป
Re: แบบนี้มีปัญหาไหมครับ
« ตอบกลับ #1 เมื่อ: พฤษภาคม 30, 2008, 15:25:01 PM »
0
ต้องเหมือนกันทั้งสองตัวจะดีกว่าครับ
 :o