MyBB Community Forums

Full Version: MyBB SQL Error on merging system
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I was facing an error when tried to merge SMF 2.0.1 to MyBB 1.6, using MyBB Merge System - Version: 1.6.7.

FYI, this SMF is a brand new vanilla installed, so only has General Discussion forum, and 1 user, which is the admin himself.

The error warns:
Quote:MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1366 - Incorrect integer value: '' for column 'gid' at row 1
Query:
INSERT INTO mybb_forumpermissions (gid,canview,canonlyviewownthreads,canviewthreads,candlattachments,canpostthreads,canpostreplys,canpostattachments,canratethreads,caneditposts,candeleteposts,candeletethreads,caneditattachments,canpostpolls,canvotepolls,cansearch,fid) VALUES ('','1','0','1','1','1','1','1','1','1','1','1','1','1','1','1','')

Please contact the MyBB Group for support.

The appearance is attached.

Anyone knows the fix?

Anyway,
Then I went Pause, and continued the rest of the process, and so far it seemed unaffected by that error.

TIA
merge system only support 2.0, i think there were some major fixes in 2.0.1
i see.
do you know where I can submit the bug tracker for this?

regards,
rico
merge smf to vb 3.8.x and merge 3.8.x to mybb.