Author Topic: Vbulletin 4 conversion mysql timeouts  (Read 145 times)

Offline magicbus

  • Newbie
  • *
  • Posts: 5
Vbulletin 4 conversion mysql timeouts
« on: February 18, 2020, 05:32:44 PM »
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...
This query:

    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(, 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


Offline magicbus

  • Newbie
  • *
  • Posts: 5
Re: Vbulletin 4 conversion mysql timeouts
« Reply #1 on: February 18, 2020, 07:09:19 PM »
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

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 22,104
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Vbulletin 4 conversion mysql timeouts
« Reply #2 on: February 18, 2020, 08:10:40 PM »
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! -  Paid Modifications for SMF

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