MyBB Community Forums

Quote:MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1366 - Incorrect integer value: '' for column 'issupermod' at row 1
Query:
INSERT INTO mybb_usergroups (import_gid,title,pmquota,maxpmrecipients,attachquota,caneditposts,​candeleteposts,candeletethreads,canpostpolls,canvotepolls,canusepms,ca​ncp,issupermod,cansearch,canuploadavatars,canview,canviewprofiles,ca​npostthreads,canpostreplys,description,type,namestyle,stars,starimag​e,image,disporder,isbannedgroup,canviewthreads,candlattachments,canp​ostattachments,canratethreads,caneditattachments,cansendpms,cantrackpms​,candenypmreceipts,cansendemail,canviewmemberlist,canviewcalendar,canad​devents,canviewonline,canviewwolinvis,canviewonlineips,canusercp,canra​temembers,canchangename,showforumteam,usereputationsystem,cangivereputat​ions,reputationpower,maxreputationsday,candisplaygroup,cancustomtitle) VALUES ('8','Global Moderators','0','6','40098','1','1','1','1','1','1','0','','1','1','1','1','1','​1','','2','{username}','0','images/star.gif','','0','0','1','1','1','1','1','1','1','1','1','1','1','1','1','0','0','1',​'1','0','0','1','1','1','5','1','1')

When i try to convert IPB to MyBB, i get this error.
I do not know what this is, as I do not work with SQL, and so, can someone please help me ASAP? Thanks.

Which version of the merge system? (how long ago did you download it?)

Just now, and 1.4 Beta 4, i've also tried Beta 3. Also, i found this:

issupermod = '' <- no value | in the error.

---

Im looking in IPB's database, and it seems, the issupermod is g_is_supmod What do i do?

in /boards/ipb2/usergroups.php find:

$insert_data['issupermod'] = $data['g_is_supermod'];

replace with

$insert_data['issupermod'] = intval($data['g_is_supermod']);

ok...

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1364 - Field 'notepad' doesn't have a default value
Query:
INSERT INTO mybb_users (usergroup,additionalgroups,displaygroup,import_usergroup,import_additionalgroups,import_displaygroup,import_uid,username,email,regdate,lastactive,lastvisit,website,avatardimensions,avatar,lastpost,birthday,icq,aim,yahoo,msn,timezone,style,regip,totalpms,unreadpms,dst,signature,salt,passwordconvert,passwordconverttype,postnum,referrer,hideemail,invisible,allownotices,subscriptionmethod,receivepms,pmnotice,pmnotify,remember,showsigs,showavatars,showquickreply,ppp,tpp,daysprune,timeformat,buddylist,ignorelist,away,awaydate,returndate,reputation,timeonline,pmfolders,avatartype) VALUES ('4','','4','4','','4','1','ctran_ipb2_import2','[email protected]','1231814109','1240621219','1240453845','http://blog.christophertran.net','','','1240446621','26-3-1992','0','admin[at]ndact[dot]net','','me[at]christophertran[dot]net','+','0','96.236.181.111','3','0','0','\n','A]l8h','416fa4318947bee316624cdc2b1cd647','ipb2','0','','1','0','1','2','1','1','1','1','1','1','1','0','0','0','h:i A','','','0','0','0','0','0','1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can','remote')

NEw error.

---

there is no notepad.

Hm, are you using Beta 3 or beta 4 right now?

Beta 4

Are you sure? I don't see what would be causing that error if your running Beta 4 :\

yes. i downloadedd the SVN and i uploaded it to the site.

---

bump.

What notepad is this?