Thanks. Looks like that SQL only works with MySQL 4.
Please download the new version. I have got rid of this section of code altogether.
Quote:
Originally Posted by allan grossman
Output from the manual query -
==========
Error
SQL-query :
UPDATE post,
thread SETpost.isusenetpost = 1 WHERE post.threadid = thread.threadid AND post.isusenetpost = 0 AND thread.forumid NOT IN ( 25, 27, 29, 34 )
MySQL said:
You have an error in your SQL syntax near ' thread SET post.isusenetpost = 1 WHERE post.threadid = thread.threadid AND post' at line 1
==========
MySQL version is 3.23
|