[lierduh]

Looks like some version of MySQL might not support this SQL statement. I will come up with another one to get around.

Could you do a test on your server. Just run this SQL manually:
=======================================
UPDATE post, thread SET post.isusenetpost = 1 WHERE
post.threadid = thread.threadid AND
post.isusenetpost = 0 AND
thread.forumid NOT IN (25,27,29,34)
=======================================

Originally Posted by allan grossman

Got a little trouble here too, lierduh

Database error in vBulletin 3.0.1:

Invalid SQL: UPDATE post AS post, thread AS thread SET isusenetpost = 1 WHERE 
	post.threadid = thread.threadid AND 
	isusenetpost = 0 AND
	thread.forumid NOT IN (25,27,29,34)
mysql error: You have an error in your SQL syntax near 'AS post, thread AS thread SET isusenetpost = 1 WHERE 
	post.threadid = thread.th' at line 1

mysql error number: 1064

Date: Thursday 13th of May 2004 04:24:04 PM

Any thoughts?