Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved IPB 4.3.6 to mybb 1.819
#1
Not Solved
Hi I'm migrating this IPB in 4.3.6 to mybb using the merge system.
When merging userGroups I have an sql error

SQL Error:
    1264 - Out of range value for column 'pmquota' 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`) VALUES (7,'Membre 501st',0,1,1,0,0,1,0,1,1,0,0,1,0,1,1,0,1,'','{username}',2,0,'images/star.png','',0,0,0,1,1,1,-1,50,1,1,1,1,0,0,0,0,1,1,1,0,0,1,1,1,5,5,5,1,0,1,1) 
pmquota seems to be  unisgned
   


and here we have a value of -1.

what should I do? change this value to 0 ?
Reply
#2
Not Solved
The pmquota column is expecting an integer. -1 is not an integer nor is it used in MyBB for this column. I assume you don't want the said usergroup to be able to receive/send PMs? If so, you can set pmquota to 0 and canusepms to 0.
Plugin Count: I lost count.
Public Plugins are available here.
Official GitHub.
Please do not PM me for support unless asked to.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)