Issue information
-
#035770
-
Cannot Reproduce
-
3.3.0 Beta 1
-
-
-
0 - None Assigned
Issue Confirmations
-
Yes (0)No (0)
1) Fresh install 3.2.3.
2) Install a custom skin (I don't know if this step is necessary)
3) Run upgrader. On step 2 I get this
Error:
CREATE TABLE core_archive_log ( archlog_id INT(10) AUTO_INCREMENT NOT NULL, archlog_app VARCHAR(255) NOT NULL DEFAULT 0, archlog_date INT(10) NOT NULL DEFAULT 0, archlog_ids MEDIUMTEXT, archlog_count INT(10) NOT NULL DEFAULT 0, archlog_is_restore INT(1) NOT NULL DEFAULT 0, archlog_is_error INT(1) NOT NULL DEFAULT 0, archlog_msg TEXT, PRIMARY KEY (archlog_id) ) ENGINE=MyISAM;
Table 'core_archive_log' already exists
Error:
CREATE TABLE core_archive_restore ( restore_min_tid INT(10) NOT NULL DEFAULT 0, restore_max_tid INT(10) NOT NULL DEFAULT 0, restore_manual_tids MEDIUMTEXT ) ENGINE=MyISAM;
Table 'core_archive_restore' already exists
Error:
CREATE TABLE core_archive_rules ( archive_key CHAR(32) NOT NULL DEFAULT '', archive_app VARCHAR(32) NOT NULL DEFAULT 'core', archive_field VARCHAR(255) NOT NULL DEFAULT '', archive_value VARCHAR(255) NOT NULL DEFAULT '', archive_text TEXT NOT NULL, archive_unit VARCHAR(255) NOT NULL DEFAULT '', archive_skip INT(1) NOT NULL DEFAULT 0, PRIMARY KEY (archive_key) ) ENGINE=MyISAM;
Table 'core_archive_rules' already exists
Error:
CREATE TABLE forums_archive_posts ( archive_id INT(10) DEFAULT 0, archive_author_id INT(10) NOT NULL DEFAULT 0, archive_author_name VARCHAR(255) NOT NULL DEFAULT 0, archive_ip_address VARCHAR(46) NOT NULL DEFAULT '', archive_content_date INT(10) NOT NULL DEFAULT 0, archive_content MEDIUMTEXT, archive_queued INT(1) NOT NULL DEFAULT 1, archive_topic_id INT(10) NOT NULL DEFAULT 0, archive_is_first INT(1) NOT NULL DEFAULT 0, archive_bwoptions INT(10) UNSIGNED NOT NULL DEFAULT 0, archive_attach_key CHAR(32) NOT NULL DEFAULT '', archive_html_mode INT(1) NOT NULL DEFAULT 0, archive_show_signature INT(1) NOT NULL DEFAULT 0, archive_show_emoticons INT(1) NOT NULL DEFAULT 0, archive_show_edited_by INT(1) NOT NULL DEFAULT 0, archive_edit_time INT(10) NOT NULL DEFAULT 0, archive_edit_name VARCHAR(255) NOT NULL DEFAULT '', archive_edit_reason VARCHAR(255) NOT NULL DEFAULT '', archive_added INT(10) NOT NULL DEFAULT 0, archive_restored INT(1) NOT NULL DEFAULT 0, PRIMARY KEY (archive_id), KEY archive_topic_id (archive_topic_id,archive_queued,archive_content_date), KEY archive_author_id (archive_author_id), KEY archive_restored (archive_restored), KEY archive_content_date (archive_content_date, archive_topic_id) ) ENGINE=MyISAM;
Table 'forums_archive_posts' already exists
Error:
ALTER TABLE forums_archive_posts ADD FULLTEXT KEY archive_content (archive_content);
Duplicate key name 'archive_content'
Error:
CREATE TABLE forums_recent_posts ( post_id INT(10) NOT NULL DEFAULT 0, post_topic_id INT(10) NOT NULL DEFAULT 0, post_forum_id INT(10) NOT NULL DEFAULT 0, post_author_id INT(10) NOT NULL DEFAULT 0, post_date INT(10) NOT NULL DEFAULT 0, PRIMARY KEY (post_id), KEY group_lookup (post_author_id, post_forum_id, post_date, post_id ) ) ENGINE=MyISAM;
Table 'forums_recent_posts' already exists
]
I clicked continue anyway.
2) Install a custom skin (I don't know if this step is necessary)
3) Run upgrader. On step 2 I get this
Quote
Error:
CREATE TABLE core_archive_log ( archlog_id INT(10) AUTO_INCREMENT NOT NULL, archlog_app VARCHAR(255) NOT NULL DEFAULT 0, archlog_date INT(10) NOT NULL DEFAULT 0, archlog_ids MEDIUMTEXT, archlog_count INT(10) NOT NULL DEFAULT 0, archlog_is_restore INT(1) NOT NULL DEFAULT 0, archlog_is_error INT(1) NOT NULL DEFAULT 0, archlog_msg TEXT, PRIMARY KEY (archlog_id) ) ENGINE=MyISAM;
Table 'core_archive_log' already exists
Error:
CREATE TABLE core_archive_restore ( restore_min_tid INT(10) NOT NULL DEFAULT 0, restore_max_tid INT(10) NOT NULL DEFAULT 0, restore_manual_tids MEDIUMTEXT ) ENGINE=MyISAM;
Table 'core_archive_restore' already exists
Error:
CREATE TABLE core_archive_rules ( archive_key CHAR(32) NOT NULL DEFAULT '', archive_app VARCHAR(32) NOT NULL DEFAULT 'core', archive_field VARCHAR(255) NOT NULL DEFAULT '', archive_value VARCHAR(255) NOT NULL DEFAULT '', archive_text TEXT NOT NULL, archive_unit VARCHAR(255) NOT NULL DEFAULT '', archive_skip INT(1) NOT NULL DEFAULT 0, PRIMARY KEY (archive_key) ) ENGINE=MyISAM;
Table 'core_archive_rules' already exists
Error:
CREATE TABLE forums_archive_posts ( archive_id INT(10) DEFAULT 0, archive_author_id INT(10) NOT NULL DEFAULT 0, archive_author_name VARCHAR(255) NOT NULL DEFAULT 0, archive_ip_address VARCHAR(46) NOT NULL DEFAULT '', archive_content_date INT(10) NOT NULL DEFAULT 0, archive_content MEDIUMTEXT, archive_queued INT(1) NOT NULL DEFAULT 1, archive_topic_id INT(10) NOT NULL DEFAULT 0, archive_is_first INT(1) NOT NULL DEFAULT 0, archive_bwoptions INT(10) UNSIGNED NOT NULL DEFAULT 0, archive_attach_key CHAR(32) NOT NULL DEFAULT '', archive_html_mode INT(1) NOT NULL DEFAULT 0, archive_show_signature INT(1) NOT NULL DEFAULT 0, archive_show_emoticons INT(1) NOT NULL DEFAULT 0, archive_show_edited_by INT(1) NOT NULL DEFAULT 0, archive_edit_time INT(10) NOT NULL DEFAULT 0, archive_edit_name VARCHAR(255) NOT NULL DEFAULT '', archive_edit_reason VARCHAR(255) NOT NULL DEFAULT '', archive_added INT(10) NOT NULL DEFAULT 0, archive_restored INT(1) NOT NULL DEFAULT 0, PRIMARY KEY (archive_id), KEY archive_topic_id (archive_topic_id,archive_queued,archive_content_date), KEY archive_author_id (archive_author_id), KEY archive_restored (archive_restored), KEY archive_content_date (archive_content_date, archive_topic_id) ) ENGINE=MyISAM;
Table 'forums_archive_posts' already exists
Error:
ALTER TABLE forums_archive_posts ADD FULLTEXT KEY archive_content (archive_content);
Duplicate key name 'archive_content'
Error:
CREATE TABLE forums_recent_posts ( post_id INT(10) NOT NULL DEFAULT 0, post_topic_id INT(10) NOT NULL DEFAULT 0, post_forum_id INT(10) NOT NULL DEFAULT 0, post_author_id INT(10) NOT NULL DEFAULT 0, post_date INT(10) NOT NULL DEFAULT 0, PRIMARY KEY (post_id), KEY group_lookup (post_author_id, post_forum_id, post_date, post_id ) ) ENGINE=MyISAM;
Table 'forums_recent_posts' already exists
I clicked continue anyway.
0 user(s) are reading this issue
0 members, 0 guests, 0 anonymous users












