Mybb 1.6 COnvert Problem

[Klevron]

Converting topics...
Duplicate entry '590' for key 'PRIMARY'

when im converting all things converting but not topics any one help me?

[kat]

In the file mybb_to_smf.sql change:

Code Select Expand

TRUNCATE {$to_prefix}topics;
TRUNCATE {$to_prefix}log_topics;
TRUNCATE {$to_prefix}log_boards;
TRUNCATE {$to_prefix}log_mark_read;

---* {$to_prefix}topics

to:

Code Select Expand

TRUNCATE {$to_prefix}topics;
TRUNCATE {$to_prefix}log_topics;
TRUNCATE {$to_prefix}log_boards;
TRUNCATE {$to_prefix}log_mark_read;

---* {$to_prefix}topics
---{
$ignore = true;
---}


and it should ignore those duplicates, I believe.

[Klevron]

Converting polls...
Unsuccessful!
This query:
NEW ERROR i dont want to move polls what i have to do i only want topics boards and members

Code Select Expand

SELECT
p.pid AS id_poll, SUBSTRING(p.question, 1, 255) AS question, p.closed AS voting_locked,
t.uid AS id_member,
IF(p.timeout = 0, 0, p.dateline + p.timeout * 86400) AS expire_time,
SUBSTRING(t.username, 1, 255) AS poster_name
FROM `**************`.mybb_polls AS p
LEFT JOIN `************`.mybb_threads AS t ON (t.tid = p.tid)
LIMIT 0, 500;
Caused the error:
BIGINT value is out of range in '(`********3`.`p`.`timeout` * 86400)'

[margarett]

That's more tricky... I'll check it when I get to the computer