Error when upgrading 1.1.11 to 2.0.rc4

[deziner]

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

[Deaks]

1. did you back up your db first.
". id suggest checking your search table in the db for any errors

[deziner]

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

[Deaks]

how did you backup?

[deziner]

I backed up both the database and site through cPanel

[Deaks]

so you have a .sql version of your db?

[deziner]

yes

[Deaks]

ok open that up with notepad and go to very end ... is there an error?

[deziner]

No error

Last line of code

-- Dump completed on 2010-11-18 23:04:00

[Deaks]

how big is your search table?

[deziner]

122.9kb

[Deaks]

I would suggest emptying the content (not the structure) then trying upgrade again.  If you need better instructions please say

[deziner]

Thank you I am in the process of doing exactly that right now

[Deaks]

i hope you did realise i mean of search table... not always best at explaining things sorry

[deziner]

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

[Deaks]

happy to help