417240 - Sql Errors after saving personal data

Status: RESOLVED WORKSFORME

(Websites Graveyard :: spreadfirefox.com, defect)

Description

[/\/\arcio Galli]

After I clicked forgot password and got the temporary session log in, changed the password submitted, it dumped in a nice red box :) 

----

    * user warning: 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 'as ar, users as u WHERE u.uid=ar.uid AND u.status=1 AND u.uid = 190124' at line 1 query: SELECT totalFROM affiliates_referrals as ar, users as u WHERE u.uid=ar.uid AND u.status=1 AND u.uid = 190124 in /mnt/netapp/www.spreadfirefox.com-v2/includes/database.mysql.inc on line 172.
    * user warning: 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 'ac.active='Y' ORDER BY RAND() LIMIT 5' at line 1 query: SELECT aw.*, ac.label as cat_name FROM affiliates_weights as aw, affiliates_cats as ac where aw.status='Active' AND aw.cat_id=ac.id ac.active='Y' ORDER BY RAND() LIMIT 5 in /mnt/netapp/www.spreadfirefox.com-v2/includes/database.mysql.inc on line 172.

Comment 1

[Alex Polvi]

This seems to be fixed. I see no place in the code where the "totalFROM" typo is still in place. I also tested by resetting my password as described, no dice. Please re-open if you can re-create.