[Hurricane]

03-27-03 at 06:26 PM jwpexe2 said this in Post #77
I getting this error in my email box and it is caused when the user tries to update their password from the retrive Retrieve lost password.


Invalid SQL: UPDATE pndb.nuke_users SET pn_pass='56302cb1891d8f4629952f11a8564f30' WHERE userid=$bbuserinfo[userid] mysql error: You have an error in your SQL syntax near '[userid]' at line 1

mysql error number: 1064

I have tried to some to change this part of the code and get new errors so I gess its in here in the members.php file.

///////// PN Integration Hack Start: ///////////////
//`Update PN users password
$pnuser='$bbuserinfo[userid]';
// if ($pnuser=1) {$pnuser=2; } //Uncomment this line if you did not remove the anon account and move the pn admin to uid 1
$DB_site->query("UPDATE pndb.nuke_users SET pn_pass='".addslashes(md5($newpassword))."' WHERE userid=$pnuser");
///////// PN Integration Hack End: ///////////////

Try changing the last part to:
userid='$pnuser'");

See if that will help.