Vbulletin 4 conversion mysql timeouts

Started by magicbus, February 18, 2020, 05:32:44 PM

Previous topic - Next topic

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
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: