Support > cpg1.5 install

MySQL Error

(1/3) > >>

BradInOKC:
After selecting the MySQL database for Coppermine to install to, I get the following error during installation:


--- Quote ---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''
--- End quote ---


I have tried deleting the database and installing again, and I've tried using a different database named something else...  I'm not really sure what to do from here? 

This is the point at which the error occurs:


--- Quote ---Trying to insert data in the database.

 

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 
--- End quote ---


I'd sure appreciate any help you could offer...  I am trying to setup a photo gallery for my boss, and am absolutely clueless on how to fix this particular type of error.  Thanks for helping.

Brad

onthepike:
If the installer is having issues creating one table, I'd eliminate the obvious and try another install after first downloading a fresh copy of CPG. It's possible that one or more files are corrupt in your current copy (syntax error). You could also try and manually create and populate the table, but I'd first try a fresh copy of CPG and go from there.

BradInOKC:
OK, I'll re-download tomorrow morning and try to do it completely again from scratch.  Hope that works.  Please feel free to share any other ideas in the meantime.  Thanks for responding.

Brad

onthepike:
I don't know what else to suggest, other than verifying the version of MySQL you have running there. I'm sure someone else will come along with a better approach, however.

Joachim Müller:
http://forum.coppermine-gallery.net/index.php/topic,55415.msg270616.html#msg270616

Navigation

[0] Message Index

[#] Next page