vb3.5 to SMF 2.0 Conversion error

Started by James B, September 06, 2012, 05:39:06 PM

Previous topic - Next topic

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.

ThorstenE

in vbulletin35_to_smf.sql find:

Code (find) Select
---* {$to_prefix}topics
add after

Code (add after) Select

---{
$row['id_member_updated'] = (int) $row['id_member_updated'];
---}


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

ThorstenE

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

find:
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


replace with:

Code (fixed version) Select
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;


(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'

???

ThorstenE

the structure from the table ec_pm seems to be different..  Can you please execute this via phpMyAdmin and then post the result?

SHOW COLUMNS from `vb_fourm`.ec_pm;

I need to know the table structure in order to help ..

James B

I've attached the SQL Result.pdf.  Sorry it wouldn't paste nicely

ThorstenE

the pdf is absolutely fine :) Sorry, but I need to know the columns from the pmtext table, too.

SHOW COLUMNS from `vb_fourm`.ec_pmtext;
Thanks.

James B

No need for sorry's, you're helping me and I appreciate it.

Here are the results

ThorstenE

fixed various things, please try the attached version..

James B

So close! Oh so close!

Converting topic notifications...
Successful.
Converting board notifications... Successful.
Converting smileys...
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /hermes/bosweb/web074/b740/ipg.bythebyteca/ByTheByte/SMF/Sources/Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: variable


ThorstenE

ok, try it with this version please..
Maybe we should simply remove the smileys conversion code, it's easy to add custom smileys later.

James B

Thank you Thank you

The forum converted with a couple of hiccups but nevertheless its up! I can't thank you enough. Although there is one thing and I don't think it has anything to do with the converter but I only have messages/posts up to December 2010. I have them all from 2005 but stops there.  I'm not sure if that was a converter issue or just the inability of my host not being able to process all the information of the import back into the new database. (although I tried it a few times). I will look at the database firstly to see if its even there but wanted to thank you again for all your help!

James

ThorstenE

The converter doesn't care about post/messages dates, I'm almost sure your backup is outdated...

southsideguy

Hi. I'm getting this error. Any idea?

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

Thanks.

Oldiesmann

Not sure why that's happening. That means SMF is trying to insert multiple topics with an ID of 616, which should never happen.
Michael Eshom
Christian Metal Fans

Advertisement: