Database error when viewing a user-specific profile

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • delicateglow
    New Member
    • Aug 2011
    • 18

    [Forum] Database error when viewing a user-specific profile

    Hi, I'm getting this error only when viewing a specific user's profile
    Code:
    Database error in vBulletin 4.1.10:
    
    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 user AS user ON(user.userid = entry.userid)
    			LEFT JOIN 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 user AS user ON(user.userid = entry.userid)
    			LEFT' at line 15
    Error Number  : 1064
    Request Date  : Tuesday, July 24th 2012 @ 10:21:02 PM
    Error Date    : Tuesday, July 24th 2012 @ 10:21:03 PM
    Script        : http://*.net/member.php?8501
    Referrer      : http://*.net/forum.php
    IP Address    : *
    Username      : *
    Classname     : vB_Database
    MySQL Version : 5.0.95-log
    This happens when anyone tries to view his profile
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    Any third party addons or modifications?

    Comment

    • delicateglow
      New Member
      • Aug 2011
      • 18

      #3
      Yes, I do.
      But I don't see how it plays a role. I had nothing new installed for weeks/months.
      Last edited by delicateglow; Tue 24 Jul '12, 8:22pm.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      😀
      😂
      🥰
      😘
      🤢
      😎
      😞
      😡
      👍
      👎