Naprawa "Auto Increment" po migracji z MySQL wyższej wersji do niższej

[DawPi]

Po migracji z wersji MySQL wyższej do niższej ( no. z 4.1 do 4.0, lub 4.1 do 3.23 ) występuje problem z wartością "Auto Increment" w bazie danych, pojawiają się błędy "Duplicate key 0", wszystko się rozsypuje jednym słowem. By to naprawić w prosty sposób musisz wykonać następujące zapytanie np. w PhpMyAdminie:

ALTER TABLE `ibf_admin_logs` CHANGE `id` `id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_admin_login_logs` CHANGE `admin_id` `admin_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_announcements` CHANGE `announce_id` `announce_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_attachments` CHANGE `attach_id` `attach_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_attachments_type` CHANGE `atype_id` `atype_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_badwords` CHANGE `wid` `wid` INT( 3 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_banfilters` CHANGE `ban_id` `ban_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_bulk_mail` CHANGE `mail_id` `mail_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_cal_calendars` CHANGE `cal_id` `cal_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_cal_events` CHANGE `event_id` `event_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_components` CHANGE `com_id` `com_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_conf_settings` CHANGE `conf_id` `conf_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_conf_settings_titles` CHANGE `conf_title_id` `conf_title_id` SMALLINT( 3 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_contacts` CHANGE `id` `id` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_custom_bbcode` CHANGE `bbcode_id` `bbcode_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_dnames_change` CHANGE `dname_id` `dname_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_email_logs` CHANGE `email_id` `email_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_emoticons` CHANGE `id` `id` SMALLINT( 3 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_faq` CHANGE `id` `id` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_forum_perms` CHANGE `perm_id` `perm_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_forum_tracker` CHANGE `frid` `frid` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_groups` CHANGE `g_id` `g_id` INT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_languages` CHANGE `lid` `lid` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_login_methods` CHANGE `login_id` `login_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_mail_error_logs` CHANGE `mlog_id` `mlog_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_mail_queue` CHANGE `mail_id` `mail_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_members_converge` CHANGE `converge_id` `converge_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_members_partial` CHANGE `partial_id` `partial_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_message_text` CHANGE `msg_id` `msg_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_message_topics` CHANGE `mt_id` `mt_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_moderators` CHANGE `mid` `mid` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_moderator_logs` CHANGE `id` `id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_profile_ratings` CHANGE `rating_id` `rating_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_profile_friends` CHANGE `friends_id` `friends_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_profile_comments` CHANGE `comment_id` `comment_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_pfields_data` CHANGE `pf_id` `pf_id` SMALLINT( 5 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_polls` CHANGE `pid` `pid` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_posts` CHANGE `pid` `pid` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_rss_export` CHANGE `rss_export_id` `rss_export_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_rss_import` CHANGE `rss_import_id` `rss_import_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_skin_macro` CHANGE `macro_id` `macro_id` SMALLINT( 3 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_skin_sets` CHANGE `set_skin_set_id` `set_skin_set_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_skin_templates` CHANGE `suid` `suid` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_spider_logs` CHANGE `sid` `sid` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_subscription_extra` CHANGE `subextra_id` `subextra_id` SMALLINT( 5 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_subscription_logs` CHANGE `sublog_id` `sublog_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_subscription_methods` CHANGE `submethod_id` `submethod_id` SMALLINT( 5 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_subscription_trans` CHANGE `subtrans_id` `subtrans_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_subscriptions` CHANGE `sub_id` `sub_id` SMALLINT( 5 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_task_logs` CHANGE `log_id` `log_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_task_manager` CHANGE `task_id` `task_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_template_diff_session` CHANGE `diff_session_id` `diff_session_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_titles` CHANGE `id` `id` SMALLINT( 5 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_topic_mmod` CHANGE `mm_id` `mm_id` SMALLINT( 5 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_topic_ratings` CHANGE `rating_id` `rating_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_topics` CHANGE `tid` `tid` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_tracker` CHANGE `trid` `trid` MEDIUMINT( 8 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_upgrade_history` CHANGE `upgrade_id` `upgrade_id` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_voters` CHANGE `vid` `vid` INT( 10 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `ibf_warn_logs` CHANGE `wlog_id` `wlog_id` INT( 10 ) NOT NULL AUTO_INCREMENT;

Testowane na wersji 2.2.2

Enjoy!