Taurus
Customer
When going to this user's userprofile:
Windows 7 Themes - CreativX
I am getting this database error:
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 (
(
SELECT
visitormessage.vmid AS postid,
visitormessage.title AS posttitle,
'N/A' AS threadtitle,
visitormessage.postuserid AS userid,
visitormessage.userid AS threadid,
0 AS forumid,
entry_visitormessage.*
FROM vbdbtech_thanks_entry AS entry_visitormessage
LEFT JOIN vbvisitormessage AS visitormessage ON (visitormessage.vmid = entry_visitormessage.contentid)
WHERE entry_visitormessage.entryid IN(39326)
)
) AS entry
LEFT JOIN vbuser AS user USING(userid)
LEFT JOIN vbuser AS receiveduser ON(receiveduser.userid = entry.receiveduserid)
ORDER BY entryid DESC
LIMIT 20;
MySQL Error : Duplicate column name 'userid'
Error Number : 1060
Request Date : Tuesday, June 19th 2012 @ 04:39:07 AM
Error Date : Tuesday, June 19th 2012 @ 04:39:07 AM
Script : Windows 7 Themes - CreativX
Referrer : Windows 7 Themes - CreativX
IP Address : *************
Username : TheBull
Classname : vB_Database
MySQL Version : 5.1.63-cll
Please help. Thanks.
Windows 7 Themes - CreativX
I am getting this database error:
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 (
(
SELECT
visitormessage.vmid AS postid,
visitormessage.title AS posttitle,
'N/A' AS threadtitle,
visitormessage.postuserid AS userid,
visitormessage.userid AS threadid,
0 AS forumid,
entry_visitormessage.*
FROM vbdbtech_thanks_entry AS entry_visitormessage
LEFT JOIN vbvisitormessage AS visitormessage ON (visitormessage.vmid = entry_visitormessage.contentid)
WHERE entry_visitormessage.entryid IN(39326)
)
) AS entry
LEFT JOIN vbuser AS user USING(userid)
LEFT JOIN vbuser AS receiveduser ON(receiveduser.userid = entry.receiveduserid)
ORDER BY entryid DESC
LIMIT 20;
MySQL Error : Duplicate column name 'userid'
Error Number : 1060
Request Date : Tuesday, June 19th 2012 @ 04:39:07 AM
Error Date : Tuesday, June 19th 2012 @ 04:39:07 AM
Script : Windows 7 Themes - CreativX
Referrer : Windows 7 Themes - CreativX
IP Address : *************
Username : TheBull
Classname : vB_Database
MySQL Version : 5.1.63-cll
Please help. Thanks.