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.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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