'' 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

PHPDevShell © 2010 - All rights reserved.