Replication err

[TRIPAK]

ลองทำ Replication ฟ้อง ตามที่แนบอาจารย์ช่วยวิเคราะห์หน่อยครับว่ารุนแรงใหมครับ

[มนตรี บอยรักยุ้ยคนเดียว]

ใช้ mysql v.อะไร
hosxp v.อะไร

[TRIPAK]

v.3.52.2.3   mysql v.5.0. ครับ

[yord]

error ของคุณคือ
08/02/2552 19:13:08 192.168.1.36/hos  #42S22Unknown column 'NAN' in 'field list' CLI>PCUAOM SQL>INSERT INTO person_anc_screen (person_anc_screen_id,person_anc_service_id,bw,height,albumin,bmi,sugar,anc_uterus_level_id,cc_text,anc_baby_position_id,anc_baby_lead_id,baby_fetal_heart_sound,hos_guid,dt_screen1,dt_screen2,dt_screen3,dt_screen4,dt_screen5,dt_decay_count) VALUES (1369,1379,NULL,NULL,NULL,NAN,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
08/02/2552 19:14:01 192.168.1.36/hos  #42S22Unknown column 'NAN' in 'field list' CLI>PCUAOM SQL>INSERT INTO person_anc_screen (person_anc_screen_id,person_anc_service_id,bw,height,albumin,bmi,sugar,anc_uterus_level_id,cc_text,anc_baby_position_id,anc_baby_lead_id,baby_fetal_heart_sound,hos_guid,dt_screen1,dt_screen2,dt_screen3,dt_screen4,dt_screen5,dt_decay_count) VALUES (1376,1385,NULL,NULL,NULL,NAN,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
08/02/2552 19:14:04 192.168.1.36/hos  #42S22Unknown column 'NAN' in 'field list' CLI>PCUAOM SQL>INSERT INTO person_anc_screen (person_anc_screen_id,person_anc_service_id,bw,height,albumin,bmi,sugar,anc_uterus_level_id,cc_text,anc_baby_position_id,anc_baby_lead_id,baby_fetal_heart_sound,hos_guid,dt_screen1,dt_screen2,dt_screen3,dt_screen4,dt_screen5,dt_decay_count) VALUES (1377,1385,NULL,NULL,NULL,NAN,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
08/02/2552 19:14:33 192.168.1.36/hos  #42S22Unknown column 'NAN' in 'field list' CLI>PCUAOM SQL>INSERT INTO person_anc_screen (person_anc_screen_id,person_anc_service_id,bw,height,albumin,bmi,sugar,anc_uterus_level_id,cc_text,anc_baby_position_id,anc_baby_lead_id,baby_fetal_heart_sound,hos_guid,dt_screen1,dt_screen2,dt_screen3,dt_screen4,dt_screen5,dt_decay_count) VALUES (1382,1389,NULL,NULL,NULL,NAN,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
08/02/2552 19:14:34 192.168.1.36/hos  #42S22Unknown column 'NAN' in 'field list' CLI>PCUAOM SQL>INSERT INTO person_anc_screen (person_anc_screen_id,person_anc_service_id,bw,height,albumin,bmi,sugar,anc_uterus_level_id,cc_text,anc_baby_position_id,anc_baby_lead_id,baby_fetal_heart_sound,hos_guid,dt_screen1,dt_screen2,dt_screen3,dt_screen4,dt_screen5,dt_decay_count) VALUES (1383,1389,NULL,NULL,NULL,NAN,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
08/02/2552 19:14:51 192.168.1.36/hos  #42S22Unknown column 'NAN' in 'field list' CLI>PCUAOM SQL>INSERT INTO person_anc_screen (person_anc_screen_id,person_anc_service_id,bw,height,albumin,bmi,sugar,anc_uterus_level_id,cc_text,anc_baby_position_id,anc_baby_lead_id,baby_fetal_heart_sound,hos_guid,dt_screen1,dt_screen2,dt_screen3,dt_screen4,dt_screen5,dt_decay_count) VALUES (1388,1393,NULL,NULL,NULL,NAN,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
08/02/2552 19:14:51 192.168.1.36/hos  #42S22Unknown column 'NAN' in 'field list' CLI>PCUAOM SQL>INSERT INTO person_anc_screen (person_anc_screen_id,person_anc_service_id,bw,height,albumin,bmi,sugar,anc_uterus_level_id,cc_text,anc_baby_position_id,anc_baby_lead_id,baby_fetal_heart_sound,hos_guid,dt_screen1,dt_screen2,dt_screen3,dt_screen4,dt_screen5,dt_decay_count) VALUES (1389,1393,NULL,NULL,NULL,NAN,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
08/02/2552 19:14:59 192.168.1.36/hos  #42S22Unknown column 'NAN' in 'field list' CLI>PCUAOM SQL>INSERT INTO person_anc_screen (person_anc_screen_id,person_anc_service_id,bw,height,albumin,bmi,sugar,anc_uterus_level_id,cc_text,anc_baby_position_id,anc_baby_lead_id,baby_fetal_heart_sound,hos_guid,dt_screen1,dt_screen2,dt_screen3,dt_screen4,dt_screen5,dt_decay_count) VALUES (1394,1397,NULL,NULL,NULL,NAN,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
08/02/2552 19:38:21 192.168.1.36/hos  Lost connection to MySQL server during querySocket error on read. WSAGetLastError return 10054($2746) CLI>PHM2 SQL>update patient set admit = 'Y' where hos_guid in ('{76F066A0-896D-48FE-9D48-C117704E37E5}')
08/02/2552 19:38:21 192.168.1.36/hos  Lost connection to MySQL server during querySocket error on write. WSAGetLastError return 10054($2746)

ไม่ทราบว่าใช้เวอร์ชั่นเดียวกันหรือเปล่าครับ กับเครื่องที่ replicate ไปน่ะครับ

[มนตรี บอยรักยุ้ยคนเดียว]

v.3.52.2.3   mysql v.5.0. ครับ

ลองเปลี่ยน  mysql v.5.0.XX เป็น mysql v.5.1.29-31