Vbulletin 4.2.5 to phpBB poll error.

[R4NGER]

Hi,
Trying to convert Vbulletin 4.2.5 to the latest phpBB. (450K+ Posts, 30K+ Members)
Starting with the instructions from this post viewtopic.php?t=2646517 Starting at version 3.0.11

I Am Getting the bellow error. I've Tried searching for a fix, and all I could find was the same error with VB 3.X and the fix suggested there isn't relevant?

Cheers.

Code: Select all

General Error
SQL ERROR [ mysqli ]
Out of range value for column 'poll_option_total' at row 3 [1264]
SQL
INSERT INTO phpbb_poll_options (poll_option_id, topic_id, poll_option_text, poll_option_total) VALUES (1, 19356, 'Yes', 0), (2, 19356, 'Yes', 0), (3, 19356, 'Hell No', 2147483647)
BACKTRACE

[thecoalman]

You have 0 votes for the first two options both labeled "Yes" and 2.1 billion votes for "Hell no". Unless you have somehow managed to get 1/4 of the worlds population to all agree on the same thing it would appear there is something wrong with your results.

First check what is actually displaying on VB to make sure the conversion isn't screwing something up, the topic ID is 19356.

phpBB only allows for 8 digits or 99,999,999 votes for that column. Just delete the poll if it's corrupt.

[R4NGER]

I have looked at the polls in vbulletin and all have realistic voting numbers.

Could it be because my database was created in the vbulletin 2.x days and is latin1_swedish_ci instead of utf8mb3 ?

Thanks!

[thecoalman]

There error would indicate the poll is attached to topic with ID of 19356, did you check that one?

[R4NGER]

Hi yes, I stripped that poll from the thread, it now errors on the next poll.