MyBB Community Forums

Full Version: Stuck page Updating Database - upgrading issue
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
(2019-11-17, 01:46 PM)kramsman Wrote: [ -> ]
(2019-11-17, 01:40 PM)ChellSpecker Wrote: [ -> ]I am stuck too, I am coming from an old 1.6  and apparantly I am stuck now at the latest 1.6.18,  before the 1.8 .

I tried running the default upgrade to the latest, but its just getting stuck.  My DB is only 12 MB.

So I wanted to it by intervals, but I can not download any of the 1.8 versions, theres no download option on the version page..

https://mybb.com/versions/

How can I solve this?

I'm still in the same place.  My BB is dead and I am hesitant to restore and start again since I've never done a restore and, even if successful, I still don't have a plan forward.  I could really use assistance.

Damn, so support is bad? How long have you been waiting?


_________________________________

*Edit*
I managed to upgrade to 18.13 now (it was the oldest 18 version I could still download on the page), so now I will try to upgrade to the latest.

*Edit 2*

I did it, I am on the latest version now.
The stalled upgrade script is from an error introduced in a recent version.
I have found a recent upgrade finishes in a single process from 1.6.9 to 1.8.21 if I make some changes to the upgrade scripts. There is a fix in the works that should appear in 1.8.22, but you can correct the error in 1.8.21 files.

The script for the Next button needs to be changed from
document.forms[0].trigger('submit');
to
document.forms[0].submit();

This should be done in several files, depending on what version you are upgrading from. I will list them all here.

upgrade12.php (for upgrading from version 1.2.12 through 1.2.14)
lines 180, 192, 216, 241, 277, 303, 772, 848, 1079, 1294, 1449, 1521, 1605, 1770, 1992

upgrade13.php (for upgrading from version 1.4 and 1.4.1)
lines 149, 233

upgrade17.php (for upgrading from version 1.4.13 or 1.4.14)
lines 40, 166, 275, 395, 465, 533, 608, 810, 858

upgrade 30.php (for upgrading from 1.6.14 through 1.6.18)
lines 333, 483, 619, 750, 864, 1307, 1411, 1510, 1585, 2130

upgrade35.php (for upgrading from 1.8.6)
lines 53, 106, 153

Additionally, I had problems with upgrade30.php where I got errors while converting stored ip addresses. I continued to get errors like posted here a couple years ago. https://community.mybb.com/thread-195573.html

I solved it by specifying the modified field sizes from 16 to 24.
line 2065 -- change 16 to 24 in two places ... SUBSTR({$column}, 16) WHERE LENGTH({$column})>16");
line 2074 -- change blob(16) to blob(24)
line 2077 -- change varbinary(16) to varbinary(24)

The ip address conversion went through without a hitch.
Thank you for the post. I was able to muddle through even with some errors. Had to add a table field and remove one along the way, but eventually it worked.
Pages: 1 2