Making MySql Database Errors

[Saftek]

During installation the install php script reported the following errors... using mysql 5.0.51a. I corrected these manually.

Step 3: MySQL error reported: [INSERT INTO cp_categories VALUES (1,'Main','',1,'no',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2',0,0,0,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','0','', 0);]
Result: Incorrect integer value: '' for column 'thumbnail' at row 1
Database: ppclassifieds

Step 3: MySQL error reported: [INSERT INTO cp_categories VALUES (2,'A Category','Products of a particular type',1,'yes',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','0','', 0);]
Result: Incorrect integer value: '' for column 'thumbnail' at row 1
Database: ppclassifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (179,'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter the offset here.', '0', 25, 1)]
Result: Data too long for column 'description' at row 1
Database: ppclassifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (216, 'WorldPay Installation ID', 'wp_instid', 'The Install ID that is generated by the WorldPay CMS for the subscription callback.
You must set your callback url to point to your payment.php script', '', 8, 12)]
Result: Data too long for column 'description' at row 1
Database: ppclassifieds

Step 3: MySQL error reported: [CREATE TABLE cp_feedback (id int(12) NOT NULL auto_increment, foruser int(12) NOT NULL default '0', fromuser int(12) NOT NULL default '0', username varchar(64) NOT NULL default '', postdate int(16) NOT NULL default '0', rating int(2) NOT NULL default '0', comment TEXT NULL default '', approved tinyint(1) NOT NULL default '0', ip varchar(16) NOT NULL default '', PRIMARY KEY (id)) TYPE=MyISAM ]
Result: BLOB/TEXT column 'comment' can't have a default value
Database: ppclassifieds

Step 3: MySQL error reported: [INSERT INTO cp_cache VALUES (1,'',null,null,null,null,null,null,null)]
Result: Incorrect integer value: '' for column 'timestamp' at row 1
Database: ppclassifieds

Step 3: MySQL error reported: [INSERT INTO cp_currency VALUES (23,'Netherlands Antilles, Guilders/Florins','ANG','ƒ', '2')]
Result: Data too long for column 'name' at row 1
Database: ppclassifieds

[Chuck S]

Mysql 5 Compatibility

See if this assists you there.

[Saftek]

Yes, but all you need to do apparently is remove the strict tables entry from the statement... I just removed the Strict_trans_tables entry and it appears to have corrected the problem.

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

[Chuck S]

Mysql 5 Compatibility

Thats not an issue turning off strict mode to normal mysql mode with any of these global queries works as well. Its virtual the same as what your doing only running a query. Your more or less doing number one in my example removing the strict thing from my.ini