phpdevshell team mailing list archive

[Greg <1020860@xxxxxxxxxxxxxxxxxx>]

** Changed in: phpdevshell
    Milestone: 3.2.1-stable => 3.5

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