SMF Support > Install and Upgrade Help
Upgrade from 1.1.16 to 2.0.2 error
asmith:
Hello,
I've done this several times on my local hard drive without any problems. Today I tried the real thing online and I'm stuck.
At the very beginning of database, upgrade freezes at this:
--- Quote ---Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!
Executing upgrade script 1 of 2.
Executing: "Updating and creating indexes..." (1 of 19 - of this script)
Updating indexes on "messages"...done
!!Error!
Server has not responded for 30 seconds. It may be worth waiting a little longer or otherwise please click here to try this step again
--- End quote ---
and it just stays there. I click on try again and after some time same result.
PHP 5.4
MySQL 5.5 (old one was 5.1)
Database size is over 400MB.
K@:
Do you have access to your php.ini file, by any chance? Most people don't.
Have a word with your host and ask them to set the timeout higher than thirty seconds (Even if only temporarily)
asmith:
I have root access. I set max_execution_timeto 60. Also I edited upgrade.php and set $timeLimitThreshold to 6.
Still getting the same error and it is saying 60 seconds. Increase the value again? I don't think that's the case. The same db on my local hard drive passes that point in 2-3 seconds or less.
edit: tried 120 too, same thing.
Kindred:
Something is screwy on your server....
I have a database well over 2 gigabytes with something like 2+ million messages. Yes, it took over 24 hours to complete the upgrade process, but it did so without any major timeouts like that...
asmith:
well the site is down and users have started nagging. if I can't figure this out soon, I gotta convert it locally and upload like 120 MB zip online.
Edit: forgot to ask, if I do the conversion offline, should I download my attachments folder and put it there? Or only db is enough?
Navigation
[0] Message Index
[#] Next page
Go to full version