chikuru
05-24-2017, 12:55 PM
Database error in vBulletin 4.2.5 Beta 1:
Invalid SQL:
INSERT INTO vb3_postlog
(postid, useragent, ipaddress, dateline)
VALUES
(9252088, 'Mozilla/5.0 (Linux; Android 7.0; SAMSUNG SM-G925F Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/5.0 Chrome/51.0.2704.106 Mobile Safari/537.36', '88.202.43.94', 1495637348);
MySQL Error : Unknown column 'ipaddress' in 'field list'
Error Number : 1054
--------------- Added 1495645157 at 1495645157 ---------------
I re-run the upgrade and it hangs here:
Status: Processing 4.2.5 Beta 2, Step 10 of 16
State: Waiting for table metadata lock, Query: ALTER TABLE vb3_searchcore CHANGE ipaddress ipaddress VARCHAR(45) NOT NULL DEFAULT ''
Invalid SQL:
INSERT INTO vb3_postlog
(postid, useragent, ipaddress, dateline)
VALUES
(9252088, 'Mozilla/5.0 (Linux; Android 7.0; SAMSUNG SM-G925F Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/5.0 Chrome/51.0.2704.106 Mobile Safari/537.36', '88.202.43.94', 1495637348);
MySQL Error : Unknown column 'ipaddress' in 'field list'
Error Number : 1054
--------------- Added 1495645157 at 1495645157 ---------------
I re-run the upgrade and it hangs here:
Status: Processing 4.2.5 Beta 2, Step 10 of 16
State: Waiting for table metadata lock, Query: ALTER TABLE vb3_searchcore CHANGE ipaddress ipaddress VARCHAR(45) NOT NULL DEFAULT ''