I get this error while moving posts to another thread:
So typeid is blank.
In thread.php:
and:
How to fix 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 (16682,27746));
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 (16682,27746))' at line 4
Error Number : 1064
Request Date : Thursday, May 24th 2012 @ 12:29:53 PM
Error Date : Thursday, May 24th 2012 @ 12:29:54 PM
Script : http://www.XXX.com/inlinemod.php?do=...,828035,828234
Referrer : http://www.XXX.com/inlinemod.php?threadid=16682&p=
IP Address : XXX
Username : XXX
Classname : vB_Database
MySQL Version : 5.0.95-community
Invalid SQL:
DELETE FROM activitystream
WHERE
typeid =
AND
contentid IN (SELECT postid FROM post WHERE threadid IN (16682,27746));
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 (16682,27746))' at line 4
Error Number : 1064
Request Date : Thursday, May 24th 2012 @ 12:29:53 PM
Error Date : Thursday, May 24th 2012 @ 12:29:54 PM
Script : http://www.XXX.com/inlinemod.php?do=...,828035,828234
Referrer : http://www.XXX.com/inlinemod.php?threadid=16682&p=
IP Address : XXX
Username : XXX
Classname : vB_Database
MySQL Version : 5.0.95-community
In thread.php:
Code:
typeid = {$typeid}
Code:
$typeid = vB::$vbulletin->activitystream['forum_post']['typeid'];
Comment