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
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
It might be too much data. The packet size variable in mysql