PhotoPost Community - View Single Post

BadOscar · April 23rd, 2011, 05:43 PM

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

April 23rd, 2011, 05:43 PM	#1 (permalink)
BadOscar Junior Member Verified Customer Join Date: Jan 2003 Posts: 2	First Install SQL Errors 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 ...