MySQL error during install of cpg 1.4.10 MySQL error during install of cpg 1.4.10
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

MySQL error during install of cpg 1.4.10

Started by kolloid, February 28, 2007, 10:42:59 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

kolloid

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.



Stramm

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

kolloid

Ok, here is the file. Thanks

Stramm


kolloid

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

K.