Forum Integration Failure
|
06-27-2015 10:51 AM
|
![](image.php?s=d0b95e5ab13a4df9e7f10baa97638c07&u=15002&dateline=1452391049) |
Premium Member
|
|
Forum Integration Failure
Tweaks needed for v1.8.x of MyBB?
My registration form kept throwing the 'Failed to create forum account' error, despite the database login information being correct. The exact version of MyBB I'm using is v1.8.5.
I took a dive into functions/functions_forums.php and made an updated version of the query string. (Basically, I went into the database and 'copied' the Admin to view the query it created, copied and pasted it out and made appropriate changes so variables matched what they needed to be during registration - usergroup, password, birthday, ip address, etc.) I came up with this:
PHP Code:
$query = "INSERT INTO {$mybbprefix}users (uid, username, password, salt, loginkey, email, postnum, threadnum, avatar, avatardimensions, avatartype, usergroup, additionalgroups, displaygroup, usertitle, regdate, lastactive, lastvisit, lastpost, website, icq, aim, yahoo, skype, google, birthday, birthdayprivacy, signature, allownotices, hideemail, subscriptionmethod, invisible, receivepms, receivefrombuddy, pmnotice, pmnotify, buddyrequestspm, buddyrequestsauto, threadmode, showimages, showvideos, showsigs, showavatars, showquickreply, showredirect, ppp, tpp, daysprune, dateformat, timeformat, timezone, dst, dstcorrection, buddylist, ignorelist, style, away, awaydate, returndate, awayreason, pmfolders, notepad, referrer, referrals, reputation, regip, lastip, language, timeonline, showcodebuttons, totalpms, unreadpms, warningpoints, moderateposts, moderationtime, suspendposting, suspensiontime, suspendsignature, suspendsigtime, coppauser, classicpostbit, loginattempts, usernotes, sourceeditor) VALUES ('', '$username', '$fpass','$salty','$loginkey', '$email', '1', '1', '$avatar', '', '0', '2', '', '0', '', 'time()', 'time()', 'time()', 'time()', '0', '', '', '', '', '', '$birthday', 'all', '', '1', '0', '0', '0', '1', '0', '1', '1', '1', '0', '', '1', '1', '1', '1', '1', '1', '0', '0', '0', '', '', '0', '0', '0', '', '', '0', '0', '0', '', '', '1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can', '', '0', '0', '0', '$ip', '$ip', '', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '', '0');";
And now things work just fine for me using this instead. I feel this should be up here just in case someone needs it in the future.
|
|
Issue Details
|
Category Unknown
Status Unconfirmed
Priority 10 - Lowest
Affected Version Mys v1.3.4
Fixed Version (none)
Users able to reproduce bug
1
Users unable to reproduce bug
0
Assigned Users
(none)
Tags
(none)
|
|