Simple Machines Community Forum

SMF Support => Converting to SMF => vBulletin => Topic started by: James B on September 06, 2012, 05:39:06 PM

Title: vb3.5 to SMF 2.0 Conversion error
Post by: James B on September 06, 2012, 05:39:06 PM
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.
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: ThorstenE on September 07, 2012, 01:02:43 PM
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..
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: James B on September 07, 2012, 10:01:49 PM
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
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: ThorstenE on September 08, 2012, 02:20:54 AM
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")
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: James B on September 08, 2012, 09:51:35 AM
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'

???
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: ThorstenE on September 08, 2012, 11:38:36 AM
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 ..
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: James B on September 08, 2012, 12:26:14 PM
I've attached the SQL Result.pdf.  Sorry it wouldn't paste nicely
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: ThorstenE on September 08, 2012, 02:25:29 PM
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.
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: James B on September 08, 2012, 02:33:04 PM
No need for sorry's, you're helping me and I appreciate it.

Here are the results
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: ThorstenE on September 08, 2012, 02:59:33 PM
fixed various things, please try the attached version..
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: James B on September 08, 2012, 06:03:52 PM
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

Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: ThorstenE on September 09, 2012, 01:48:46 AM
ok, try it with this version please..
Maybe we should simply remove the smileys conversion code, it's easy to add custom smileys later.
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: James B on September 10, 2012, 10:12:19 AM
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
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: ThorstenE on September 10, 2012, 10:37:59 AM
The converter doesn't care about post/messages dates, I'm almost sure your backup is outdated...
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: southsideguy on October 27, 2013, 05:07:42 PM
Hi. I'm getting this error. Any idea?

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

Thanks.
Title: Re: vb3.5 to SMF 2.0 Conversion error
Post by: Oldiesmann on October 30, 2013, 11:35:04 AM
Not sure why that's happening. That means SMF is trying to insert multiple topics with an ID of 616, which should never happen.