Password Recovery Error

Home

Forum Password Recovery Error

	Welcome, Guest. Please login or register. Did you miss your activation email? December 03, 2008, 03:50:53 AM

Joomla Forum

Joomla Hacks

Joomla-SMF Forum Support

Joomla-SMF 2.0.x (Moderators: -Wolverine, kai920)

Password Recovery Error

0 Members and 1 Guest are viewing this topic.

« previous next »

Pages: [1]

Author

Topic: Password Recovery Error (Read 3298 times)

TheSpunkyLobster

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 2

Password Recovery Error

« on: June 07, 2007, 06:04:00 PM »

Hey

I'm getting an sql error when trying to run password recovery. The problem seems to be that the script is trying to look up the table, and not finding it because the prefix smf_ isn't being added to the query.

Joomla 1.0.12
CB 1.02
SMF Bridge 2.0.2

Any help really appreciated on this

I've done a search but the only results showed no solution


	Logged

ikea

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 1

Re: Password Recovery Error

« Reply #1 on: June 10, 2007, 03:40:48 PM »

I have the same error

Code:

JSMF CB Plugin error :: Failed to update password to SMF:: Table 'XXXXXX.members' doesn't exist SQL=UPDATE members SET passwd = 'XXXX' WHERE id='1221' ~~~
FROM:: XXXX/com_smf/admin.smf.class.php || updatePass || 1201

could someone help me ?
Thanks in advance


	Logged

kilian

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 2

Re: Password Recovery Error

« Reply #2 on: August 24, 2007, 06:28:01 AM »

Hi there

I've got the Same Problem but i have

SMF CB Plugin 2.0.3
and Joomla 1.0.13
CB 1.1

All works great Login....Syncronisation with Joomla and SMF Users.

But the problem is that i use the CB Login Module. When a User klicks on the Button "forgot Password" after filling up the fields "Username" an "Email"...he got the same Error that ikea described.

Could anyone help?

Thx
Kili


	Logged

keltic

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 10

Re: Password Recovery Error

« Reply #3 on: August 28, 2007, 05:39:36 PM »

I'd have the same problem! Anybody found a fix for this?

Joomla 1.0.13
SMF 1.1.13
CB 1.1
JSMF 2.0.2.1
SMF CB plugin 2.0.3


« Last Edit: August 28, 2007, 05:41:49 PM by keltic »	Logged

edaniel

Joomla Newbie

Karma: +5/-0
Offline

Offline

Posts: 1

Re: Password Recovery Error

« Reply #4 on: September 05, 2007, 09:46:07 AM »

I found this on the Joomla forums and it seems to work.

Edit administrator/components/com_smf/admin.smf.class.php in function updatePass (around line 1201 in mine) FROM:

Code:

$query =
"UPDATE {$jsmfConfig->smf_prefix}members " .
"SET passwd = '".sha1(strtolower($username).$pass)."' " .
"WHERE id = '$smf_id' ";

TO:

Code:

$query =
"UPDATE smf_members " .
"SET passwd = '".sha1(strtolower($username).$pass)."' " .
"WHERE ID_MEMBER = '$smf_id' ";

Changed:

id => ID_MEMBER
{$jsmfConfig->smf_prefix} => your prefix like jos, smf


	Logged

Superdaantje

Joomla Guru

Karma: +266/-23
Offline

Offline

Posts: 370

Aka Livebox

Re: Password Recovery Error

« Reply #5 on: September 05, 2007, 03:17:11 PM »

Thanks for posting it Wink


	Logged

My Projects
Joomlabridge.org JSMF 2.0.2.1 Bridge Support and Downloads
Dutchjoomla.org Dutch Joomla Community (more then 60.000 members)
D.Wagner Webservices

keltic

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 10

Re: Password Recovery Error

« Reply #6 on: September 11, 2007, 06:14:11 AM »

Thank you, it's working fine now!


	Logged

kilian

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 2

Re: Password Recovery Error

« Reply #7 on: September 11, 2007, 10:56:03 AM »

Hallo Edaniel

Thanks a lot for your Solution!
All works great now.

Greetz
kili


	Logged

William Krick

Joomla Newbie

Karma: +0/-2
Offline

Offline

Posts: 6

Re: Password Recovery Error

« Reply #8 on: August 25, 2008, 03:14:54 PM »

The solution posted works, but it isn't really the correct way to fix the problem. Hardcoding the database prefix to "smf_members" doesn't address the real problem, which is $jsmfConfig not being in scope. Here's the correct two line solution...

In the file, \administrator\components\com_smf\admin.smf.class.php

1) Find the function called "updatePass" and add the following line
after "global $database;" ...

global $jsmfConfig;

2) Change the query code from "Where id" to "WHERE ID_MEMBER"


	Logged

espen

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 1

Re: Password Recovery Error

« Reply #9 on: September 06, 2008, 02:45:38 PM »

Hi.

cant renew the password at my site. The error I get is:

JSMF CB Plugin error::Failed to update password to SMF:: ~~~ FROM::/home/2/h/xxxxxxxxxxxx/www/xxxx/administrator/components/com_smf/admin.smf.class.php || _getSMFid || 1514

Have try-out these codes:

global $jsmfConfig;
$username = $this->getUsername($id);
if (empty($username)) {

//what to do?
//TODO empty username
return false;
}
$smf_id = $this->getSMFid(null, $username);
if (empty($smf_id)) {

//what to do?
//TODO empty uid
return false;
}
$query =
"UPDATE smf_members ".
"SET passwd = '".sha1(strtolower($username).$pass)."' " .
"WHERE ID_MEMBER = '$smf_id' ";

is there anyone that can help me??

Joomla! 1.0.15
CB 1.2 RC2
SMF 1.1.5
cb_plug_smf_2_0_3
com_smf_2_0_2

Espen


	Logged

Pages: [1]

« previous next »

Jump to: