Converter from Phorum to SMF

Started by nzipfel, December 24, 2021, 09:23:19 PM

Previous topic - Next topic

nzipfel

I am attempting to convert from Phorum to SMF and I get the following error.  Any ideas?

Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
SELECT
m.thread AS id_topic, hxxp:m.forum [nonactive]_id AS id_board, m.message_id AS id_first_msg,
m.user_id AS id_member_started, (m.thread_count - 1) AS num_replies,
m.viewcount AS num_views, IF(m.sort = 1, 1, 0) AS is_sticky,
MAX(m2.message_id) AS id_last_msg, m.closed AS locked
FROM `orgadmin_phorum`.phorum_messages AS m
INNER JOIN `orgadmin_phorum`.phorum_messages AS m2 ON (m2.thread = m.thread)
WHERE m.message_id = m.thread
AND m.parent_id = 0
GROUP BY m.thread
HAVING id_first_msg != 0
AND id_last_msg != 0
LIMIT 0, 500;

Caused the error:
1690

nzipfel

I optimized my Phorum database and got past that error.  Now I am encountering this

Converting...
Converting topics...
Duplicate entry '1391' for key 'smfs4_topics.PRIMARY'

It imported 3,000 topics out of out of 6,846. I've tried reloading the page multiple times and it does not move on past 3,000.  I looked in the phorum database and do not see a duplicate at that point.

Oldiesmann

Quote from: nzipfel on December 24, 2021, 09:23:19 PMCaused the error:
1690

Error 1690 means "value out of range" - somewhere a number is being calculated/pulled that is either too small (ie less than 1) or too big for the field the query is trying to insert it into.

I'm not familiar with the converters unfortunately so I can't be much help beyond that. Maybe @vbgamer45 can be of more assistance here.

Advertisement: