Strict MySQL (5.6), cause problems

[Adrian Liechti]

Every query which sets the auto_increment-id with '', should be changed into NULL.

The MySQL Error looks like this:
The MySQL database engine returned with an error (code 1366 - Incorrect integer value: '' for column 'id' at row 1)

Example (/includes/config/models/PHPDS_db.query.php, about line 48):

Change this:
INSERT INTO
 _db_core_menu_access_logs (log_id, menu_id, user_id, timestamp)
VALUES
 ('', '%s', '%u', '%s')

Into this:
INSERT INTO
 _db_core_menu_access_logs (log_id, menu_id, user_id, timestamp)
VALUES
 (NULL, '%s', '%u', '%s')

[Greg (gregfr)]

Some changes have been submitted, I hope they will address this.

[Adrian Liechti (jahweh)]

The Installation-Queries are in the same way affected.

V3.2
An error occured trying to send the queries (query 75/527).
The error was: [1366] Incorrect integer value: '' for column 'id' at row 1
The offending query was: " INSERT INTO `pds_core_menu_structure` VALUES ('', '2266433229', '0', '2')"

[Greg (gregfr)]

Please try this file and tell me if it's working.

[Adrian Liechti (jahweh)]

works, thx