Hello!
I got an error in one of the steps of the upgrade from 4.2.2 to 5.1.9
Investigating the files vb4/install/mysql-schema.php (this file does not exist in the repository during the upgrade process, I only checked it to understand how the table is created) and vb5/core/install/mysql-schema.php, I see that the table created in the version 4 doesn't have the column emailstamp, whereas the version 5 has emailstamp (but maybe the create table sql isn't performed, once the table already exists).
Note: even though the upgrade process stops, if I reopen the upgrade page and continue the process, I can finish the upgrade and the table session will contain field emailstamp.
As far as I read, at the first error, I should stop the upgrade process.
What should I do? Should I simply alter my table before the upgrade to 5.1.9?
Thanks in advance!
I got an error in one of the steps of the upgrade from 4.2.2 to 5.1.9
Database error in vBulletin 5.0.0 Alpha 27:
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('2ceea9450c8375d9030083a3c5e5ff20',0,'10.0.2.2','58e6fef706f97092a606fa4cb78f55c7', 1442427660,'',21,1,0,0,0,0,0,'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:40.0) Gecko/20100101 Firefox/40.0',0,0,0,'',0)
/**session**/;
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('2ceea9450c8375d9030083a3c5e5ff20',0,'10.0.2.2','58e6fef706f97092a606fa4cb78f55c7', 1442427660,'',21,1,0,0,0,0,0,'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:40.0) Gecko/20100101 Firefox/40.0',0,0,0,'',0)
/**session**/;
Note: even though the upgrade process stops, if I reopen the upgrade page and continue the process, I can finish the upgrade and the table session will contain field emailstamp.
As far as I read, at the first error, I should stop the upgrade process.
What should I do? Should I simply alter my table before the upgrade to 5.1.9?
Thanks in advance!
Comment