Problems, need help? Have a tip or advice? Post it here.
5 posts Page 1 of 1
Hi, Ive just put couch onto my server but the installation fails. I get the following error:

Installation failed!
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 '-xcart' at line 1

Now I think the problem lies in my database name as it contains a "-" see the config:

Code: Select all
   // Name of the database
   define( 'K_DB_NAME', 'web155-xcart' );
    // 5.
   // Database username
   define( 'K_DB_USER', 'web155-xcart' );

Unfortunately my host adds the prefix for to the name and theres no way to change it. Any ideas?

Cheers, Jason.
Solved it by installing it on another host which doesnt require the database name to have a "-" in it then I backed up that database and moved to the other host and everything works fine.

Must be a little bug with the install script, hopefully it'll get fixed in the future
Hi Jason,

Welcome to our forums and thank you for reporting this problem.
You have indeed encountered a bug in Couch that crops up if there is a hyphen in database name.

I have rectified it and am attaching the modified file. Please overwrite the existing 'install.php' in your couch folder with this one and try installing Couch once again.

Please do let us know it this helps.



Cheers, I can confirm that file solves the problem for me.

Thanks again, Jason.
Thank you Jason for letting us know.
5 posts Page 1 of 1