Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: When I get to the creating database structure it errors out  (Read 4402 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 19 queries.