Forums

MySQL error when installing 5.1

Permalink
Just trying to install C5 5.1 and get the following error.
(I have the config folder writable.
I have the files folder and subfolders writable.)

The database is MySQL ver. 4
I had C5 ver 5.0 installed before with this database.
Is there MySQL version 5 requirement now?

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 
'SELECT optionID FROM btSurveyOptions WHERE bID = 32 ) A]
in 
EXECUTE("DELETE FROM btSurveyResults WHERE
optionID NOT IN ( SELECT optionID FROM 
btSurveyOptions WHERE bID = 32 ) 
AND bID = 32 ")


Also note that the db tables are created and the btSurveryResults table is empty.
dstew99
 
dstew99 replied on at Permalink Reply
dstew99
I'm guessing there isn't an answer for this problem.

Does anyone have any guesses?
dustinbrewer replied on at Permalink Reply
I am having the same issue you are having, but with 5.2RC1 on a new install. I posted my problem at:

http://www.concrete5.org/community/forums/installation/installing_c...

Let me know if you find a fix and I'll do the same.

Thanks.
dustinbrewer replied on at Permalink Reply
Just use MySQL 5 instead of 4, I couldn't find it saying you had to anywhere but thats all I did and it works now.
dstew99 replied on at Permalink Reply
dstew99
Hi,
I had to switch to ver.5, but I can't do that for one client (host charges for mysql db!) Crazy, I know. I'm hoping to get them to switch. They are paying too much for hosting right now.

I still can't see a reason for ver.4 to not work.