Thread

This question may be related to a resolved thread.

Hello I am having this problem in the latest version off EE 1.6.4 and MySql 5.0.67-community-nt

I copied the mysql data folder from my previous mysql 4 data dir to the new mysql 5 data dir.

MySQL ERROR:

Error Number: 1366

Description: Incorrect integer value: ‘’ for column ‘id’ at row 1

Query: INSERT INTO `exp_cp_log` (`id`, `member_id`, `username`, `ip_address`, `act_date`, `action`, `site_id`) VALUES (’‘, ‘1’, ‘admin’, ‘192.168.255.63’, ‘1224749004’, ‘Logged out’, ‘1’)

I suspect the new server is running in strict mode, which EE isn’t compatible with.  See if you can turn strict mode off and see if that does the trick.

Thanks! It worked out fine with SET sql_mode = “”;

Glad to see Robin squared you away there. Please don’t hesitate to post again, as needed.