Topic: vBulletin 3.6 to SMF 2.0 RC2 ERROR

[Norv]

Please try the attached file, instead.

[ACAMS]

I think I got closer, but the list is long this time.

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

[Norv]

Oops, might be my fault, that. Please, use this file, instead.

[ACAMS]

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)

[Norv]

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,


[ACAMS]

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

[Norv]

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)

[ACAMS]

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.

[Norv]

Cheers, good to hear you have it sorted out!