SMF Support > vBulletin

Vbulletin 4 conversion mysql timeouts

(1/1)

magicbus:
I have been attempting to import my vbulletin 4 forum to sm, and run into numerous timeouts. With members I press try again (many times) and it eventually gets through it, but on topics it fails and no matter how many times I press try again it gets no further

the error is

Converting topics...
Unsuccessful!
This query:

    SELECT
    t.threadid AS id_topic, t.forumid AS id_board, t.sticky AS is_sticky,
    t.pollid AS id_poll, t.views AS num_views, t.postuserid AS id_member_started,
    CASE WHEN (ISNULL(ul.userid) OR TRIM(ul.userid) = '') THEN 0 ELSE ul.userid END AS id_member_updated,
    t.replycount AS num_replies,
    IF(t.open, 0, 1) AS locked, MIN(p.postid) AS id_first_msg,
    MAX(p.postid) AS id_last_msg
    FROM `magicbus_vb`.thread AS t
    INNER JOIN `magicbus_vb`.post AS p ON (p.threadid = t.threadid)
    LEFT JOIN `magicbus_vb`.user AS ul ON (ul.username = t.lastposter)
    GROUP BY t.threadid
    HAVING id_first_msg != 0
    AND id_last_msg != 0
    LIMIT 0, 500;

Caused the error:

    Lost connection to MySQL server during query




I have contacted my host (shared server) and they won't let me increase wait_timeout and connect_timeout settings.

So is there anything I can do? Maybe change the limit to a smaller number for each query? how would I do this? any ideas

thanks

magicbus:
I ran the query on phpMyAdmin and there was the same error. I reinstalled the VB database and now all is well.

Might be worth checking if you have the same issue

vbgamer45:
It might be too much data. The packet size variable in mysql

Navigation

[0] Message Index

Go to full version