* Updating Settings.php... Successful.
 *  +++  Updating old values done.
 +++  Changing default values done.
 Successful.
 *  +++  Removing all karma data, if selected done.
 Successful.
 *  +++  Emptying error log, if selected done.
 Successful.
 *  +++  Adding login history... done.
 +++  Copying the current package backup setting... done.
 +++  Copying the current "allow users to disable word censor" setting... done.
 +++  Converting collapsed categories... done.
 +++  Parsing board descriptions and names done.
 +++  Dropping "collapsed_categories" done.
 +++  Adding new "topic_move_any" setting done.
 +++  Adding new "enable_ajax_alerts" setting done.
 +++  Adding new "alerts_auto_purge" setting done.
 +++  Adding new "minimize_files" setting done.
 +++  Collapse object done.
 +++  Adding new "DEFAULTMaxListItems" setting done.
 +++  Adding new "loginHistoryDays" setting done.
 +++  Enable some settings we ripped from Theme settings done.
 +++  Adding new "httponlyCookies" setting done.
 +++  Adding new "samesiteCookies" setting done.
 +++  Calculate appropriate hash cost +++  Disable Moderation Center Security if it doesn't exist done.
 +++  Adding new profile data export settings done.
 +++  Adding settings for marking boards as read done.
 Successful.
 *  +++  Adding more space to the mime_type column. done.
 +++  Converting legacy attachments. done.
 +++  Note attachment conversion complete done.
 +++  Fixing invalid sizes on attachments done.
 +++  Fixing attachment directory setting... done.
 Successful.
 *  +++  Adding new columns to log_group_requests done.
 +++  Adjusting the indexes for log_group_requests done.
 Successful.
 *  +++  Adding support for <credits> tag in package manager done.
 +++  Adding support for package hashes done.
 +++  Adding support for validation servers done.
 +++  Add Package Validation to Downloads Site done.
 +++  Ensure The Simple Machines Customize Site is https done.
 +++  Add validation to Simple Machines Customize Site done.
 Successful.
 *  +++  Altering the session_id columns... done.
 Successful.
 *  +++  Adding new columns to topics .. done.
 Successful.
 *  +++  Adding a new column "callable" to scheduled_tasks table done.
 +++  Adding new scheduled tasks done.
 +++  Adding a new task-related setting... done.
 +++  Remove old tasks added by modifications... done.
 +++  Adding the new table done.
 Successful.
 *  +++  Adding new columns to boards... done.
 Successful.
 *  +++  Adding the boardindex_max_depth setting. done.
 Successful.
 *  +++  Removing manage_boards permission done.
 Successful.
 *  +++  Adding new columns to categories... done.
 Successful.
 *  +++  Adding the count to the members table... done.
 +++  Adding the new table for alerts. done.
 +++  Adding alert preferences. done.
 +++  Upgrading post notification settings done.
 +++  Dropping old notification fields from the members table done.
 +++  Upgrading auto notify setting done.
 +++  Dropping old auto notify settings from the themes table done.
 +++  Creating alert prefs for watched topics done.
 +++  Creating alert prefs for watched boards done.
 +++  Updating obsolete alerts from before RC3 done.
 +++  Adding index on id_board to log_notify table done.
 Successful.
 *  +++  Adding new column to log_topics... done.
 +++  Fixing column name change... done.
 Successful.
 *  +++  Altering mil_queue table... done.
 Successful.
 *  +++  Altering the membergroup stars to icons done.
 +++  Renaming default theme... done.
 +++  Fader time update done.
 +++  Adding the enableThemes setting. done.
 +++  Setting "default" as the default... done.
 Successful.
 *  +++  Check the current saved names for icons and change them to the new name. done.
 Successful.
 *  +++  Clean up settings for unused themes done.
 Successful.
 *  +++  Adding new field_order column... done.
 +++  Adding new show_mlist column... done.
 +++  Insert fields done.
 +++  Add an order value to each existing cust profile field. done.
 +++  Converting member values... done.
 +++  Dropping old fields done.
 +++  Create the displayFields setting done.
 Successful.
 *  +++  Creating draft table done.
 +++  Adding draft permissions... done.
 Successful.
 *  +++  Creating likes table. done.
 +++  Adding likes column to the messages table. (May take a while) done.
 Successful.
 *  +++  Creating mentions table done.
 Successful.
 *  +++  Creating moderator_groups table done.
 Successful.
 *  +++  Deleting integration hooks done.
 Successful.
 *  +++  Fixing a deprecated option. done.
 +++  Cleaning up the old Core Features page. done.
 +++  Cleaning up old settings. done.
 +++  Cleaning up old theme settings. done.
 +++  Update the SM Stat collection. done.
 Successful.
 *  +++  We no longer call on several files. done.
 +++  But we do need new files. done.
 Successful.
 *  +++  Creating qanda table done.
 +++  Moving questions and answers to the new table done.
 Successful.
 *  +++  Updating log_packages done.
 Successful.
 *  +++  Removing the old "view your own profile" permission done.
 +++  Updating the old "view any profile" permission done.
 +++  Removing the old notification permissions done.
 +++  Removing the send-topic permission done.
 +++  Removing the draft "autosave" permissions done.
 +++  Adding "profile_password_own" done.
 +++  Adding "view_warning_own" and "view_warning_any" permissions done.
 +++  Adding other profile permissions done.
 Successful.
 *  +++  Adding pm_labels table... done.
 +++  Adding pm_labeled_messages table... done.
 +++  Adding "in_inbox" column to pm_recipients done.
 +++  Moving label info to new tables and updating rules (May be slow!!!) done.
 Successful.
 *  +++  Adding "modified_reason" column to messages (May take a while) done.
 Successful.
 *  +++  Removing permissions guests can no longer have... done.
 Successful.
 *  +++  Adding DEFAULT settings for the mail queue done.
 Successful.
 *  +++  Adding DEFAULT gravatar settings done.
 Successful.
 *  +++  Adding the "timezone" column to the members table done.
 +++  Converting time offset to timezone done.
 Successful.
 *  +++  Removing the "send_email_to_members" permission done.
 +++  Dropping the "hide_email" column from the members table done.
 +++  Dropping the "email_address" column from log_reported_comments done.
 Successful.
 *  +++  Removing the task and associated data done.
 Successful.
 *  +++  Removing the openid_uri column in the members table done.
 +++  Dropping the openid_assoc table done.
 +++  Removing related settings done.
 Successful.
 *  +++  Changing url column size in log_spider_hits from 255 to 1024 done.
 +++  Changing url column in log_online from TEXT to VARCHAR(1024) done.
 Successful.
 *  +++  Adding the secret column to members table done.
 +++  Adding the backup column to members table done.
 +++  Force 2FA per membergroup done.
 +++  Add tfa_mode setting done.
 Successful.
 *  +++  Duplicates to messages_current_topic done.
 +++  Duplicate to topics_last_message_sticky and topics_board_news done.
 Successful.
 *  +++  Add columns to ban_items done.
 +++  Convert data for ban_items done.
 +++  Create new index on ban_items done.
 +++  Dropping columns from ban_items done.
 Successful.
 *  +++  Remove the old ip column done.
 +++  Add the new one done.
 Successful.
 *  +++  Delete old column log banned ip done.
 +++  Add the new log banned ip done.
 Successful.
 *  +++  Delete old log errors ip column done.
 +++  Add the new ip columns to log errors done.
 +++  Add the ip index for log errors done.
 Successful.
 *  +++  Rename old ip columns on members done.
 +++  Add the new ip columns to members done.
 +++  Create an ip index for old ips done.
 +++  Initialize new ip columns done.
 +++  Convert member ips done.
 +++  Convert member ips2 done.
 +++  Remove the temporary ip indexes done.
 +++  Remove the old member columns done.
 Successful.
 *  +++  Rename old ip column on messages done.
 +++  Add the new ip column to messages done.
 +++  Create an ip index for old ips done.
 +++  Initialize new ip column done.
 +++  Convert ips on messages done.
 +++  Remove the temporary ip indexes done.
 +++  Drop old column to messages done.
 +++  Add the index again to messages poster ip topic done.
 +++  Add the index again to messages poster ip msg done.
 Successful.
 *  +++  Prep floodcontrol done.
 +++  Add the new floodcontrol ip column done.
 +++  Modify log_type size done.
 +++  Create primary key for floodcontrol done.
 Successful.
 *  +++  Delete the old ip column for log online done.
 +++  Add the new ip column for log online done.
 Successful.
 *  +++  Drop old ip column for reported comments done.
 +++  Add the new ip column for reported comments done.
 Successful.
 *  +++  Drop old ip columns for member logins done.
 +++  Add the new ip columns for member logins done.
 Successful.
 *  +++  Changing the "profile_other" permission to "profile_website" done.
 Successful.
 *  +++  Upgrading pm notification settings done.
 +++  drop column pm_email_notify on table members done.
 Successful.
 *  +++  Add start_time end_time, and timezone columns to calendar table done.
 +++  Update cal_maxspan and drop obsolete cal_allowspan setting done.
 Successful.
 *  +++  Add location column to calendar table done.
 Successful.
 *  +++  Update the max year for the calendar done.
 +++  Adding various calendar settings done.
 Successful.
 *  +++  Update the members' languages done.
 Successful.
 *  +++  Add Index for messages likes done.
 Successful.
 *  +++  Updating board_permissions done.
 +++  Updating log_digest id_topic done.
 +++  Updating log_digest id_msg done.
 +++  Updating log_reported done.
 +++  Updating log_spider_hits done.
 +++  Updating members new_pm done.
 +++  Updating members pm_ignore_list done.
 +++  Updating password_salt done.
 +++  Updating member_logins id_member done.
 +++  Updating member_logins time done.
 +++  Updating pm_recipients is_new done.
 +++  Updating pm_rules id_member done.
 +++  Updating polls guest_vote done.
 +++  Updating polls id_member done.
 +++  Updating sessions last_update done.
 Successful.
 *  +++  Updating log_actions done.
 +++  Updating log_activity mostOn done.
 +++  Updating log_activity most_on done.
 +++  Updating log_subscribed done.
 +++  Updating members email_address done.
 +++  Updating members drop memberName done.
 +++  Updating members active_real_name (drop) done.
 +++  Updating members active_real_name (add) done.
 +++  Updating messages drop old ipIndex done.
 +++  Updating messages drop old ip_index done.
 +++  Updating messages drop old related_ip done.
 +++  Updating messages drop old topic ix done.
 +++  Updating messages drop another old topic ix done.
 +++  Updating messages drop approved ix done.
 +++  Updating messages drop approved ix alt name done.
 +++  Updating messages drop id_board ix done.
 +++  Updating messages drop id_board ix alt name done.
 +++  Updating messages add new id_board ix done.
 +++  Updating topics drop old id_board ix done.
 Successful.
 *  +++  Adding the new `smiley_files` table done.
 +++  Cleaning up unused smiley sets and adding the lovely new ones done.
 Successful.
 *  +++  add backtrace column done.
 Successful.
 *  +++  Create table board_permissions_view +++  upgrade check done.
 done.
 done.
 +++  Update board_permissions_view table with membergroups done.
 +++  Update board_permissions_view table with -1 done.
 +++  Update board_permissions_view table with 0 done.
 +++  Update deny board_permissions_view table with membergroups done.
 +++  Update deny board_permissions_view table with -1 done.
 +++  Update deny board_permissions_view table with 0 done.
 Successful.
 *  +++  Delete all the dates done.
 +++  Insert the updated dates done.
 Successful.
 *  +++  Create new index on Attachments done.
 Successful.
 *  +++  make members mod col nullable done.
 +++  make boards mod col nullable done.
 +++  make topics mod col nullable done.
 Successful.
 *  +++  Allow for hyper aggressive crawlers done.
 Successful.
 *  +++  Strip -utf8 from policy settings done.
 +++  Strip -utf8 from agreement file names done.
 +++  Fix missing values in log_actions. done.
 Successful.
 *  +++  Updating primary key for log_search_results table done.
 Successful.

Upgrade Complete!
Please delete this file as soon as possible for security reasons.