First Install SQL Errors

[BadOscar]

I have mySQL 5.1.36, PHP 5.2.10, VB 3.8.6 PL1. I followed the install instructions but I am getting these errors during install. Can someone help me?

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)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
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

Error: Data too long for column 'lon' at row 1
Error: Data too long for column 'lat' at row 1
...

[Chuck S]

Turn off strict mode in mysql and you should be able to rerun install. That looks like strict mode issue.

[BadOscar]

Thanks I got it working now. I found in another one of your posts that said to do this and the install went smooth:

Replace in my.ini the current sql-mode line with sql-mode="MYSQL40"

[Chuck S]

No problem enjoy your weekend.