magmf
Customer
I think there is a bug that happens in some users that I don't know the reason yet
example:
https://under-linux.org/member.php?u=67554
On what I could see the file responsible for this query is dbtech/thanks/includes/class_profileblock.php
example:
https://under-linux.org/member.php?u=67554
Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT
entry.*,
user.username,
user.usergroupid,
user.membergroupids,
user.infractiongroupid,
user.displaygroupid,
receiveduser.username AS receivedusername,
receiveduser.usergroupid AS receivedusergroupid,
receiveduser.membergroupids AS receivedmembergroupids,
receiveduser.infractiongroupid AS receivedinfractiongroupid,
receiveduser.displaygroupid AS receiveddisplaygroupid
FROM (
()
) AS entry
LEFT JOIN vbuser AS user ON(user.userid = entry.userid)
LEFT JOIN vbuser AS receiveduser ON(receiveduser.userid = entry.receiveduserid)
ORDER BY entryid DESC
LIMIT 20;
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 ')
) AS entry
LEFT JOIN vbuser AS user ON(user.userid = entry.userid)
LE' at line 15
Error Number : 1064
Request Date : Thursday, January 31st 2013 @ 12:14:44 PM
Error Date : Thursday, January 31st 2013 @ 12:14:45 PM
Script : http://under-linux.org/member.php?u=67554
Referrer :
IP Address : 186.247.101.26
Username : MarcusMaciel
Classname : vB_Database
MySQL Version : 5.5.28-0ubuntu0.12.04.3
On what I could see the file responsible for this query is dbtech/thanks/includes/class_profileblock.php