Solved: 2 Years, 3 Months, 2 Weeks ago Problems merging from phpBB3 poll votes incorrect integer value "
#1
Solved: 2 Years, 3 Months, 2 Weeks ago
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 (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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)