Advanced search  

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

Pages: [1]   Go Down

Author Topic: When I get to the creating database structure it errors out  (Read 5346 times)

0 Members and 1 Guest are viewing this topic.

Gary B

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 38
    • Hagerty High School
When I get to the creating database structure it errors out
« 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?
Logged

Nibbler

  • Guest
Re: When I get to the creating database structure it errors out
« Reply #1 on: November 16, 2010, 07:13:15 pm »

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

Gary B

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 38
    • Hagerty High School
Re: When I get to the creating database structure it errors out
« Reply #2 on: November 16, 2010, 07:27:03 pm »

Thank you!! That fixed it.
Logged
Pages: [1]   Go Up
 

Page created in 0.014 seconds with 20 queries.