Couple of errors after upgrade...

  • Time
  • Show
Clear All
new posts
  • one.
    New Member
    • May 2004
    • 10

    Couple of errors after upgrade...

    So I've received a couple of errors in email after upgrading. I fixed a few things, but maybe not all. I followed the upgrade process step by step, no errors or anything. I'm stating that because one of my errors is a 3.5.5 error.

    This has popped up a couple of times:
    Database error in vBulletin :

    PHP Code:
    mysql_connect(): Can't connect to local  MySQL server through socket '/var/lib/mysql/mysql.sock'  (2)
    /home/dseries2/public_html/forums/includes/class_core.php on line  271

    MySQL Error  : 
    Error Number : 
    Date         : Saturday,  October 14th 2006 @ 09:19:13 PM 
    I think that's a server disconnect of some sort, but I am getting it more frequently now.

    PHP Code:
    Database error in vBulletin 3.6.2:

    Invalid SQL:
    SELECT  *
    FROM user AS user 
                               LEFT JOIN customfile 
    AS customfile ON (customfile.userid =  user.userid)
    LEFT JOIN userfield AS userfield ON (userfield.userid  user.userid)
    WHERE user.userid =  userfield.userid
    AND userfield.field55>0    
                              ORDER BY userfield
    .field55  ASC
                              LIMIT 0

    MySQL Error  Table  'dseries2_database.customfile' doesn't exist
    Error Number :  1146
    Date         : Saturday, October 14th 2006 @ 12:42:26 AM
    Script        :
    Referrer      : 
    And this:
    PHP Code:
    Database error in vBulletin 3.5.5:

    Invalid SQL:

    SELECT  moderator.*, user.username,
    user.displaygroupid 0user.usergroupid,  user.displaygroupid) AS displaygroupidinfractiongroupid
    FROM moderator 
    AS  moderator
    INNER JOIN user 
    AS user USING(userid);

    MySQL Error  :  Unknown column 'infractiongroupid' in 'field list'
    Error Number :  1054
    FridayOctober 13th 2006 08:47:04 AM
    IP  Address
    :  vb_database 
    Any and all help is greatly appreciated.

  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    The first error is a failed MySQL connection. Maybe the config info was wrong for a short time during the upgrade while you were working with the files. Or maybe the MySQL server was restarted. I wouldn't worry about it unless the error recurs.

    The second error refers to a table named customfile which does not exist in the default software. This must be from custom code. Upload the original PHP files and disable plugins.

    The third error refers to a column which does not exist in 3.5 (the version reported in the error), but it does in 3.6. This might have happened during the upgrade when the new files were uploaded but the database was not yet upgraded (before running the upgrade script). Are you still getting this error?


    Related Topics