Forum Integration Failure - Mysidia Adoptables Support Forum

Home Community Mys-Script Creative Off-Topic

		Mysidia Adoptables Support Forum > Projects > The Bug Tracker > Bug
Forum Integration Failure

Forum Integration Failure	Issue Tools

06-27-2015 10:51 AM

Kyttias Kyttias is offline

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
Issue Type Bug Project The Bug Tracker 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 Attachments 0 Assigned Users (none) Tags (none)

09-12-2015 09:53 AM

parayna

Member

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

09-16-2015 01:21 PM

Cirris

Member

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

01-11-2017 05:18 PM

SilverDragonTears SilverDragonTears is offline

I am your Nemesis.

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

PHP Code:


			
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

01-13-2017 11:06 PM

~~Silver_Brick~~ Silver_Brick is offline

Designer || Coder

hi where to run that query so i can integrate the website -

Quote:

$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');";

01-14-2017 12:28 PM

Dinocanid

Member

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

08-17-2020 11:25 PM

Hall of Famer Hall of Famer is offline

Administrator, Lead Coder

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

Issue Tools
Subscribe to this issue
View Changes

Assigned Users
Please Wait

Tags
Please Wait

All times are GMT -5. The time now is 05:06 PM.

Currently Active Users: 813 (0 members and 813 guests)
Threads: 4,081, Posts: 32,029, Members: 2,016
Welcome to our newest members, jolob.

What's New?

What's Hot?

What's Popular?