We had a new member join us yesterday but whenever you try to view his profile or clicking on his username a database error is created.
I have been through all our plug-ins and it appears that the Advanced Post Thanks mod is creating this error for some unknown reason. If I disable it, you can view his pages, but if I enable it, you can't.
Database error in vBulletin 4.2.2:
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 vb3_user AS user ON(user.userid = entry.userid)
LEFT JOIN vb3_user 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 vb3_user AS user ON(user.userid = entry.userid)
' at line 15
Error Number : 1064
Request Date : Saturday, March 19th 2016 @ 02:59:01 PM
Error Date : Saturday, March 19th 2016 @ 02:59:02 PM
Script : Royal Welch Forum
Referrer : Royal Welch Forum
IP Address : 86.174.207.65
Username : xxxx xxxxxx
Classname : vB_Database_MySQLi
MySQL Version : 5.5.45-cll-lve
I have been through all our plug-ins and it appears that the Advanced Post Thanks mod is creating this error for some unknown reason. If I disable it, you can view his pages, but if I enable it, you can't.
Database error in vBulletin 4.2.2:
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 vb3_user AS user ON(user.userid = entry.userid)
LEFT JOIN vb3_user 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 vb3_user AS user ON(user.userid = entry.userid)
' at line 15
Error Number : 1064
Request Date : Saturday, March 19th 2016 @ 02:59:01 PM
Error Date : Saturday, March 19th 2016 @ 02:59:02 PM
Script : Royal Welch Forum
Referrer : Royal Welch Forum
IP Address : 86.174.207.65
Username : xxxx xxxxxx
Classname : vB_Database_MySQLi
MySQL Version : 5.5.45-cll-lve
