Forums

MySQL Error 1064 on Install? Tried on multiple hosts

Permalink
Hi,

I'm excited to try out Concrete5 but when I run the install script I'm receiving the following error:

mysql error: [1064: 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 's Kaddish Bands - Welcome to KaddishBands.com',0,0)' at line 1] in EXECUTE("INSERT INTO Config VALUES('SITE',NOW(),'Mourner's Kaddish Bands - Welcome to KaddishBands.com',0,0);")

Note that I've tried on 2 separate hosts, DreamHost and KnownHost. The tables physically create in the database so there is no database connection issue.

Is this a known bug? What do I do?

Thanks,
Marshall
 
olliephillips replied on at Permalink Best Answer Reply
olliephillips
Looks like the ' is not being escaped. Try and run your install using this "Mourners Kaddish Bands", i.e without the single quote in Mourner's

Hope that helps
Mnkras replied on at Permalink Reply
Mnkras
yea currently in the install, you can't stick in a ', you can change it later in the SitewideSettings,

can you confirm the bug here:http://www.concrete5.org/developers/bugs/5-4-1/install-controller-e...

Thanks
mtaplits replied on at Permalink Reply
I was able to install now after removing the '. Thank you. I've also after the install changed the title back to ' so it is Mourner's Kaddish Bands in the sitewide settings. However the old name is still showing up in the header of the site. How is this controlled?