Dophin Noob here. Users' pw not being recognized.

As Admin I get in ok. but new users' Pwd not recognized. Agony here. In the admin I click on Members and get this blowup message:

====

Query:
SELECT `Profiles`.`ID` as `ID`, `NickName`, `Email`, `Sex`, DATE_FORMAT(`DateLastLogin`,
'%m-%d-%y %H:%i' ) AS `DateLastLoginCur`, DATE_FORMAT(`DateReg`, '%m-%d-%y %H:%i' ) AS
`DateReg`, `Status` FROM `Profiles` WHERE 1 AND (`Couple`=0 OR `Couple`>`Profiles`.`ID`)
ORDER BY DateLastLogin deleted LIMIT 0, 30
Mysql error:
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 'deleted LIMIT 0, 30' at line 17
Found error in file /home/<mydomainname>/public_html/admin/profiles.php
at line 280. Called db_res function with erroneous argument #0
=======

My server's mySQL version is the latest. using latest ver of Dolphin. Should I do a (reverse) MD5 Hash?   Any ideas? Some help?

BarryG

Right here.

ORDER BY DateLastLogin deleted LIMIT 0, 30


DateLastLogin is the field the results are sorted by. and the next item is supposed to be ASC or DESC for assending or desending order. But i see deleted there.


So my question is, have you installed any mods?

Hi there -- no, its a pure vanilla setup. This passwd problem seems to be the worst -- I have had to wipe out the db and just overwrite it. I shudder when this will happen to new members. What can prevent it???? Do you have any experience why it said DELETED instead of ASC or DESC?

thanks much -- will save my sanity. I very much want to use Dolphin.

BarryG