Hi
I'm Renato,
I have problem during the installation with the db creation :
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 'lon' at row 1
Error: Data too long for column 'lon' at row 1
Error: Data too long for column 'lon' at row 1
Error: Data too long for column 'lon' at row 1
Error: Data too long for column 'lon' at row 1
Error: Data too long for column 'lon' at row 1
Error: Data too long for column 'lon' at row 1
Error: Data too long for column 'lon' at row 1
Error: Data too long for column 'lon' at row 1
Error: Data too long for column 'lon' at row 1
Error: Data too long for column 'lon' at row 1 < --- this continues a lot !
After that in the Import phrases :
Notice: Use of undefined constant STRING - assumed 'STRING' in C:\inetpub\wwwroot\TEST\phrases.php on line 21
Notice: Use of undefined constant STRING - assumed 'STRING' in C:\inetpub\wwwroot\TEST\phrases.php on line 21
Then when trying to import phrases :
Preparing to update database...
Error performing MySQL command: INSERT INTO cp_phrases VALUES ('', 'emailreg', 'Thanks for registering at ^Globals[\'webname\']. In order to activate your account, which will enable you to upload products and post ratings (if the site allows ratings), you must click on the link below or copy and paste it into your browser: ^Globals[\'maindir\']/register.php?ppaction=vfy&uid=^theuid&knum=^joindate Thanks! The ^Globals[\'webname\'] Team ^Globals[\'domain\']', 'Thanks for registering at ^Globals[\'webname\']. In order to activate your account, which will enable you to upload products and post ratings (if the site allows ratings), you must click on the link below or copy and paste it into your browser: ^Globals[\'maindir\']/register.php?ppaction=vfy&uid=^theuid&knum=^joindate Thanks! The ^Globals[\'webname\'] Team ^Globals[\'domain\']', '1');
Error: Incorrect integer value: '' for column 'phraseid' at row 1
So at the end of the installation IIS 7 gives me a 500 Internal error on each page :
Login - PhotoPost Classifieds
Mysql 5.0.77
Php 5.2.9
phpinfo()
Please help me
Renato
Linear Mode
