installation problems

[jdra]

HI, i uploaded the programm, went to install.php, filled all info in, clicked on let's go, and got the following error:
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 cpg_config VALUES ('albums_per_page', '12')' at lin on query ' CREATE TABLE cpg_plugins ( plugin_id int(10) unsigned NOT NULL auto_increment, name varchar(64) NOT NULL default ''## ******************************************** INSERT INTO cpg_config VALUES ('albums_per_page', '12')'

what can I do about it?
Jeroen

[Nibbler]

Re-upload the files in the sql directory, looks like they got corrupted during upload.

[jdra]

Did not work, but maybe this can help you: the tables in the db were already created: when I do install it with the same prefix I get this message:
mySQL Error: Table 'cpg1_albums' already exists on query ' CREATE TABLE cpg1_albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL, visibility int(11) NOT NULL default '0', uploads enum('YES','NO') NOT NULL default 'NO', comments enum('YES','NO') NOT NULL default 'YES', votes enum('YES','NO') NOT NULL default 'YES', pos int(11) NOT NULL default '0', category int(11) NOT NULL default '0', thumb int(11) NOT NULL default '0', keyword VARCHAR( 50 ), alb_password VARCHAR( 32 ), alb_password_hint TEXT, PRIMARY KEY (aid), KEY alb_category (category) ) TYPE=MyISAM'

Jeroen

[Nibbler]

Can you post a link to your gallery ?

[jdra]

I don't reaaly get what you mean, this is the link to the install

http://blackmagic.wagoo2.com/cpg142/install.php?

Jeroen

[Nibbler]

Take a look - http://blackmagic.wagoo2.com/cpg142/sql/schema.sql

The file is incomplete, you must re-upload it properly.

[jdra]

I reuploaded it, and it didn't work, got the same message:

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 cpg3_config VALUES ('albums_per_page', '12')' at li on query ' CREATE TABLE cpg3_plugins ( plugin_id int(10) unsigned NOT NULL auto_increment, name varchar(64) NOT NULL default ''## ******************************************** INSERT INTO cpg3_config VALUES ('albums_per_page', '12')'

my scheme.sql is 8760 bt big

jeroen

[Nibbler]

Exactly, it is supposed to be 10KB in size.

[jdra]

in my zip file (that I downloaded) is it also that big, could you give the right one to me?

Jeroen

[Nibbler]

Re-download the file then, try a different mirror.

[jdra]

done that aswell still same problem

jeroen

[Nibbler]

Try the attached (rename it to schema.sql).

[jdra]

now I get the following problem

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 'def## ******************************************** on query ' CREATE TABLE cpg144_plugins ( plugin_id int(10) unsigned NOT NULL auto_increment, name varchar(64) NOT NULL def## ******************************************** INSERT INTO cpg144_config VALUES ('albums_per_page', '12')'

Jeroen

[Joachim Müller]

apparently, there are many files that got corrupted during upload. Re-upload all files from a fresh package. What FTP app do you use?