Tried to upgrade from 1.1.20 to 2.0.9

Started by Skuzzy, February 06, 2015, 01:59:34 PM

Previous topic - Next topic

permutations

I deleted the message you're responding to so I could move the discussion back over to the other thread. I posted here by accident.

Here it is again:
Quote
Ugh - the table log_cache (which I guessed was the table the script times out on - and while I'm typing this message you confirmed) is not in the database, weirdly. Did upgrade.php delete it?

I'm afraid I need to start again - delete everything, reclone the site, empty all caches, run repair_settings.php, move the SMF 2.0 files over, run upgrade.php. :(

How did the table get deleted??

It's weird, though - I have other tables that have much more data than this one. The sessions table is over 1GB. Maybe I should truncate that one, too?

I'm going to try copying just the structure of log_cache from the update site, truncate the sessions table, and restart. Hopefully it will complete.

"log_cache" was a typo. I meant "log_search". In any case, it didn't work. I need to start again. :(



permutations

I'm having continuing problems, but I went back to posting in the original thread. Here's the link, if anyone is interested (or kind enough to help):

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

permutations

The problem I was having with the upgrade script hanging had a different cause. FYI (for anyone else upgrading to SMF 2.0 from an early version of SMF 1.1)...

I was upgrading from SMF 1.1 Beta 3 to SMF 2.0.10. I had to first upgrade to SMF 1.1.21 for the SMF 2.0 upgrade script to work. This is because the early versions of SMF 1.1 used one search cache table, log_search, while the latest versions of SMF 1.1.21 - and SMF 2.0 - use four: log_search_*. The upgrade script was hanging when it tried to update the search cache because it was looking for four tables, finding only one, and not handling the error gracefully.

Advertisement: