coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: cunparis on August 16, 2005, 09:47:17 PM

Title: Please Help! - You have an error in your SQL syntax
Post by: cunparis on August 16, 2005, 09:47:17 PM
I get this error and I have no idea what is wrong:

--

The following errors were encountered and need to be corrected first:

mySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO cpg133_config VALUES ('albums_per_page', '12')' at line 30on query ' CREATE TABLE cpg133_usergroups ( group_id int(11) NOT NULL auto_increment, group_name varchar(255) NOT NULL default '', group_quota int(11) NOT NULL default '0', has_admin_access tinyint(4) NOT NULL default '0', can_rate_pictures tinyint(4) NOT NULL default '0', can_send_ecards tinyint(4) NOT NULL default '0', can_post_comments tinyint(4) NOT NULL default '0'#************************* INSERT INTO cpg133_config VALUES ('albums_per_page', '12')'

--

If you have an idea please let me know.  My URL is :

http://mattoxphoto.free.fr/cpg133

and you can see phpinfo here:

http://mattoxphoto.free.fr/cpg133/myphpinfo.php

Thanks,
Michael
Title: Re: Please Help! - You have an error in your SQL syntax
Post by: Nibbler on August 16, 2005, 10:00:30 PM
The files in the sql folder are not properly uploaded. Remove all Coppermine files from the server and upload them again.
Title: Re: Please Help! - You have an error in your SQL syntax
Post by: cunparis on August 17, 2005, 08:39:29 AM
Quote from: Nibbler on August 16, 2005, 10:00:30 PM
The files in the sql folder are not properly uploaded. Remove all Coppermine files from the server and upload them again.

Apparently my server has a space problem (no space left on device).  Sorry, I'll have to wait and try again later.

Thanks for the diagnostic, doctor.

-Michael
Title: Re: Please Help! - You have an error in your SQL syntax
Post by: Joachim Müller on August 17, 2005, 08:45:47 AM
try http://coppermine.sourceforge.net/faq.php#minimumInstall