Hello Norv and thank you for your answer,
Actually I am on SMF 1.1.11, and I have XOOPS 2 as well, converting members ends with no errors, but everything after that ( I tried by modifiying the step variable) fails for "Unknown field"
Converting members... Successful
Converting topics... Unsuccessful!
t.topic_id AS ID_TOPIC, t.topic_sticky AS isSticky, t.forum_id AS ID_BOARD,
t.topic_last_post_id AS ID_LAST_MSG, t.topic_poster AS ID_MEMBER_STARTED,
t.topic_replies AS numReplies, t.topic_views AS numViews,
t.poll_id AS ID_POLL,
t.topic_status AS locked, MIN(p.post_id) AS ID_FIRST_MSG
FROM `shipspotting`.xoops_bb_topics AS t
INNER JOIN `shipspotting`.xoops_bb_posts AS p ON (p.topic_id = t.topic_id)
GROUP BY t.topic_id
HAVING ID_FIRST_MSG != 0
AND ID_LAST_MSG != 0
LIMIT 0, 500;
Caused the error:
Unknown column 't.poll_id' in 'field list'
Any idea ? Thanks in advance