SMF Support > vBulletin

Converting poll options

(1/3) > >>

cdesseno:
I am having some troubles converting vBulletin 3.8 to SMF 2.0 with 3.7 converter. All is working fine except* from this:

--- Quote ---Converting poll options...Wrong value type sent to the database. Integer expected. (votes).
--- End quote ---

* Changing

--- Code: ---SELECT pollid AS id_poll, options, votes
FROM {$from_prefix}poll;
--- End code ---
to

--- Code: ---SELECT pollid AS id_poll, options, IFNULL(votes, 0)
FROM {$from_prefix}poll;
--- End code ---
I managed to skip that bug, but obviously poll are not being imported ok.

Oldiesmann:
What happens to the poll options after you make that change? Are they just not being imported at all?

cdesseno:
As you can see in the image, votes are always zero. Also, another strange thing is that the first letter of label was removed in each row.

hxxp:imageshack.us/photo/my-images/3/screenshotat20120120180.png [nonactive]

Oldiesmann:
How does vB store vote info for poll options?

We can figure out the issue with the first letter getting cut off later...

cdesseno:
Options are stored all in the same field with this format:
Yes|||No|||May be

hxxp:imageshack.us/photo/my-images/850/screenshotat20120121160.png/ [nonactive]

Navigation

[0] Message Index

[#] Next page