Announcement

Collapse
No announcement yet.

SQL Error Out of No Where

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] SQL Error Out of No Where

    PHP Code:
    Database error in vBulletin 4.0.0:
    Invalid SQL:
        
    SELECT forum.forumidforum.lastpostCONCAT(usergroup.opentagforum.lastposterusergroup.closetag) AS lastposterforum.lastposteridforum.lastthreadforum.lastthreadidforum.lasticonidforum.threadcountforum.replycountforum.lastpostidforum.lastprefixiduser.usergroupiduser.homepageuser.options AS useroptions, IF(userlist.friend 'yes'10) AS isfriend
         
    forumread.readtime AS forumread
        FROM forum 
    AS forum
         LEFT JOIN forumread 
    AS forumread ON (forumread.forumid forum.forumid AND forumread.userid 1)
        
    LEFT JOIN user AS user ON (user.userid forum.lastposterid)
        
    LEFT JOIN userlist AS userlist ON (userlist.relationid user.userid AND userlist.type 'buddy' AND userlist.userid 1)
         
    LEFT JOIN user AS user ON (forum.lastposterid user.useridLEFT JOIN usergroup AS usergroup ON (user.usergroupid usergroup.usergroupid);
    MySQL Error   Not unique table/alias'user'
    Error Number  1066
    Request Date  
    SaturdayJanuary 9th 2010 03:49:14 PM
    Error Date    
    SaturdayJanuary 9th 2010 03:49:14 PM
    Script        
    http://themayhem.com/forum.php
    Referrer      
    IP Address    71.206.245.41
    Username      
    Paul Bearer
    Classname     
    vB_Database
    MySQL Version 
    5.0.87-community 
    Everything has been working fine for weeks and then out of no where I got this when I visited the forums and the error has not gone away on it's own. Any ideas?
    Last edited by TheMayhem; Sat 9 Jan '10, 11:49am.

  • #2
    You didn't post the actual error.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment


    • #3
      I updated it to include a complete error.

      Comment


      • #4
        That is from a modification.

        Disable all your plugins/products except the Blog and CMS. And when I say disable them ALL, I mean all the products on the Manage Products page (except the Blog and CMS products) AND all the plugins in the Plugin Manager (except those associated with the Blog and CMS). You must do BOTH (I can't emphasize that enough). Now see if you still have the same problem.

        Please don't PM or VM me for support - I only help out in the threads.
        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
        Want help modifying your vbulletin forum? Head on over to vbulletin.org
        If I post CSS and you don't know where it goes, throw it into the additional.css template.

        W3Schools <- awesome site for html/css help

        Comment


        • #5
          Wow..somehow I installed a product that I don't remember installing..odd. Anyways I found it. Thank you.

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X