forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 install => Topic started by: Gary B on November 16, 2010, 06:20:27 pm

Title: When I get to the creating database structure it errors out
Post by: Gary B on November 16, 2010, 06:20:27 pm

The following errors were encountered and need to be corrected first:
MySQL error: You have an error in your SQL syntax near 'ENGINE=MyISAM COMMENT='Holds the categories where groups can create albums'' at line 11 on query ' CREATE TABLE IF NOT EXISTS `cpg15x_categorymap` ( cid int(11) NOT NULL, group_id int(11) NOT NULL, PRIMARY KEY (cid,group_id) ) ENGINE=MyISAM COMMENT='Holds the categories where groups can create albums''


Creating table 'cpg15x_albums'    Status:... OK
Creating table 'cpg15x_banned'    Status:... OK
Creating table 'cpg15x_bridge'    Status:... OK
Creating table 'cpg15x_categories'    Status:... OK
Creating table 'cpg15x_categorymap'    Status:... Not OK

Can someone help me past this step?

Title: Re: When I get to the creating database structure it errors out
Post by: Nibbler on November 16, 2010, 07:13:15 pm

Remove all mention of ENGINE=MyISAM from sql/schema.sql, empty the database and try again.

Title: Re: When I get to the creating database structure it errors out
Post by: Gary B on November 16, 2010, 07:27:03 pm

Thank you!! That fixed it.