• Welcome to Simple Machines Community Forum. Please login or sign up.
December 07, 2021, 10:48:28 AM

News:

Wondering if this will always be free?  See why free is better.


Cannot retrieve password

Started by legolas, August 21, 2005, 04:36:27 PM

Previous topic - Next topic

legolas

August 21, 2005, 04:36:27 PM Last Edit: August 21, 2005, 05:03:31 PM by [Unknown]
Hi,
When I try to retrieve the password, I get this error:-

SQL errorDB function failed with error number 1146
Table 'mywebsite_mymambo.smf_members' doesn't exist SQL=UPDATE smf_members SET passwd='zzz' WHERE memberName='bobob' AND emailAddress='xxx@yahoo.com'
SQL =

UPDATE smf_members SET passwd='zzz' WHERE memberName='bobob' AND emailAddress='xxx@yahoo.com'


Any ideas why this is happening?? Thanks  ;D

Orstio


legolas


Orstio

Ah.  Please upgrade to 3.19a.  :D

exrace

August 28, 2005, 02:07:45 PM #4 Last Edit: August 28, 2005, 02:24:51 PM by exrace
I am using 3.19a(stable) and using bridge registration.
I get same error.
My error shows the query trying to use my mambo db not the smf db (using separate db's)
Interesting enough I get the e-mail message "New password for " but password was never reset.

Most of the functionality works great but along with this is when a new user registers and SMF is set to notify user and require admin authorization the user gets the email stating "waiting for admin" but never the confirmation. Users do get added to the mambo db and they can login so it looks to be centered around the notification methods.

I have also noticed "Send a SMF PM to the user on registration" in the SMF Registration will not stay selected when configuration the options in Mambo no matter what selections I take for the registration type.

Orstio

QuoteMost of the functionality works great but along with this is when a new user registers and SMF is set to notify user and require admin authorization the user gets the email stating "waiting for admin" but never the confirmation. Users do get added to the mambo db and they can login so it looks to be centered around the notification methods.

Admin authorization is not supported in the bridge registration.  I don't know if that will ever be possible.

exrace

I will try other methods to see the end result.
On the DB error - is this due to the auth method?

Orstio

Can you confirm this code is in the file smf_registration.php, inside the sendNewPass function?

mysql_select_db($db_name);
$sql = "UPDATE {$db_prefix}members SET passwd='$newpass' WHERE memberName='$checkusername' AND emailAddress='$confirmEmail'";
$database->setQuery( $sql );
if (!$database->query()) {
die("SQL error" . $database->stderr(true));
}

exrace


Orstio

Great.

Can you try changing that to this:

mysql_select_db($db_name);
$sql = mysql_query("UPDATE {$db_prefix}members SET passwd='$newpass' WHERE memberName='$checkusername' AND emailAddress='$confirmEmail'");

exrace

That fixed it.
I received the e-mail and can login with the changed password.  :)

exrace

I have now tried to reset password using the option=com_user&task=UserDetails within mambo.
It allows the change of the password in mambo but the forum login fails with the new password.
Am I safe to say this is not supported as it doesn't work in concert with the bridge?

Kindred

the bridge uses SMF as the baseline....  changes made to passwords in SMF will be ported to mambo on the next login. Accounts added to SMF will be ported to mambo on the first login...

changes made to passwords in mambo or users added through the mambo admin interface will NOT be ported back to SMF.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.<br /><br />"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Orstio

QuoteI have now tried to reset password using the option=com_user&task=UserDetails within mambo.
It allows the change of the password in mambo but the forum login fails with the new password.
Am I safe to say this is not supported as it doesn't work in concert with the bridge?

That's right.  You see, the bridge doesn't change anything in Mambo (no Mambo core files are altered), so the com_user component in Mambo makes no changes to users in SMF.

Some things to keep in mind are:  Mambo and SMF do not use the same technique for password hashing, so the hashed password in the database cannot just be transferred from one to the other.  Upon logging in, the password is first tested in SMF (which is a more thorough check than Mambo's), and if that passes, then the password is hashed using Mambo's method, and written to Mambo's database.  This cannot be done both ways, because it would always leave a security hole.  So, I chose SMF to Mambo, because the password test is more thorough.

exrace

While doing some testing I ran into another issue with this with Joomla 1.01
I submit a request to send password via the login forum component.
When the form is submited the submit crashes with this being returned to the browser:
SQL errorDB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1 SQL=1
SQL =
1


I do get the e-mail and the new password works.

I have the same code hack suggested above in place and this did work in 4.5.x.x


Advertisement: