coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: edmond0105 on October 16, 2006, 04:43:29 AM

Title: Can't Install ! mySQL error
Post by: 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", 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?
Title: Re: Can't Install ! mySQL error
Post by: edmond0105 on October 16, 2006, 04:45:04 AM
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?
Title: Re: Can't Install ! mySQL error
Post by: Nibbler on October 16, 2006, 04:59:09 AM
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)
Title: Re: Can't Install ! mySQL error
Post by: edmond0105 on October 16, 2006, 10:01:41 AM
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?
Title: Re: Can't Install ! mySQL error
Post by: Nibbler on October 16, 2006, 01:25:23 PM
One question per thread please.