Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: deziner - marraskuu 22, 2010, 08:28:58 AP

Otsikko: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: deziner - marraskuu 22, 2010, 08:28:58 AP
Hello,
Everything seemed to be going fine with the upgrade. While running the upgrade I got an error in step 4 (database Changes) it got to 14 of 19 and hung up. I have tried for yours to get this past this point. I have added a screenshot

This is where it hangs:
Executing: "Updating search cache..." (14 of 19 - of this script)


Please let me know if there is a way to skip this step (14) and move on or any other fix.
Thank you for your help


Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: Deaks - marraskuu 22, 2010, 01:13:37 IP
1. did you back up your db first.
". id suggest checking your search table in the db for any errors
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: deziner - marraskuu 22, 2010, 02:16:45 IP
Yes. I backed up the site and database. After I got this error I uploaded the backup and checked the entire database for errors and the ran the upgrade again and it stopped in the same spot.
Any other ideas where I could proceed from here?

Thank you for your response
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: Deaks - marraskuu 22, 2010, 02:18:09 IP
how did you backup?
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: deziner - marraskuu 22, 2010, 02:21:45 IP
I backed up both the database and site through cPanel
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: Deaks - marraskuu 22, 2010, 02:23:27 IP
so you have a .sql version of your db?
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: deziner - marraskuu 22, 2010, 02:25:31 IP
yes
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: Deaks - marraskuu 22, 2010, 02:26:36 IP
ok open that up with notepad and go to very end ... is there an error?
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: deziner - marraskuu 22, 2010, 02:31:34 IP
No error

Last line of code

-- Dump completed on 2010-11-18 23:04:00
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: Deaks - marraskuu 22, 2010, 02:35:06 IP
how big is your search table?
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: deziner - marraskuu 22, 2010, 02:48:00 IP
122.9kb
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: Deaks - marraskuu 22, 2010, 07:33:43 IP
I would suggest emptying the content (not the structure) then trying upgrade again.  If you need better instructions please say :)
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: deziner - marraskuu 22, 2010, 07:39:56 IP
Thank you I am in the process of doing exactly that right now
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: Deaks - marraskuu 22, 2010, 07:45:41 IP
i hope you did realise i mean of search table... not always best at explaining things sorry
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: deziner - marraskuu 23, 2010, 06:55:20 IP
Yes I was able to fix the issue. I had recreated the forum for testing purposes before upgrading the actual forum. The resolution for me was in the database tables where there were paths. The paths had pointed to my original forum (/forum) and my new test forum was in a directory called (/forum2) Once I corrected the paths everything ran perfect on the upgrade. Thank you for taking the time to help me through this issue. Having this forum for problem solving is a great asset and i appreciate all the time forum members and moderators take to answer questions.

Thank you
DeZiner
Otsikko: Re: Error when upgrading 1.1.11 to 2.0.rc4
Kirjoitti: Deaks - marraskuu 23, 2010, 07:10:54 IP
happy to help :)