Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 9 Years, 2 Months, 3 Weeks ago vB 3.8.4 to MyBB 1.6.8
#1
Solved: 9 Years, 2 Months, 3 Weeks ago
A friend of mine recently became the owner of a medium-large-ish vBulletin forum, and has tasked me with converting it after I convinced him to move to MyBB. I decided in my infinite wisdom to try the conversion process on a backup copy first in case there are problems. Turns out this was a good idea because the merge system chokes on the first user.

Quote:SQL Error:
1366 - Incorrect integer value: '' for column 'import_usergroup' at row 1
Query:
INSERT INTO mybb_users (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,failedlogin,usernotes,passwordconvertsalt) VALUES ('2','','2','','','2','1','USERNAME','','','0','USEREMAIL','1109419200','1270134582','1266622440','USERWEBSITE','1','','1','','','','','1266622360','','','','','1','1','','','0','0','','PASSWORDHASH?','vb3','0','0','04-01-0000','all','2','1','0','1','1','1','0','0','0','0','0','','','0','0','0','0','0','0','0','0','1','63','0','1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can','','','1','0','1','0','0','0','0','0','0','0','0','0','0','0','','rVp')

logs folder is empty except the blank index.html

Error anonymized to protect user.

What do I need to do to get this working?
[Image: LogoO.png]
Jump to the post that solved this thread.


Messages In This Thread
vB 3.8.4 to MyBB 1.6.8 - by Firestryke31 - 2012-06-13, 02:44 PM
RE: vB 3.8.4 to MyBB 1.6.8 - by pavemen - 2012-06-13, 03:26 PM
RE: vB 3.8.4 to MyBB 1.6.8 - by Firestryke31 - 2012-06-13, 11:27 PM
RE: vB 3.8.4 to MyBB 1.6.8 - by Firestryke31 - 2012-06-18, 04:17 PM
RE: vB 3.8.4 to MyBB 1.6.8 - by pavemen - 2012-06-18, 05:08 PM
RE: vB 3.8.4 to MyBB 1.6.8 - by Firestryke31 - 2012-06-19, 04:35 AM
RE: vB 3.8.4 to MyBB 1.6.8 - by pavemen - 2012-06-19, 04:54 AM
RE: vB 3.8.4 to MyBB 1.6.8 - by Firestryke31 - 2012-06-19, 03:37 PM
RE: vB 3.8.4 to MyBB 1.6.8 - by Firestryke31 - 2012-06-28, 02:52 PM
RE: vB 3.8.4 to MyBB 1.6.8 - by Firestryke31 - 2012-06-29, 03:40 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)