Never mind. This is a user lack-of-knowledge error... I was trying to run each command line separately without removing
UNION
before its execution.The executed result is below.
Code: Select all
ALTER TABLE phpbb_acl_options MODIFY auth_option_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 119;
ALTER TABLE phpbb_acl_roles MODIFY role_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 25;
ALTER TABLE phpbb_attachments MODIFY attach_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 7683;
ALTER TABLE phpbb_banlist MODIFY ban_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 21;
ALTER TABLE phpbb_bots MODIFY bot_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 51;
ALTER TABLE phpbb_disallow MODIFY disallow_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 5;
ALTER TABLE phpbb_drafts MODIFY draft_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 224;
ALTER TABLE phpbb_extensions MODIFY extension_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 29;
ALTER TABLE phpbb_extension_groups MODIFY group_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 8;
ALTER TABLE phpbb_forums MODIFY forum_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 38;
ALTER TABLE phpbb_groups MODIFY group_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 1458;
ALTER TABLE phpbb_icons MODIFY icons_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 11;
ALTER TABLE phpbb_lang MODIFY lang_id tinyint(4) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 3;
ALTER TABLE phpbb_log MODIFY log_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 12697;
ALTER TABLE phpbb_modules MODIFY module_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 200;
ALTER TABLE phpbb_posts MODIFY post_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 164852;
ALTER TABLE phpbb_privmsgs MODIFY msg_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 139294;
ALTER TABLE phpbb_privmsgs_folder MODIFY folder_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 981;
ALTER TABLE phpbb_privmsgs_rules MODIFY rule_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 1;
ALTER TABLE phpbb_profile_fields MODIFY field_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 4;
ALTER TABLE phpbb_ranks MODIFY rank_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 20;
ALTER TABLE phpbb_reports MODIFY report_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 5;
ALTER TABLE phpbb_reports_reasons MODIFY reason_id smallint(4) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 5;
ALTER TABLE phpbb_search_wordlist MODIFY word_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 107125;
ALTER TABLE phpbb_sitelist MODIFY site_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 1;
ALTER TABLE phpbb_smilies MODIFY smiley_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 46;
ALTER TABLE phpbb_styles MODIFY style_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 8;
ALTER TABLE phpbb_topics MODIFY topic_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 16830;
ALTER TABLE phpbb_users MODIFY user_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 3048;
ALTER TABLE phpbb_warnings MODIFY warning_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 1;
ALTER TABLE phpbb_words MODIFY word_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT= 20;
SHOW CREATE TABLE
command again and it doesn't look like the AUTO_INCREMENT
was added to any of the tables.There was an alert that I noticed in the middle of the page, too: "This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available." I'm not clear which table it refers to as it's not explicitly stated. Screenshot attached.