error on install

[grides33]

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

[Sami]

looks like some security mod on your server
you need to edit sql/basic.sql file and change

Code Select Expand


INSERT INTO CPG_config VALUES ('forbiden_fname_char', '$/\\\\:*?"\'<>|` &');

to

Code Select Expand


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

and after installation done you need to add these

Code Select Expand


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

to
admin mode=>config=>Files and thumbnails advanced settings=>Characters forbidden in filenames

[Joachim Müller]

Sounds like a magic quotes issue to me...

[grides33]

thanks guys
bmossavari's solution worked just fine
thanks for saving my from going crazy