Strict MySQL (5.6), cause problems
Bug #1020860 reported by
Adrian Liechti
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
PHPDevShell |
Fix Committed
|
High
|
Greg |
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/
Change this:
INSERT INTO
_db_core_
VALUES
('', '%s', '%u', '%s')
Into this:
INSERT INTO
_db_core_
VALUES
(NULL, '%s', '%u', '%s')
Changed in phpdevshell: | |
importance: | Undecided → High |
assignee: | nobody → Greg (gregfr) |
status: | New → Confirmed |
Changed in phpdevshell: | |
milestone: | none → 3.2.1-stable |
Changed in phpdevshell: | |
milestone: | 3.2.1-stable → 3.5 |
To post a comment you must log in.
Some changes have been submitted, I hope they will address this.