Installing Concrete5 and got a MySQL error 1064
Permalink
I was attempting to install Concrete5 version 5.2RC1 onto my host using MySQL 4.
I received 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 '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 ")
It looks like it populated the database with 60 tables, but when I go to my directory it prompts me to install again and when I attempt to install again it says I have 60 tables already. I can delete them out but I have no idea what that MySQL error means.
Can anyone help? Thanks.
I received 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 '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 ")
It looks like it populated the database with 60 tables, but when I go to my directory it prompts me to install again and when I attempt to install again it says I have 60 tables already. I can delete them out but I have no idea what that MySQL error means.
Can anyone help? Thanks.
http://www.concrete5.org/community/forums/installation/mysql_error_...