Warning! Avatar directory not found. Continuing may be unsafe. Please confirm folder settings before proceeding. Warning! One or more attachment directories not found. Continuing may be unsafe. Please confirm folder settings before proceeding. * 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 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 datesUnsuccessful! Database error message: Out of range value for column 'id_holiday' at row 1