Forum Integration Failure

[Kyttias]

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:

$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.

[parayna]

Thanks for putting this here XD I was having the same problem and came on just now to ask why but saw this and tried it out, and it works! Thank you! XD

[Cirris]

I recently installed MyBB and Mysidia and had the same problem. Registration was failing on Mysidia. With your edit, I can now register new users. Although, users will both log in and out from Mysidia (while also affecting the forum), but logging in and out from the forum does not affect Mysidia. Is this normal? Thanks for the edit, by the way. :3

MyBB Version: 1.8.6
Mysidia Version: 1.3.4

[SilverDragonTears]

Tried and it works but this is at the top after registering.

Warning: Cannot modify header information - headers already sent by (output started at /home/silvatal/public_html/functions/functions_forums.php:1) in /home/silvatal/public_html/functions/functions_forums.php on line 86

Warning: Cannot modify header information - headers already sent by (output started at /home/silvatal/public_html/functions/functions_forums.php:1) in /home/silvatal/public_html/functions/functions_forums.php on line 86

Warning: Cannot modify header information - headers already sent by (output started at /home/silvatal/public_html/functions/functions_forums.php:1) in /home/silvatal/public_html/classes/class_cookies.php on line 85

Warning: Cannot modify header information - headers already sent by (output started at /home/silvatal/public_html/functions/functions_forums.php:1) in /home/silvatal/public_html/classes/class_cookies.php on line 88

Warning: Cannot modify header information - headers already sent by (output started at /home/silvatal/public_html/functions/functions_forums.php:1) in /home/silvatal/public_html/classes/class_cookies.php on line 90

Warning: Cannot modify header information - headers already sent by (output started at /home/silvatal/public_html/functions/functions_forums.php:1) in /home/silvatal/public_html/classes/class_cookies.php on line 92

Warning: Cannot modify header information - headers already sent by (output started at /home/silvatal/public_html/functions/functions_forums.php:1) in /home/silvatal/public_html/functions/functions_forums.php on line 86

Warning: Cannot modify header information - headers already sent by (output started at /home/silvatal/public_html/functions/functions_forums.php:1) in /home/silvatal/public_html/functions/functions_forums.php on line 86

[Silver_Brick]

hi where to run that query so i can integrate the website -
$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');";

[Dinocanid]

You don't run the query, you go to public_html/functions/functions_forums.php and replace the existing query line with this one.

[Hall of Famer]

Mys v1.3.5 will have new integration code compatible with MyBB v1.8.x.