One of my co-admins selected three posts from an existing thread to move to a new thread and rteceived the following error:
Advice? What's causing this?
Database error in vBulletin 4.2.0:
Invalid SQL:
DELETE FROM activitystream
WHERE
typeid =
AND
contentid IN (SELECT postid FROM post WHERE threadid IN (6252,6256));
MySQL Error : 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 'AND
contentid IN (SELECT postid FROM post WHERE threadid IN (6252,6256))' at line 4
Error Number : 1064
Request Date : Wednesday, June 6th 2012 @ 09:32:34 AM
Error Date : Wednesday, June 6th 2012 @ 09:32:34 AM
Script : http://www.tourettesyndrome.ca/inlin...37,35138,35140
Classname : vB_Database
MySQL Version : 5.1.63-cll
Invalid SQL:
DELETE FROM activitystream
WHERE
typeid =
AND
contentid IN (SELECT postid FROM post WHERE threadid IN (6252,6256));
MySQL Error : 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 'AND
contentid IN (SELECT postid FROM post WHERE threadid IN (6252,6256))' at line 4
Error Number : 1064
Request Date : Wednesday, June 6th 2012 @ 09:32:34 AM
Error Date : Wednesday, June 6th 2012 @ 09:32:34 AM
Script : http://www.tourettesyndrome.ca/inlin...37,35138,35140
Classname : vB_Database
MySQL Version : 5.1.63-cll
Comment