Announcement

Collapse
No announcement yet.

Database error in vBulletin 4.2.5:

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

  • Database error in vBulletin 4.2.5:

    Looking for some advice on a problem I've ignored (with an email filter) for a long while, I have a pretty active site with 600k+ posts and I get anywhere from 5-10 email notifications per day regarding "Database error in vBulletin 4.2.5". I run the site on a dedicated server, Linux/Plesk with what seems to be adequate resources and I'm pretty sure I have all patches and updates installed.

    They generally reference different scripts and usually point to a valid page except they use the secure httpS:// protocol which I don't currently run (I own an SSL cert but I'm still working on that transition) and sometimes have details on a Referrer but not always, sometimes the Referrer is a legit source like Google but other times it's porn/other related , the one thing that's most consistent is the "MySQL Error Unknown column 'emailstamp' in 'field list'". at the top of the error report.

    I've attached a few of these reports below (Cut-n-Paste from the email I get), what are these errors? Are they a problem or just a spider going where it shouldn't? I'll take any advice I can get, Thanks!


    Code:
    Database error in vBulletin 4.2.5:
    
                Invalid SQL:
    INSERT  IGNORE  INTO session (`sessionhash`,`userid`,`host`,`idhash`,`lastactivity`,`location`,`styleid`,`languageid`,`loggedin`,`inforum`,`inthread`,`incalendar`,`badlocation`,`useragent`,`bypass`,`profileupdate`,`apiclientid`,`apiaccesstoken`,`emailstamp`)
                VALUES('863b75dc6654d11b6f10bb751ce6485c',0,'178.154.244.25','6c913c1c79f77816200fb9fc7771f016',1547832765,'',9,1,0,0,0,0,0,'Mozilla/5.0 (compatible; YandexBot/3.0; +[URL]http://yandex.com/bots[/URL])',0,0,0,'',0)
    /**session**/;
    
                MySQL Error   : Unknown column 'emailstamp' in 'field list'
                Error Number  : 1054
                Request Date  : Friday, January 18th 2019 @ 12:32:45 PM
                Error Date    : Friday, January 18th 2019 @ 12:32:46 PM
                Script        : [URL="https://www.copytechnet.com/forums/redirect-to/?redirect=http%3A%2F%2FAllColor.codes"]https://www.copytechnet.com/forums/r...AllColor.codes[/URL]
                Referrer      :
                IP Address    : 178.154.244.25
                Username      : Guest
                Classname     : vB_Database_MySQLi
                MySQL Version :
    
    
    Stack Trace:
    #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
    #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
    #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 542
    #3 vB_Database->query_write() called in [path]/vb/db/query/insertignore.php on line 88
    #4 vB_dB_Query_InsertIgnore->doInserts() called in [path]/vb/db/query/insert.php on line 98
    #5 vB_dB_Query_Insert->execSQL() called in [path]/vb/db/assertor.php on line 303
    #6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 475
    #7 vB_dB_Assertor->insertIgnore() called in [path]/vb/session.php on line 503
    #8 vB_Session->save() called in [path]/vb/shutdown.php on line 86
    #9 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 508
    #10 vB::shutdown() called in  on line
    Code:
    Database error in vBulletin 4.2.5:
    
                Invalid SQL:
    INSERT  IGNORE  INTO session (`sessionhash`,`userid`,`host`,`idhash`,`lastactivity`,`location`,`styleid`,`languageid`,`loggedin`,`inforum`,`inthread`,`incalendar`,`badlocation`,`useragent`,`bypass`,`profileupdate`,`apiclientid`,`apiaccesstoken`,`emailstamp`)
                VALUES('0f6e0bfbf1dc628c289b16f2c4b8a396',0,'216.52.89.77','74b723ff847a90187790494a74fa42cb',1547680103,'',9,1,0,0,0,0,0,'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13',0,0,0,'',0)
    /**session**/;
    
                MySQL Error   : Unknown column 'emailstamp' in 'field list'
                Error Number  : 1054
                Request Date  : Wednesday, January 16th 2019 @ 06:08:23 PM
                Error Date    : Wednesday, January 16th 2019 @ 06:08:23 PM
                Script        : [URL="https://www.copytechnet.com/forums/ricoh-savin-gestetner-lanier/135490-ftp-scanning-2.html"]https://www.copytechnet.com/forums/r...canning-2.html[/URL]
                Referrer      : [URL="http://www.google.com/"]http://www.google.com[/URL]
                IP Address    : 216.52.89.77
                Username      : Guest
                Classname     : vB_Database_MySQLi
                MySQL Version :
    
    
    Stack Trace:
    #0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
    #1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
    #2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 542
    #3 vB_Database->query_write() called in [path]/vb/db/query/insertignore.php on line 88
    #4 vB_dB_Query_InsertIgnore->doInserts() called in [path]/vb/db/query/insert.php on line 98
    #5 vB_dB_Query_Insert->execSQL() called in [path]/vb/db/assertor.php on line 303
    #6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 475
    #7 vB_dB_Assertor->insertIgnore() called in [path]/vb/session.php on line 503
    #8 vB_Session->save() called in [path]/vb/shutdown.php on line 86
    #9 vB_Shutdown->shutdown() called in [path]/vb/vb.php on line 508
    #10 vB::shutdown() called in  on line
    Last edited by Aneurysm; Fri 18 Jan '19, 10:42am.
    --
    http://www.copytechnet.com - Forums for Copier, Laser Printer, and Fax technicians.

  • #2
    vBulletin doesn't have a field called 'emailstamp' in that table. This appears to be from an improperly installed Add-on product from a third-party.

    Please use the config file to disable the plugin system.

    To do this, edit your includes/config.php file currently on the server by adding the following line after the <?php line:

    define('DISABLE_HOOKS', true);

    Then reupload the config.php file into your forum's includes folder.

    Afterward, go to the ACP -> Plugins & Products and under both 'Manage Products' and 'Plugin Manager' disable all non-vB products and plugins.

    Make sure to go to both the 'Manage Products' and 'Plugin Manager' locations.

    Then remove that line from the config file.

    You can re-enable your Add-on Products one at a time until the error occurs. Contact the author of that Add-on Product for support.

    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    Related Topics

    Collapse

    Working...
    X