Advertisement:
NameCheap

Author Topic: vb3.5 to SMF 2.0 Conversion error  (Read 9656 times)

Offline James B

  • Newbie
  • *
  • Posts: 7
vb3.5 to SMF 2.0 Conversion error
« 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.

ThorstenE

  • Guest
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #1 on: September 07, 2012, 01:02:43 PM »
in vbulletin35_to_smf.sql find:

Code: (find) [Select]
---* {$to_prefix}topicsadd after

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

then rerun the converter..

Offline James B

  • Newbie
  • *
  • Posts: 7
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #2 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

ThorstenE

  • Guest
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #3 on: September 08, 2012, 02:20:54 AM »
uhh, that's a typo in vbulletin35_to_smf.sql ..

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

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")

Offline James B

  • Newbie
  • *
  • Posts: 7
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #4 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'

 ???

ThorstenE

  • Guest
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #5 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?

Code: [Select]
SHOW COLUMNS from `vb_fourm`.ec_pm;
I need to know the table structure in order to help ..

Offline James B

  • Newbie
  • *
  • Posts: 7
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #6 on: September 08, 2012, 12:26:14 PM »
I've attached the SQL Result.pdf.  Sorry it wouldn't paste nicely

ThorstenE

  • Guest
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #7 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.

Code: [Select]
SHOW COLUMNS from `vb_fourm`.ec_pmtext;Thanks.

Offline James B

  • Newbie
  • *
  • Posts: 7
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #8 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

ThorstenE

  • Guest
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #9 on: September 08, 2012, 02:59:33 PM »
fixed various things, please try the attached version..

Offline James B

  • Newbie
  • *
  • Posts: 7
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #10 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


ThorstenE

  • Guest
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #11 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.

Offline James B

  • Newbie
  • *
  • Posts: 7
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #12 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

ThorstenE

  • Guest
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #13 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...

Offline southsideguy

  • Newbie
  • *
  • Posts: 3
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #14 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.

Offline Oldiesmann

  • Lead Developer
  • SMF Super Hero
  • *
  • Posts: 24,205
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: vb3.5 to SMF 2.0 Conversion error
« Reply #15 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.