coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: grides33 on August 05, 2006, 05:12:34 AM

Title: error on install
Post by: grides33 on August 05, 2006, 05:12:34 AM
ok followed all the directions properly  . . .. i think
but i get this error (third time ive tried)

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 ';>|` &')' at line 1 on query ' INSERT INTO cpg148_config VALUES ('forbiden_fname_char', '$/\\\\:*?"\'<>|` &')'

the tables are im my database (checked with MYSQL Administrator)

then when i go to log in i get this error message


Critical error
There was an error while processing a database query


any ideas anyone????

http://pressureproductions.org/coppermine/index.php
Title: Re: error on install
Post by: Sami on August 05, 2006, 06:53:45 AM
looks like some security mod on your server
you need to edit sql/basic.sql file and change

INSERT INTO CPG_config VALUES ('forbiden_fname_char', '$/\\\\:*?&quot;\'&lt;&gt;|` &amp;');

to

INSERT INTO CPG_config VALUES ('forbiden_fname_char', '');

and after installation done you need to add these

$/\\:*?"'<>|` &

to
admin mode=>config=>Files and thumbnails advanced settings=>Characters forbidden in filenames
Title: Re: error on install
Post by: Joachim Müller on August 05, 2006, 06:54:35 AM
Sounds like a magic quotes issue to me...
Title: Re: error on install
Post by: grides33 on August 06, 2006, 01:36:48 AM
thanks guys
bmossavari's solution worked just fine
thanks for saving my from going crazy