Print Page - MySQL error during install of cpg 1.4.10

Title: MySQL error during install of cpg 1.4.10
Post by: kolloid on February 28, 2007, 10:42:59 AM

Hello.
When attempting to install for the first time, the install script (install.php) caused a MySQL error:

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 cpg1410_config VALUES ('forbiden_fname_char', '$/\\\\:*?"\'<'

I'm installing the software on my home machine and my configuration is:

FreeBSD 6.2 on AMD64
Apache 2.2.4
PHP 5.2.1
MySQL 5.1.14-beta
cpg 1.4.10

I'd be grateful for any clues.

Title: Re: MySQL error during install of cpg 1.4.10
Post by: Stramm on February 28, 2007, 04:28:08 PM

please attach your sql/basic.sql to your next post

Title: Re: MySQL error during install of cpg 1.4.10
Post by: kolloid on February 28, 2007, 09:13:58 PM

Ok, here is the file. Thanks

Title: Re: MySQL error during install of cpg 1.4.10
Post by: Stramm on February 28, 2007, 09:35:56 PM

looks good...
you may want to read that thread. Should help.
http://forum.coppermine-gallery.net/index.php?topic=34617.0

Title: Re: MySQL error during install of cpg 1.4.10
Post by: kolloid on March 01, 2007, 12:07:47 AM

Yes, the same problem. I followed the instructions given in that thread and could finish the installation. Thanks!

K.

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: kolloid on February 28, 2007, 10:42:59 AM