I'm trying to upgrade from 2.1.7 to 2.1.8 and am getting the following SQL error on the update script mysql_2.1.7_to_2.1.8.sql
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 ';
! 1064 ALTER TABLE jforum_posts ADD INDEX(need_moderate);
ALTER TABLE jforum_posts AD' at line 1
I am using MySQL 5.0.22 on a Linux machine running fedora and running the query in MySQL Query Browser.
Any ideas on what I need to do? Thanks. [originally posted on jforum.net by BrettC]
Migrated From Jforum.net
posted 11 years ago
Try running the query step by step in the query browser (one piece at a time) and see if it work.
Rafael [originally posted on jforum.net by Rafael Steil]