phpdevshell team mailing list archive

[Adrian Liechti <1020860@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: phpdevshell
     Importance: Undecided
         Status: New

-- 
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.:
  New

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