phpdevshell team mailing list archive
-
phpdevshell team
-
Mailing list archive
-
Message #00969
[Bug 1020860] Re: Strict MySQL (5.6), cause problems
** Changed in: phpdevshell
Milestone: None => 3.2.1-stable
--
You received this bug notification because you are a member of
PHPDevShell, which is subscribed to PHPDevShell.
https://bugs.launchpad.net/bugs/1020860
Title:
Strict MySQL (5.6), cause problems
Status in Open Source PHP RAD Framework with UI.:
Fix Committed
Bug description:
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')
To manage notifications about this bug go to:
https://bugs.launchpad.net/phpdevshell/+bug/1020860/+subscriptions
References