Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Data Synch Complains But Can't See Why
What does this error mean?
Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
NULL definition mismatch for 'datakey' column in '`resources`' table
Check C:Program FilesSQLyog Enterprisesja.log for complete error details.
Total time taken – 1 sec(s)
the two tables both have 'datakey' listed as VARCHAR (239) NOT NULL.
No defaults.
What is going on?
P.S. the log file has the exact same information, no more.
Can you post the table definition resources table for both the source and target server?
Just the CREATE TABLE statement will do.
Are MySQL versions identical?
Older SJA-versions would display this message if not.
The most recent versions should display an error msg.
http://www.webyog.com/faq/category11.html