Upgrade from SMF 1.1.x to 2.0.5 > Server has not responded for 30 seconds Error

[chase78]

Dear all,

Hope someone can help. Please advise...

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: "Cleaning up database..." (8 of 19 - of this script)

Error text is as below:

Updating indexes on "messages"...done
Updating table indexes...done
Reordering boards and categories...done
Updating indexes and data on "smileys"...done
Updating indexes on "log_boards"...done
Updating indexes on "log_mark_read"...done
Updating indexes on "themes"...done
Updating data in "settings"...done
Adding new settings...done
Adding PM spam protection settings...done
Cleaning old values from "settings"...done
Encoding SMTP password...done
Adjusting timezone settings...done
Installing theme settings...done
Renaming personal message tables...done
Updating indexes on "pm_recipients"...done
Updating columns on "pm_recipients"...done
Updating columns on "members"...done
Updating columns on "members" - part 2...done
Updating member approval...done
Adding new holidays...done
Updating event start and end dates...done
Converting other date columns...done
Checking for an old table...done
Creating "message_icons"...done
Inserting "message_icons"...done
Creating "package_servers"...done
Inserting "package_servers"...done
Updating flood control log...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

[chase78]

I have quite some mods installed. Should I set the forum to non maintenance and remove the mods?

My webshot is Hostgator and have asked them to increase timeout to max.

Mysql version is 5.5.23

[margarett]

The upgrade is an intense process to the server. Your host is one of the famous oversellers and MySQL server "dies" during the process.

My advice: run the converter in your localhost, if you're comfortable with that.

[Colin]

I am sorry that you are having trouble.

How large is your forum?

[chase78]

My forum has been around for 5 years. The backup is 235MB. I cannot really see the number of posts now as it is in the maintenance / upgrade mode. As we speak the upgrade is still hung at the same line.

When you say run in localhost, it means run on my computer? I go search the board to see how to do so.

[chase78]

Time elapsed always shows...

Time Elapsed: 0 mins, 29 seconds.


Progress

    Step 1: Login
    Step 2: Upgrade Options
    Step 3: Backup
    Step 4: Database Changes
    Step 5: Delete Upgrade

27%
Overall Progress

20%
Step Progress

[chase78]

Now when I remove the maintenance mode, I get this error...

Unknown column 'a.attachment_type' in 'field list'

Sigh...

Please, can anyone help?

[chase78]

a lot of gurus here... hope someone can help.

So should I run the repair_settings file to reset? I see that the repair settings is for v 2, while I was on SMF 1, upgrading to 2. Should I continue still?

[Goodies]

Hi Chase78,

First, this 30-sec is NOT a showstopper. The server will proceed when your browser sends a new request to it (in about 30 sec) so as long as your browser (and your PC) is on, the 30-sec will proceed.

You will mainly have to wait for 1] the search cache build (14 of 19) and 2] the attachment conversions.

For the (14 of 19) wait, it seems unnecesary, there is a solution.

Deactivate this line in subs.php,

//   $words = un_htmlspecialchars($smcFunc['strtolower']($words));

I'm currently doing a similar conversion, coming from 1.08 with mods.

I posted a topic with my adventures some weeks ago with a few tips to overcome several waits,

http://www.simplemachines.org/community/index.php?topic=512234.0

Be carefull with the mods. And make sure you upload your attachments. I did not do that and I ran into a few problems.

Lx

[chase78]

when u say attachment conversions, you mean photo attachments on the forum? I disabled all attachments.

[chase78]

It seems there is some progress, after 12 hours... my computer had hibernated in the meantime.

so should i edit the subs.php still or continue to wait?


28%

Overall Progress

21.2%

Step Progress

[chase78]

Ok... I removed the line in subs.php... and re-run the upgrade script. But now stuck at the same phase 8 of 19...

[chase78]

I dont think I cant wait for longer for my forum to be back up and running.

What is the best way to restore back to 1.0? how do I load back the backed up database and restore everything back? Do i re upload the old php forum 1.1.x php files?

[chase78]

i will wait a bit more... the progress is faster today after commenting out the line as Goodies suggested.

But please, if anyone has more advice, please let me know.

[chase78]

ok i restored the forum and removed mods. Now when I run the upgrade script... it is stuck at same part. sigh.

[margarett]

As I've told you...

The upgrade is an intense process to the server. Your host is one of the famous oversellers and MySQL server "dies" during the process.
My advice: run the converter in your localhost, if you're comfortable with that.

[kat]

If you ask your host to raise these (in php.ini):

upload_max_filesize = 2M (or whatever size you want)

max_execution_time = 60 (also, higher if you need).

...the script might work. But, your host may well either refuse, point-blank, or demand a pot of cash.

[chase78]

As I've told you...

The upgrade is an intense process to the server. Your host is one of the famous oversellers and MySQL server "dies" during the process.
My advice: run the converter in your localhost, if you're comfortable with that.

Thanks... i will look to how to run converter in localhost. I will try to figure this part out. Thanks.

[chase78]

If you ask your host to raise these (in php.ini):

upload_max_filesize = 2M (or whatever size you want)

max_execution_time = 60 (also, higher if you need).

...the script might work. But, your host may well either refuse, point-blank, or demand a pot of cash.

Thanks. Their response...

safe mode = Off (cannot adjust)
memory_limit = 256M (MAXIMUM)
max_execution_time = 30 (MAXIMUM in seconds)
max_input_time = 60 (MAXIMUM in seconds)
post_max_size = 64M (MAXIMUM)
upload_max_filesize = 64M (MAXIMUM)
enable_dl = Off (cannot adjust)

You are right. Seems like they dont budge.

[chase78]

As I've told you...

The upgrade is an intense process to the server. Your host is one of the famous oversellers and MySQL server "dies" during the process.
My advice: run the converter in your localhost, if you're comfortable with that.

Hi... i am trying to put this together...
1. so when I install the WAMP or XAMPP, the database and SMF files are moved to this localhost computer.
2. I run the upgrade.php.
3. The database has been modifed.
4. I upload this new 2.2.x database to the hostgator webhost to replace my old 1.1.x database.

The steps are as above?