Database error in vBulletin 4.2.5:

[Wayne Luke]

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.

[Aneurysm]

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!

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

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