Topic: 2.0.15 to 2.1 Beta 4 Database Changes Error Server has not responded for 30 seco

[Kindred]

Wrong order of steps.
get 2.0,x running in your new folder BEFORE starting any copy or other upgrade process.

Make sure 2.0.x is running correctly in that location with its own database.

THEN start the upgrade process by replacing the files.

[Illori]

i think that is what the user said was done, or that is how i read it at least.

[Kindred]

ummm.... maybe I misread it.

[shawnb61]

Yeah, that's what I think is meant by:

forum control everything looks fine  test ok.

What bugs me is that it can clearly connect, but it barfs as soon as it tries to manipulate the DB.   And it never gets past the VERY FIRST step...  (Which is old 2.0 stuff, just a safety measure...)


New question:  Does the user you are using in repair_settings.php & in Settings.php have *ALL* privileges necessary to alter the database?   

Grant that DB user EVERYTHING...

[shawnb61]

(Note I split snrj's language-related post to a separate topic:
https://www.simplemachines.org/community/index.php?topic=559373.0  ...)

[gevv]

Yes *ALL*

[albertlast]

Based on the vid from snrj,
i created a pr how should fix the issue: https://github.com/SimpleMachines/SMF2.1/pull/4635
Only this three lines are realy needed: https://github.com/albertlast/SMF2.1/blob/0c81146e2e6db4037fbf30b0d30edd4fc237a67c/other/upgrade.php#L482-L484

[gevv]

problem solved   (solution: https://www.simplemachines.org/community/index.php?topic=559373.0)

thanks @snrj and others

[shawnb61]

This is an issue & it is confirmed.

If you start the upgrade process with a language other than English, AND, you do not clear out the Themes directory beforehand, you have numerous challenges.  The DB hanging issue above, & depending on your environment, you may get a bunch of 'undefined index' messages as well. 

I'll log a 2.1 issue for this.  It should handle this more gracefully.

EDIT:  Issue logged - https://github.com/SimpleMachines/SMF2.1/issues/4636