Problems trying to upgrade from 2.0.19 to 2.1.4

[owg]

I extracted the large upgrade into my 2.0.19 install and then ran upgrade.php. All seemed to go fine but got stuck at the Table: "log_search_subjects" (progress 85%, step progress 56%).

I tried to do the command line execution of upgrade.php as suggested on another thread and all went fine with no errors. However when trying to enter the site it only displays the maintenance mode message on a blank white page.

Any ideas? Any tips would be greatly appreciated!


Below is the output:

Converting to UTF-8
Please wait while your database is converted to UTF-8. For large forums this may take some time!
Completed 68 out of 121 tables.

Completed Table: "2sichat".
Completed Table: "2sichat_barlinks".
Completed Table: "2sichat_error".
Completed Table: "2sichat_gadgets".
Completed Table: "2sichat_typestaus".
Completed Table: "admin_info_files".
Completed Table: "approval_queue".
Completed Table: "attachments".
Completed Table: "attachmentsPreREI".
Completed Table: "background_tasks".
Completed Table: "ban_groups".
Completed Table: "ban_items".
Completed Table: "board_permissions".
Completed Table: "board_permissions_view".
Completed Table: "boards".
Completed Table: "calendar".
Completed Table: "calendar_holidays".
Completed Table: "categories".
Completed Table: "custom_fields".
Completed Table: "down_cat".
Completed Table: "down_catperm".
Completed Table: "down_comment".
Completed Table: "down_creport".
Completed Table: "down_custom_field".
Completed Table: "down_custom_field_data".
Completed Table: "down_file".
Completed Table: "down_groupquota".
Completed Table: "down_rating".
Completed Table: "down_report".
Completed Table: "down_userquota".
Completed Table: "feedbot".
Completed Table: "feedbot_log".
Completed Table: "gallery_cat".
Completed Table: "gallery_comment".
Completed Table: "gallery_pic".
Completed Table: "gallery_report".
Completed Table: "group_moderators".
Completed Table: "kb_articles".
Completed Table: "kb_attachments".
Completed Table: "kb_category".
Completed Table: "kb_catperm".
Completed Table: "kb_comments".
Completed Table: "kb_log_actions".
Completed Table: "kb_rating".
Completed Table: "kb_reports".
Completed Table: "log_actions".
Completed Table: "log_activity".
Completed Table: "log_banned".
Completed Table: "log_boards".
Completed Table: "log_comments".
Completed Table: "log_digest".
Completed Table: "log_enotify_pms".
Completed Table: "log_enotify_replies".
Completed Table: "log_errors".
Completed Table: "log_floodcontrol".
Completed Table: "log_group_requests".
Completed Table: "log_httpBL".
Completed Table: "log_mark_read".
Completed Table: "log_member_notices".
Completed Table: "log_notify".
Completed Table: "log_online".
Completed Table: "log_packages".
Completed Table: "log_polls".
Completed Table: "log_reported".
Completed Table: "log_reported_comments".
Completed Table: "log_scheduled_tasks".
Completed Table: "log_search_messages".
Completed Table: "log_search_results".
Current Table: "log_search_subjects"

[Aleksi "Lex" Kilpinen]

That can be a big table, it can simply take a while - And by a while, I mean a long time.
But if everything went OK with the CLI, and you are only stuck at maintenance, you can get out of it by editing the related setting in Settings.php

[owg]

Thank you so much!

I feel kind of stupid that the problem was a simple edit of settings.php 

[Aleksi "Lex" Kilpinen]

No worries, I'm fairly sure we've all been there.