SMF Support > MyBB

[SMF Converter] MyBB 1.6

<< < (24/27) > >>

ThomasJ:
I ran into the same BDay issue. Format was 1-1-1970 for all users with no bday explicitly set. Nulled out all bdays to get past that step. However that lead me directly into the next issue:


--- Code: ---Converting polls...Wrong value type sent to the database. Integer expected. (expire_time)

--- End code ---

Yoshi:
Can you give me an example of a poll's expire_time value?
Probably it's not an UNIX timestamp which is all integer.

If it's something like "1-1-1970" I can do something about it.

ThomasJ:
From the sql

--- Code: ---TRUNCATE {$to_prefix}polls;
TRUNCATE {$to_prefix}poll_choices;
TRUNCATE {$to_prefix}log_polls;

---* {$to_prefix}polls
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 {$from_prefix}polls AS p
        LEFT JOIN {$from_prefix}threads AS t ON (t.tid = p.tid);
---*

--- End code ---

So it's taking timeout and datline coloumns, which are bigint(30) and appear to be unix timestamps. I have no idea why it is failing as the entry's clearly are int's

example dateline

--- Code: ---1094083328

--- End code ---

example timeout

--- Code: ---1094083328

--- End code ---

eleweb:
HI, I'm use the suggerst of page 3 but I continue to have tis error


--- Code: ---Converting posts (this may take some time)...The database value you're trying to insert does not exist: modified_name
--- End code ---

how to fix it?

serulin:
Awesome thread guys, thanks for all the help! Had to go through and find each fix from people and add it to the sql, but in the end it worked! Just successfully converted mybb 1.6.7 to smf 2.0.2!!!

Navigation

[0] Message Index

[#] Next page

[*] Previous page