MyBB Community Forums

When I try to merge mybb users from an old forum I had,

I get this error, after connecting database then clicking on Run Usergroups

Please help me fix it and merge.

SQL Error:
1366 - Incorrect integer value: '...' for column 'maxemails' at row 1
Query:
INSERT INTO mybb_usergroups (`import_gid`,`title`,`canview`,`canpostthreads`,`canpostreplys`,`caneditposts`,`candeleteposts`,`candeletethreads`,`cansearch`,`canviewmemberlist`,`caneditattachments`,`canpostpolls`,`canvotepolls`,`canundovotes`,`canpostattachments`,`canratethreads`,`canviewthreads`,`canviewprofiles`,`candlattachments`,`description`,`namestyle`,`type`,`stars`,`starimage`,`image`,`disporder`,`isbannedgroup`,`canusepms`,`cansendpms`,`cantrackpms`,`candenypmreceipts`,`pmquota`,`maxpmrecipients`,`cansendemail`,`canviewcalendar`,`canaddevents`,`canviewonline`,`canviewwolinvis`,`canviewonlineips`,`cancp`,`issupermod`,`canusercp`,`canuploadavatars`,`canratemembers`,`canchangename`,`showforumteam`,`usereputationsystem`,`cangivereputations`,`reputationpower`,`maxreputationsday`,`maxreputationsperuser`,`maxreputationsperthread`,`candisplaygroup`,`attachquota`,`cancustomtitle`,`canusesig`,`usertitle`,`canviewboardclosed`,`modposts`,`modthreads`,`mod_edit_posts`,`modattachments`,`canviewdeletionnotice`,`cansendemailoverride`,`maxemails`,`emailfloodtime`,`canbypasseventmod`,`canmoderateevents`,`canbereported`,`canbeinvisible`,`canchangewebsite`,`candeletereputations`,`canwarnusers`,`canreceivewarnings`,`maxwarningsday`,`canmodcp`,`showinbirthdaylist`,`canoverridepm`,`canusesigxposts`,`signofollow`,`edittimelimit`,`maxposts`,`showmemberlist`,`canmanageannounce`,`canmanagemodqueue`,`canmanagereportedcontent`,`canviewmodlogs`,`caneditprofiles`,`canbanusers`,`canviewwarnlogs`,`canuseipsearch`,`tyl_limits_max`,`tyl_flood_interval`) VALUES (0,'Staff',1,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,'Staff','<span style=\"color: #54FF9F\">{username}</span>',0,0,'images/star.png','/award/UserbarStaff.png',0,0,1,1,1,1,0,0,1,1,1,1,0,0,0,0,1,1,1,0,0,1,1,0,0,0,0,1,0,1,1,'Supreme','0','0','0','0','0','1','0','...','...','0','0','1','1','1','1','0','1','...','0','1','0','...','0','...','...','1','0','0','0','0','0','0','0','0','...','...')

I'm no database expert, but it gives you the reason for the error. Where you should have a 0 or a 1, that are three dots ('...') instead:

'0','...','...','0','0','1','1','1','1','0','1','...','0','1','0','...','0','...','...','1','0','0','0','0','0','0','0','0','...','...'

maybe those are supposed to be blank and didn't backup properly? If that's the way it is in your backup, I'd probably try to replace all those with a blank space and see if you still get that error. Like search for '...' in your back up and replace with ' '

Just a suggestion unless someone else has a better idea.

I'm not sure where the ... would be coming from, the merge system doesn't set that anywhere, and the maxemails field is an integer so wouldn't be able to store a value of "..." in the first place. When you say an old forum, how old are we talking? What version of MyBB was it?

And is the old forum a MyBB one ? Or other forum engine ?

It seems to me the truncation issue that has been fixed in the development repository.

You may try the development build from https://github.com/mybb/merge-system , get it as a .zip file https://github.com/mybb/merge-system/arc...eature.zip

(2023-01-03, 06:37 PM)noyle Wrote: [ -> ]It seems to me the truncation issue that has been fixed in the development repository.

You may try the development build from https://github.com/mybb/merge-system , get it as a .zip file https://github.com/mybb/merge-system/arc...eature.zip

I didn't quite understood what you meant, so I upload this instead of the original one and this should fix the issue?

(2023-01-05, 11:43 AM)expertful Wrote: [ -> ]

(2023-01-03, 06:37 PM)noyle Wrote: [ -> ]It seems to me the truncation issue that has been fixed in the development repository.

You may try the development build from https://github.com/mybb/merge-system , get it as a .zip file https://github.com/mybb/merge-system/arc...eature.zip

I didn't quite understood what you meant, so I upload this instead of the original one and this should fix the issue?

Yes, I think so.