PHP5+MYSQL5+Apache2.2
When I input the all information on install.php and press "Let's go", the error is following :
The following errors were encountered and need to be corrected first:
mySQL Error: BLOB/TEXT column 'description' can't have a default value on query ' CREATE TABLE cpg_albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL default '', visibility int(11) NOT NULL default '0', uploads enum('YES','NO') NOT NULL default 'NO', comments enum('YES','NO') NOT NULL default 'YES', votes enum('YES','NO') NOT NULL default 'YES', pos int(11) NOT NULL default '0', category int(11) NOT NULL default '0', thumb int(11) NOT NULL default '0', keyword VARCHAR( 50 ), alb_password VARCHAR( 32 ), alb_password_hint TEXT, PRIMARY KEY (aid), KEY alb_category (category) ) TYPE=MyISAM COMMENT='Used to store albums''
How can I slove the problem?
Quote from: edmond0105 on October 16, 2006, 04:43:29 AM
PHP5+MYSQL5+Apache2.2
When I input the all information on install.php and press "Let's go", then....
The following errors were encountered and need to be corrected first:
mySQL Error: BLOB/TEXT column 'description' can't have a default value on query ' CREATE TABLE cpg_albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL default '', visibility int(11) NOT NULL default '0', uploads enum('YES','NO') NOT NULL default 'NO', comments enum('YES','NO') NOT NULL default 'YES', votes enum('YES','NO') NOT NULL default 'YES', pos int(11) NOT NULL default '0', category int(11) NOT NULL default '0', thumb int(11) NOT NULL default '0', keyword VARCHAR( 50 ), alb_password VARCHAR( 32 ), alb_password_hint TEXT, PRIMARY KEY (aid), KEY alb_category (category) ) TYPE=MyISAM COMMENT='Used to store albums''
How can I slove the problem?
Correct sql/schema.sql using the following code, drop any tables that have been created by the installer and re-run it.
EDIT: now in svn (http://svn.sourceforge.net/viewvc/*checkout*/coppermine/trunk/stable/sql/schema.sql)
Thank you ! I was install it successfully .
but a new problem found with add batch file upload, please see the attached pic for reference.
How can I slove the problem?
One question per thread please.