error when Trying to convert from Mybb

[gatorbowls]

When Trying to convert from Mybb I get this error:

Code Select Expand


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

[SleePy]

Give this convert.php a try. It attempts to bypass those settings and make those queries possible.