SMF Support > vBulletin

vb3.5 to SMF 2.0 Conversion error

(1/3) > >>

James B:
Hi

I get this when converting the database

The admin and members converted nicely then it stops:
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)

Not sure how to overcome or bypass this error.

Please help.

TE:
in vbulletin35_to_smf.sql find:


--- Code: (find) ------* {$to_prefix}topics
--- End code ---
add after


--- Code: (add after) ------{
$row['id_member_updated'] = (int) $row['id_member_updated'];
---}

--- End code ---

then rerun the converter..

James B:
Thank you!

That has gotten me past quite a bit and I really cant thank you enough. However now I get this:

Converting...
Converting personal messages (step 1)...
Successful.
Converting personal messages (step 2)...Error in convert script - line 221!
Error in convert script - line 224!
Successful.
Converting topic notifications... Unsuccessful!
This query:
SELECT
pm.pmid AS id_pm, pm.touserid AS id_member, pm.readtime != 0 AS is_read,
'-1' AS labels
FROM `vb_fourm`.ec_pm AS pm
TRUNCATE `smf_forum`.smf_log_notify;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUNCATE `smf_forum`.smf_log_notify' at line 5

TE:
uhh, that's a typo in vbulletin35_to_smf.sql ..

find:

--- Code: ---SELECT
pm.pmid AS id_pm, pm.touserid AS id_member, pm.readtime != 0 AS is_read,
'-1' AS labels
FROM {$from_prefix}pm AS pm
--- End code ---

replace with:


--- Code: (fixed version) ---SELECT
pm.pmid AS id_pm, pm.touserid AS id_member, pm.readtime != 0 AS is_read,
'-1' AS labels
FROM {$from_prefix}pm AS pm;
--- End code ---

(the semicolon  at the end is missing,  that's the "bug")

James B:
I just don't have enough thank you's for you. I'am however running into another:

Converting personal messages (step 1)... Unsuccessful!
This query:
SELECT
pm.pmid AS id_pm, pmt.fromuserid AS id_member_from, pmt.dateline AS msgtime,
SUBSTRING(pmt.fromusername, 1, 255) AS from_name,
SUBSTRING(pmt.title, 1, 255) AS subject,
SUBSTRING(REPLACE(pmt.message, '<br>', '<br />'), 1, 65534) AS body
FROM `vb_fourm`.ec_pm AS pm
LIMIT 0, 500;
Caused the error:
Unknown column 'pmt.fromuserid' in 'field list'

 ???

Navigation

[0] Message Index

[#] Next page