2.0 RC5 to 2.0.2 help requested

[dknife]

So I've been running 2.0 RC5 for eons now, mostly because I've been procrastinating upgrading it due to my custom integration into my website and custom code I've added in (yes I know, don't berate me). I do have any custom additions flagged though so it's fairly simple for me to add them in again.

So I was testing an upgrade today to 2.0.2 and I seem to be having issues. I basically downloaded the database and all files to my dev ubuntu box and duplicated everything. The forum worked fine with the integration into my website. I then unzipped the 2.0.2 Large upgrade zip file into the forum directory and ran the upgrade. It gave me a warning about the local directory structure being different but I ignored it as I have the correct one symlinked to match what it is on my real host (hence the forum worked).

I get to the point where it starts upgrading the database and gets stuck on "Changing column names". After 30 seconds it warns nothing is responding. For detailed response, it displays:

Renaming table columns...done
Converting "log_online"...done

And that's it, just stalls there. It's not a huge forum (only around 8000 or so posts) and there's no mysql process with high cpu or anything.

Any suggestions?

[dknife]

Are there any logs files or something to determine what's going on? I just tried a fresh copy of the database and files, reverted to default theme so it doesn't have any of my code and it does exactly the same thing. So I'm basically stuck on 2.0RC5 unless I can figure out how to upgrade.

[emanuele]

Are you using a MySQL database?

[dknife]

Yes I am, 5.5.28

[emanuele]

mmm...that's curious...
The update of the log_online table is a rather easy one: drop the table, create a new one...
While you are running the upgrade, when you get the error, please have a look that the database if the table (log_online) is there.
Another thing you may try is to disable javascript and do the upgrade step by step (a bit boring, but since the forum is not big and it's already at RC% should be quick).

ETA: and just while I'm at it: did you convert any table to innodb?

[dknife]

Yes the smf_log_online is there present, and empty. I checked the table formats and somehow the smf_log_search_words table was innodb, all others were MyISAM. I converted it to MyISAM as well however it gets stuck at the same spot.

I tried Firefox instead of Chrome and I disabled Javascript. I now get a blank page with "Duplicate column name 'redirect'" instead of the normal wizard. Does this help?

[dknife]

Seems to be in the smf_boards alter table command? Bypassing that (since it's already there), i get a further "Duplicate column name 'id_hit'" which is from _log_spider_hits?

[emanuele]

mmm...the duplicate errors should be ignored by upgrade.php...
So it just gives you the error and then the script dies?

[dknife]

Yep, sits there and does nothing. Is there some kind of configuration in sql or php which would halt on errors? I've removed my dev server error handling in php.ini and it still does it.

All the ALTER TABLE commands halt the script, I can comment them out and it goes through each part without problem, but obviously that's not really a solution.

Where is the mysql error capturing done?

[dknife]

It works if I comment out these lines in Subs-Db-mysql.php lol

if ($ret === false && empty($db_values['db_error_skip']))
   $ret = smf_db_error($db_string, $connection);

[dknife]

The upgrade script works fine on my live site, so whatever settings are on my dev server were causing this fault.

Live server is PHP 5.3.16 and MySQL 5.1.62
Dev server is PHP 5.4.4 and MySQL 5.5.28

[emanuele]

Okay...then it could be either MySQL or php 5.4...
By chance do you have shosin on the dev?

[dknife]

No I don't have Suhosin as it wasn't available when I moved to 5.4.

If it matters, my dev environment is Litespeed, whereas my webhost is Apache.