Announcement

**charlesr** · Sun 7 Jul '19, 11:26pm

From the log (although it's possible this is unrelated, but unlikely since it's a test server with only me with access):

Invalid SQL:
INSERT IGNORE INTO session (`sessionhash`,`userid`,`host`,`idhash`,`lastactivity`,`location`,`styleid`,`languageid`,` loggedin`,`inforum`,`inthread`,`incalendar`,`badlocation`,`useragent`,`bypass`,`profileupd ate`,`apiclientid`,`apiaccesstoken`,`emailstamp`)
VALUES('30aaefaf7a1b54daa7a972552671e976',0,'90.240.250.5','0c21ec26503b70f5f4a773251315dd a4',1562566368,'',118,1,0,0,0,0,0,'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.100 Safari/537.36',0,0,0,'',0)
/**session**/;

MySQL Error : Unknown column 'emailstamp' in 'field list'
Error Number : 1054
Request Date : Monday, July 8th 2019 @ 06:12:48 AM
Error Date : Monday, July 8th 2019 @ 06:12:49 AM
Script : removed by me
Referrer :
IP Address : 90.240.250.5
Username : Guest
Classname : vB_Database_MySQLi
MySQL Version :

Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1203
#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 557
#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 301
#6 vB_dB_Assertor->assertQuery() called in [path]/vb/db/assertor.php on line 473
#7 vB_dB_Assertor->insertIgnore() called in [path]/vb/session.php on line 593
#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 483
#10 vB::shutdown() called in on line

**Wayne Luke** · Mon 8 Jul '19, 8:58am

The script information is important. This is the 5.0.0 Alpha 1 script?

The emailstamp field isn't added until 5.0.4. The poll table is converted in 5.0.0. Alpha 1. The most likely cause of the Poll issue is duplicate votes in the table. There wasn't an index on this table to prevent duplicate votes in the 3.X era.

For a board your size, the command line script is the better option to upgrade.

**charlesr** · Mon 8 Jul '19, 9:23am

Ah yeah, sorry should have looked at the script. I believe it was that 5.0Alpha1 yes. Cheers. Should be ok if that's all it was then. Rest all was smooth.

And yeah, it took "some time" using the browser upgrage

I'll try the whole thing again with the command line one too.

Announcement

vb4 to vb5 upgrade. Altering poll Table (1 of 1) Step 152 - Unexpected Text

vb4 to vb5 upgrade. Altering poll Table (1 of 1) Step 152 - Unexpected Text

Comment

Comment

Comment

Related Topics