[Forum] Database Error

[Falcon Capt]

Received identical 2 database errors today, can anyone decipher what they may be from?

Database error in vBulletin 4.1.12:
 
Invalid SQL:
 
                  SELECT post.*,userfield.*, usertextfield.*, user.*, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar,
                                    customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height,
                                    customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb
                  FROM post AS post
                        LEFT JOIN user AS user ON (user.userid = post.userid)
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (user.userid = usertextfield.userid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = post.userid)
                  WHERE post.postid IN (.);
 
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 ')' at line 10
Error Number  : 1064
Request Date  : Friday, June 15th 2012 @ 04:40:38 PM
Error Date    : Friday, June 15th 2012 @ 04:40:38 PM
Script        : http://forums.XXXXXXXXXX.com/search.php?searchid=2171638
Referrer      : http://forums.XXXXXXXXXX.com/search.php?do=process
IP Address    : XXX.XXX.XXX.XXX
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

[Riasat]

I have seen this error in past a few times but was never able to repro it.

[doubleclick]

Hello -
I just got the 1064 error as well while moving a post out of a thread to a new thread. I went back to the thread to see what happened, and it had in fact moved. Not sure what the consequences, if any, of the error.

Database error in vBulletin 4.2.0:

Invalid SQL:
DELETE FROM vbactivitystream
WHERE
typeid =
AND
contentid IN (SELECT postid FROM vbpost WHERE threadid IN (8351,8359));

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 vbpost WHERE threadid IN (8351,8359))' at line 4
Error Number : 1064
Request Date : Monday, June 25th 2012 @ 07:42:23 AM
Error Date : Monday, June 25th 2012 @ 07:42:23 AM
Script : http://www.xxxxxx/forum/inlinemod.ph...&postids=14285
Referrer : http://wwwxxxxxx/forum/inlinemod.php?threadid=8351&p=
IP Address : nn.nn.nn.nn
Username : me
Classname : vB_Database
MySQL Version : 5.0.95-community-log

[Trevor Hannant]

That's a completely different error, please start your own thread

[Dustin L.]

Hello -
I just got the 1064 error as well while moving a post out of a thread to a new thread. I went back to the thread to see what happened, and it had in fact moved. Not sure what the consequences, if any, of the error.

Database error in vBulletin 4.2.0:

Invalid SQL:
DELETE FROM vbactivitystream
WHERE
typeid =
AND
contentid IN (SELECT postid FROM vbpost WHERE threadid IN (8351,8359));

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 vbpost WHERE threadid IN (8351,8359))' at line 4
Error Number : 1064
Request Date : Monday, June 25th 2012 @ 07:42:23 AM
Error Date : Monday, June 25th 2012 @ 07:42:23 AM
Script : http://www.xxxxxx/forum/inlinemod.ph...&postids=14285
Referrer : http://wwwxxxxxx/forum/inlinemod.php?threadid=8351&p=
IP Address : nn.nn.nn.nn
Username : me
Classname : vB_Database
MySQL Version : 5.0.95-community-log

Error 1064 is just the code to signify a syntax error. It does not represent the actual problem. As Trevor said, your error is completely different.

[doubleclick]

Thanks for the explanation, Dustin. That is more helpful than just being scolded. I had no idea it was a different issue. I was just jumping on the 1064 error.

Here is the new thread I created:

https://www.vbulletin.com/forum/showthread.php/404087-Syntax-problem-when-moving-posts?p=2312338#post2312338

[Mark.B]

Thanks for the explanation, Dustin. That is more helpful than just being scolded. I had no idea it was a different issue. I was just jumping on the 1064 error.

Here is the new thread I created:

https://www.vbulletin.com/forum/show...38#post2312338

I would just add, please don't see Trevor's post as 'scolding'. The support team say things like that so you can get better support. It gets very confusing for everyone when different queries are in the same thread.

Sent from my iPhone using Forum Runner

[peterh]

We have exactly the same error, anybody found any solution? We get this notification every now and then a couple of times.