Advertisement:

Author Topic: vBulletin 3.6 to SMF 2.0 RC2 ERROR  (Read 10728 times)

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
vBulletin 3.6 to SMF 2.0 RC2 ERROR
« on: November 29, 2009, 02:34:51 AM »
I saw a topic about this in vBulletin 3.8.4 to SMF 2.0 RC2, but the fix did not work for 3.6

I am converting and got this..

Converting members... Successful.
Converting administrators... Successful.
Converting categories...Wrong value type sent to the database. Integer expected. (can_collapse)

What do I need to do, as there is nothing about it in the online manual

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #1 on: November 29, 2009, 03:01:32 AM »
OK, I got this far now.....any clues what I need to do next?

Converting...
Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #2 on: November 29, 2009, 04:29:53 AM »
Please, try using the converter from vbulletin 3.7, it was tested actually with 3.6 dataases as well. You can find it in this site's Downloads > Converters > vBulletin page.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #3 on: November 29, 2009, 04:34:31 AM »
It stopped on the same error

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #4 on: November 29, 2009, 04:38:13 AM »
Can you please tell, have you restarted fully the conversion? If you type your_address/convert.php with no other parameter, it should ask for the data file to use, in case you have two. Was this the case?
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #5 on: November 29, 2009, 04:43:40 AM »
Yes, I just typed my_address/convert.php with no other parameter

and filled in the boxes correctly....then it goes to here....

Converting...
Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)


It says

Set SMF's default character set to: ISO-8859-1

I also tried  UTF-8
« Last Edit: November 29, 2009, 04:47:24 AM by ACAMS »

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #6 on: November 29, 2009, 05:07:20 AM »
Can you please post the sql file you're using, here?
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #7 on: November 29, 2009, 05:19:34 AM »
I am using the Vbulletin 3.6 to SMF 2-0-rc2 converter (because there is no Vbulletin 3.t to SMF 2-0-rc2 converter)

With this http://gametechmods.com/forums-old-smf/vbulletin37_to_smf.sql

It says old smf because I just made a new database and new install I am gonna try

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #8 on: November 29, 2009, 05:26:30 AM »
Please use vBulletin3.7 to SMF 2.0 RC2 converter, that is, the convert.php file with the vbulletin37_to_smf.sql file.
There should be no need to reinstall SMF (as you wish, though), just make sure you use the 3.7 file, when convert.php is asking what data file it should use.
That is, the attached file: vbulletin37_to_smf.sql
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #9 on: November 29, 2009, 05:32:09 AM »
I only see a Vbulletin 3.7 to SMF 1-1-10 converter in downloads section.....is there one for 2.0 somewhere else?

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #10 on: November 29, 2009, 05:35:53 AM »
Please use also this convert.php file, with the .sql attached above, and I will take a look to see why it might be missing. Thank you for letting us know.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #11 on: November 29, 2009, 05:42:53 AM »
Please use also this convert.php file

Which convert.php?

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #12 on: November 29, 2009, 05:47:17 AM »
Please find it attached to my previous post.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #13 on: November 29, 2009, 05:54:29 AM »
EDIT: it seems to be working now.......just taking a long time to do the posts.
« Last Edit: November 29, 2009, 06:02:49 AM by ACAMS »

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #14 on: November 29, 2009, 06:06:29 AM »
Quote
Unknown column 'memberName' in 'field list'
Can you please check out the files you're using? It looks like using a file for 1.1.10, still, and I double check these attached here, they seem to be the right files, for 2.0. Perhaps cleaning up your SMF folder from converter files and re-uploading only the above convert.php file, and the above .sql file, and using them, would be worth doing.


ETA: ah you edited your post, great! It's normal to take a while, depending on the size of the database.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #15 on: November 29, 2009, 06:09:09 AM »
My internet is super slow, and I got in a hurry and did the wrong vbulletin37_to_smf.sql

I have the right convert.php and the right vbulletin37_to_smf.sql now and here is where it stopped this time.

Converting posts (this may take some time)...
Successful.
Converting polls...Wrong value type sent to the database. Integer expected. (id_member)

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #16 on: November 29, 2009, 06:31:49 AM »
What if I went on the VB forums and deleted all polls.
think that would work?


Offline BrianVB

  • Semi-Newbie
  • *
  • Posts: 86
  • Gender: Male
    • SavvyRPG
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #17 on: November 29, 2009, 12:00:57 PM »
with vBulletin 3.8 to 2.0 it is really easy and  (not very)fast.

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #18 on: November 29, 2009, 12:35:22 PM »
ACAMS: please try using the attached file instead, where I made a correction that should allow it to work even when at polls, by the looks of it, something unexpected may happen. (presumably there's no postuserid for one of your polls)

BrianVB: good to hear!
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #19 on: November 29, 2009, 01:30:00 PM »
I got 1 step closer.

Converting...
Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options...Wrong value type sent to the database. Integer expected. (votes)

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #20 on: November 29, 2009, 01:55:34 PM »
Please try the attached file, instead.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #21 on: November 29, 2009, 02:24:04 PM »
I think I got closer, but the list is long this time.

http://gametechmods.com/forums-old-smf/poll_votes.txt

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #22 on: November 29, 2009, 02:40:34 PM »
Oops, might be my fault, that. Please, use this file, instead.
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #23 on: November 29, 2009, 03:00:33 PM »
Looks like you are busy helping lots of people.

I tried the last one, but still stuck here

Converting...
Converting posts (this may take some time)...
Successful.
Converting polls... Successful.
Converting poll options...Wrong value type sent to the database. Integer expected. (votes)

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #24 on: November 29, 2009, 03:33:08 PM »
Option 1: Please, use this attached file.

Option 2: If it still doesn't work, then if you can take the time, please do the following: run in phpmyadmin, selecting the vbulletin database, the query:
Code: [Select]
SELECT votes FROM vb_poll;
and "export" the result into a file, as phpmyadmin allows to, or copy paste them here (if not too many, at least).

Option 3: Or, you could perhaps do this: if you agree to losing the number of votes for the time being, then in the (last) file vbulletin37_to_smf.sql, the file attached to this message, you could:
Code: (find) [Select]
'votes' => (is_numeric($votes[$i]) ? $votes[$i] : 0),

Code: (replace) [Select]
'votes' => 0,
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #25 on: November 29, 2009, 05:09:06 PM »
Stopped in the same place again.

here is the dump file

http://gametechmods.com/forums/phpMyAdmin_SQL_Dump.txt

I went ahead with #2 and now I wonder if there is a way to either mass delete all polls, or fix them?

http://gametechmods.com/forums/poll_gone.png
« Last Edit: November 29, 2009, 06:49:03 PM by ACAMS »

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #26 on: November 29, 2009, 06:50:21 PM »
Everything seems as expected in the table you attached, there is obviously is a bug in the code I didn't see at first sight. I'll come back tomorrow on the polls options problem, surely they can be imported correctly instead of that. (it's getting very late here)
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github

Offline ACAMS

  • Full Member
  • ***
  • Posts: 607
  • HEY, watch this....here, hold my beer
    • gametechmods.com
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #27 on: November 30, 2009, 02:17:59 AM »
No, don't worry about it for me, you have really helped me through this and it is VERY easy to delete polls with SMF. In vbulletin I had to go into the control panel and put in the number of the post I wanted to strip....then go back to the forum and get another number, and so on

THANKS for your help, I really appreciate you taking time to help me.

You guy's will have a new charter member as soon as I get home from work (which should be this week)

THANKS again for the help, and I will mark this solved.

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: vBulletin 3.6 to SMF 2.0 RC2 ERROR
« Reply #28 on: November 30, 2009, 03:53:45 AM »
Cheers, good to hear you have it sorted out!
To-do lists are for deferral. The more things you write down the later they're done… until you have 100s of lists of things you don't do.
File a security report | Developers' Blog | Bug Tracker

Also known as Norv on D* | Norv N. on G+ | Norv on Github