2014-07-04, 07:27 AM
I am setting up a brand new instance of MyBB and trying to convert a phpBB 3 instance. I am getting the error in the subject with the below SQL. Any idea?
I can tell what the problem is but unsure of what I should do to resolve the issue.
INSERT INTO mybb_rx8clubusers (`usergroup`,`additionalgroups`,`displaygroup`,`import_usergroup`,`import_additionalgroups`,`import_displaygroup`,`import_uid`,`username`,`password`,`salt`,`loginkey`,`email`,`regdate`,`lastactive`,`lastvisit`,`website`,`showsigs`,`signature`,`showavatars`,`timezone`,`avatardimensions`,`avatartype`,`avatar`,`lastpost`,`icq`,`aim`,`yahoo`,`msn`,`hideemail`,`allownotices`,`regip`,`lastip`,`longregip`,`longlastip`,`language`,`passwordconvert`,`passwordconverttype`,`postnum`,`invisible`,`birthday`,`birthdayprivacy`,`subscriptionmethod`,`receivepms`,`receivefrombuddy`,`pmnotice`,`pmnotify`,`showquickreply`,`ppp`,`tpp`,`daysprune`,`timeformat`,`dst`,`buddylist`,`ignorelist`,`style`,`away`,`awaydate`,`returndate`,`referrer`,`referrals`,`reputation`,`timeonline`,`showcodebuttons`,`totalpms`,`unreadpms`,`pmfolders`,`notepad`,`threadmode`,`showredirect`,`dateformat`,`dstcorrection`,`warningpoints`,`moderateposts`,`moderationtime`,`suspendposting`,`suspensiontime`,`suspendsignature`,`suspendsigtime`,`coppauser`,`classicpostbit`,`loginattempts`,`usernotes`) VALUES ('2,2,2','2,2','2,2,2','1050410507,10506,','1050710506,','10507','2','rx8club','','81e7d982d1745ce5','948f8n8WUyS2efcbKqZ8J1qVIfRCSpLwtXUUPNH2XlvzRblHVp','[email protected]','1084425806','1221484546','1221484546','','1','','1','100','0|0','','','1221482126','','','','','0','0','','','0','0','','$H$7ejcX/qisR5SyqmBs3E8jgw2wqEfGa/','phpbb3','0','1','- 0- 0-','all','0','0','0','1','1','1','0','0','0','d M Y h:i a','0','','','0','0','0','0','0','0','0','0','1','2','0','1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can','','','1','0','1','0','0','0','0','0','0','0','0','0','0','')I can tell what the problem is but unsure of what I should do to resolve the issue.