MODx CMS and PHP Application Framework Bugtracker

Attached to Project — MODx
Opened by Dmitrii Varvashenia (dmitrii) - Tuesday, 29 May 2007, 07:32AM
Last edited by Ryan Thrash (rthrash) - Saturday, 27 September 2008, 08:48AM

Task Type	Bug Report
Category	Core Distribution
Status	Unconfirmed
Assigned To	Garry Nutting (garryn)
Operating System	All

Severity	High
Priority	High
Reported Version	0.9.6
Due in Version	Undecided
Due Date	Undecided
Percent Complete

Details

Mysql error while restoring database from backup:

ERROR 1264 (22003): Out of range value adjusted for column 'id' at row 1

CREATE TABLE `modx_active_users` (
`internalKey` int(9) NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`lasthit` int(20) NOT NULL default '0',
`id` int(10) default NULL,
`action` varchar(10) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
PRIMARY KEY (`internalKey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Contains data about active users.';

#
# Dumping data for table `modx_active_users`
#

INSERT INTO `modx_active_users` VALUES ('1','user','1180441284','','93','127.0.0.1');


How to fix: replace empty ('') values with default NULL to NULL. ('' -> NULL)