2018-12-31, 01:10 AM
Been working on moving over a rather large forum from phpBB3 to myBB. Things are going pretty good, but I got a problem at the Poll Votes merging. I keep getting this error message and I can't find out what to do.
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1366 - Incorrect integer value: '' for column 'pid' at row 1
Query:
INSERT INTO mybb_pollvotes (
I've been trying to look for the incorrect value " in both phpBB_poll_votes and myBB_pollvotesĀ but can't find it so far... Could it come from the merger tool perhaps?
Any help on how I can proceed with the merge is greatly appreciated.
Thanks!
Andy
I think I temporarily fixed this by changing from int to varchar, imported and then found the error, corrected it and then change the table to int again.
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1366 - Incorrect integer value: '' for column 'pid' at row 1
Query:
INSERT INTO mybb_pollvotes (
vid
,uid
,voteoption
,dateline
,pid
) VALUES (0,2220,127,0,'')I've been trying to look for the incorrect value " in both phpBB_poll_votes and myBB_pollvotesĀ but can't find it so far... Could it come from the merger tool perhaps?
Any help on how I can proceed with the merge is greatly appreciated.
Thanks!
Andy
I think I temporarily fixed this by changing from int to varchar, imported and then found the error, corrected it and then change the table to int again.