Announcement

Collapse
No announcement yet.

VB 4.1.7 DB errors - 50+ emails a day.

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • VB 4.1.7 DB errors - 50+ emails a day.

    Getting emails with these 2 errors about 50 times a day. Any idea what might be wrong? I've looked at referring pages and got nothing. The referring URL is always some random page, nothing specific, but the script is always cron.php







    Code:
    Database error in vBulletin 4.1.7:
    
    Invalid SQL:
    
        SELECT infractionid, infraction.userid, points, username
        FROM CSR_infraction AS infraction
        LEFT JOIN CSR_user AS user USING (userid)
        WHERE expires <= 1318461771
            AND expires <> 0
            AND action = 0;
    
    MySQL Error   : Column 'points' in field list is ambiguous
    Error Number  : 1052
    Request Date  : Wednesday, October 12th 2011 @ 06:22:51 PM
    Error Date    : Wednesday, October 12th 2011 @ 06:22:51 PM
    Script        : http://www.MyWebsite.com/cron.php?rand=1318461424
    Referrer      : 
    IP Address    : 150.70.75.37
    Username      : FII
    Classname     : vB_Database
    MySQL Version :
    
    
    
    
    
    
    
    Database error in vBulletin 4.1.7:
    
    Invalid SQL:
    
        SELECT attachmentid
        FROM CSR_attachment AS attachment
        LEFT JOIN CSR_pmtext AS pmtext ON attachment.usedin='pmtextid' AND attachment.itemid=pmtext.pmtextid
        WHERE
                pmtext.pmtextid IS NULL
                    AND usedin<>''
                    AND itemid<>'';
    
    MySQL Error   : Unknown column 'usedin' in 'where clause'
    Error Number  : 1054
    Request Date  : Wednesday, October 12th 2011 @ 06:01:16 PM
    Error Date    : Wednesday, October 12th 2011 @ 06:01:16 PM
    Script        : http://www.MyWebsite.com/cron.php?rand=1318460476
    Referrer      : 
    IP Address    : 66.68.136.73
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :

  • #2
    Both must be the result of modifications.

    The default user table does not have a field called 'points' - that error is because yours appears to have one.

    There is no field called 'usedin' in any vb table, so thats a modification as well.
    Baby, I was born this way

    Comment


    • #3
      From the error, it appears you have an addon that adds another field to the database. Most likely to the user table. The error is stating that there is a points column in both the infractions table (which is default) and the user table (which isn't).

      You'll need to contact the addon author and have them make their column unique by adding a prefix to the column name.

      To get vB support on these forums you first need to be a licensed customer and register for Priority Forum Support. To do this, please go here:

      http://members.vbulletin.com/membersupport_priority.php

      ...and enter your email address in one of the boxes. You'll need to have your customer number and password to access the page.

      If you still have problems after doing this, send an email to [email protected]. Please include your user name, the email address you registered with and your customer number so we can fix the problem.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API - Full / Mobile
      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment

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