Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: owg on April 09, 2024, 02:16:42 PM

Title: Problems trying to upgrade from 2.0.19 to 2.1.4
Post by: owg on April 09, 2024, 02:16:42 PM
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"
Title: Re: Problems trying to upgrade from 2.0.19 to 2.1.4
Post by: Aleksi "Lex" Kilpinen on April 09, 2024, 02:25:00 PM
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
Title: Re: Problems trying to upgrade from 2.0.19 to 2.1.4
Post by: owg on April 09, 2024, 03:37:11 PM
Thank you so much!

I feel kind of stupid that the problem was a simple edit of settings.php  :-[
Title: Re: Problems trying to upgrade from 2.0.19 to 2.1.4
Post by: Aleksi "Lex" Kilpinen on April 09, 2024, 04:33:23 PM
No worries, I'm fairly sure we've all been there. :)