Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Projects > The Bug Tracker > Bug

Forum Integration Failure Issue Tools
issueid=52 06-27-2015 10:51 AM
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
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
Assigned Users (none)
Tags (none)

09-12-2015 09:53 AM
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
Reply
09-16-2015 01:21 PM
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
Reply
01-11-2017 06:18 PM
I am your Nemesis.
 
Tried and it works but this is at the top after registering.

PHP Code:
WarningCannot modify header information headers already sent by (output started at /home/silvatal/public_html/functions/functions_forums.php:1in /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:1in /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:1in /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:1in /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:1in /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:1in /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:1in /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:1in /home/silvatal/public_html/functions/functions_forums.php on line 86 
Reply
01-14-2017 12:06 AM
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');";
Reply
01-14-2017 01:28 PM
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.
Reply
Reply

Issue Tools
Subscribe to this issue

All times are GMT -5. The time now is 05:48 AM.

Currently Active Users: 153 (2 members and 151 guests)
Threads: 3,895, Posts: 31,005, Members: 15,448
Welcome to our newest members, laurenannedaniel.
BER





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2017, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636