When I get to the creating database structure it errors out When I get to the creating database structure it errors out
 

News:

CPG Release 1.6.28
added submissions from {406man}
cleaned up a few PHP (8.4) deprecations
fixed PHP deprecation in calendar
removed security vulnerability
(please upgrade when possible)

Main Menu

When I get to the creating database structure it errors out

Started by Gary B, November 16, 2010, 06:20:27 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Gary B

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?

Nibbler

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

Gary B