Sql Errors after saving personal data

RESOLVED WORKSFORME

Status

Websites Graveyard
spreadfirefox.com
RESOLVED WORKSFORME
11 years ago
7 years ago

People

(Reporter: /\/\arcio Galli, Unassigned)

Tracking

Details

(Reporter)

Description

11 years ago
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

10 years ago
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.
Assignee: ian-bugzilla → nobody

Updated

10 years ago
Status: NEW → RESOLVED
Last Resolved: 10 years ago
Resolution: --- → WORKSFORME
(Assignee)

Updated

7 years ago
Product: Websites → Websites Graveyard
You need to log in before you can comment on or make changes to this bug.