News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

problem reinstalling SMF into a restored database

Started by tinatoth, January 28, 2008, 08:22:50 PM

Previous topic - Next topic

tinatoth

The other day, I tested the IPB 1.3 conversion to SMF on a copy of my forum's database. It worked.

So now, to get all the most recent posts into the official conversion, I had to restore the database, replace it with the most current one, and do the conversion again.

It should work, however, the SMF installer is giving me this error:

Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.

Technical information about the queries:
Line #21: MyISAM table 'smf_attachments' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #39: MyISAM table 'smf_ban_groups' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #62: MyISAM table 'smf_ban_items' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #74: MyISAM table 'smf_board_permissions' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #150: Duplicate entry '-1-0-poll_view' for key 1
Line #179: MyISAM table 'smf_boards' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #187: Duplicate entry '1' for key 1
Line #206: MyISAM table 'smf_calendar' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #218: MyISAM table 'smf_calendar_holidays' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #408: MyISAM table 'smf_categories' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #415: Duplicate entry '1' for key 1
Line #426: MyISAM table 'smf_collapsed_categories' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #442: MyISAM table 'smf_log_actions' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #458: MyISAM table 'smf_log_activity' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #472: MyISAM table 'smf_log_banned' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #483: MyISAM table 'smf_log_boards' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #501: MyISAM table 'smf_log_errors' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #511: MyISAM table 'smf_log_floodcontrol' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #524: MyISAM table 'smf_log_karma' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #535: MyISAM table 'smf_log_mark_read' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #547: MyISAM table 'smf_log_notify' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #562: MyISAM table 'smf_log_online' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #573: MyISAM table 'smf_log_polls' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #583: MyISAM table 'smf_log_search_messages' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #596: MyISAM table 'smf_log_search_results' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #607: MyISAM table 'smf_log_search_subjects' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #617: MyISAM table 'smf_log_search_topics' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #629: MyISAM table 'smf_log_topics' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #644: MyISAM table 'smf_membergroups' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #659: Duplicate entry '1' for key 1
Line #728: MyISAM table 'smf_members' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #742: MyISAM table 'smf_message_icons' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #793: MyISAM table 'smf_messages' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #801: Duplicate entry '1' for key 1
Line #812: MyISAM table 'smf_moderators' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #823: MyISAM table 'smf_package_servers' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #843: MyISAM table 'smf_permissions' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #889: Duplicate entry '-1-search_posts' for key 1
Line #907: MyISAM table 'smf_personal_messages' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #922: MyISAM table 'smf_pm_recipients' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #939: MyISAM table 'smf_polls' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #951: MyISAM table 'smf_poll_choices' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #961: MyISAM table 'smf_settings' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #1124: Duplicate entry 'smfVersion' for key 1
Line #1136: MyISAM table 'smf_sessions' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #1151: MyISAM table 'smf_smileys' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #1191: MyISAM table 'smf_themes' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #1230: Duplicate entry '1-0-name' for key 1
Line #1255: MyISAM table 'smf_topics' is in use (most likely by a MERGE table). Try FLUSH TABLES.
Line #1263: Duplicate entry '1' for key 1



I've checked the database in phpmyadmin and all smf_ tables are gone, the database only contains the invisionboard tables. Could the old smf ones be somewhere in some cache? Is that what "flush tables" means?

How do I fix this?

---

edit

nevermind, my host sorted it out for me. :)

Advertisement: