Dozens of Database errors - sum_att_views?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • s0lidgr0und
    Senior Member
    • May 2007
    • 802
    • 3.6.x

    [Forum] Dozens of Database errors - sum_att_views?

    Since the upgrade, I've been getting dozens of these an hour. I've uninstalled or disabled all of my plugins and I've also disabled them in the config file. Any ideas as to where I should look to correct this error?

    Database error in vBulletin 4.0.0:

    Invalid SQL:
    SELECT
    SUM(counter) as sum_att_views
    FROM attachment as a
    INNER JOIN post AS p ON p.postid = a.postid
    INNER JOIN thread AS t ON p.threadid = t.threadid
    WHERE a.userid=17;

    MySQL Error : Unknown column 'a.postid' in 'on clause'
    Error Number : 1054
    Request Date : Tuesday, December 22nd 2009 @ 07:50:27 PM
    Error Date : Tuesday, December 22nd 2009 @ 07:50:28 PM
    Script : http://www.s0lidgr0und.org/cron.php?rand=1261533026
    Referrer : http://www.s0lidgr0und.org/showthrea...on-Ron-Goldman
    IP Address : 99.164.4.145
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
    s.molinari - I would like to ask all customers to definitely feedback issues with the software and be specific with the issues, but to basically suck-up what happened in the past and try to just look forward.
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    That is from a modification (there is no postid in the default vbulletin attachment table in vB4). Disable it and it will go away. (Since it's a cron job, perhaps you should check that folder.)

    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

    • s0lidgr0und
      Senior Member
      • May 2007
      • 802
      • 3.6.x

      #3
      Will do. I just tinkered a bit. I'll see if it works.

      As always, thanks Lynne.
      s.molinari - I would like to ask all customers to definitely feedback issues with the software and be specific with the issues, but to basically suck-up what happened in the past and try to just look forward.

      Comment

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