'' is not accepted for null value in MySQL
| Project: | PHPDevShell |
| Version: | 3.0.0-RC-1 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Description
INSERT query with '' for the auto increment field is not accepted by MySQL. it should be null instead.
Ex :
Incorrect : INSERT INTO `pds_core_filter` VALUES ('', '1', '2067374625', '', 'DESC', 'timestamp', '');
Correct : INSERT INTO `pds_core_filter` VALUES (null, '1', '2067374625', '', 'DESC', 'timestamp', '');
Tested on MySQL 5.1.35 and MySQL 5.0.91
This issue is present on installation queries but also on menu/privilege insert queries
