When Trying to convert from Mybb I get this error:
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
SELECT
t.tid AS ID_TOPIC, t.fid AS ID_BOARD, t.sticky AS isSticky,
t.poll AS ID_POLL, t.views AS numViews, t.uid AS ID_MEMBER_STARTED,
ul.uid AS ID_MEMBER_UPDATED, t.replies AS numReplies, t.closed AS locked,
MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG
FROM (`d60596613`.mybb_threads AS t, `d60596613`.mybb_posts AS p)
LEFT JOIN `d60596613`.mybb_users AS ul ON (BINARY ul.username = t.lastposter)
WHERE p.tid = t.tid
GROUP BY t.tid
HAVING ID_FIRST_MSG != 0
AND ID_LAST_MSG != 0
LIMIT 0, 500;
Caused the error:
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Give this convert.php a try. It attempts to bypass those settings and make those queries possible.