Thread: help with this anyone?

i have just got an email with error message, I cant make out whats wrong all iknow is that i cannot view profiles (active) (un confirmed) (suspened) from the admin panel, heres a copy of the mail any help would be great, Cheers

Error in substr(/climax/admin/profiles.php, 0, (strlen(/climax/admin/profiles.php) - @strlen())): 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 1
Query: 'SELECT `ID`, `Picture`, `Sex`, `ProfileType`, DATE_FORMAT(`LastLoggedIn`, '%d/%m/%y %H/%i' ) AS LastLoggedIn, `NickName`, `RealName`, `MerchantPrice`, `Status` FROM `Profiles` WHERE 1 ORDER BY LastLoggedIn deleted LIMIT 0, 30;'

Is this a fresh install, or an existing site?
what are you running? 5.3, 5.4, 5.5. 5.6 ???

If this is not a fresh install, then what changes have you made/mods installed prior to this happening?

cheers m8ty but it seems to have fixed its self, strange i know. i'm running GPL.

Thanks for the relpy good of ya to show help is here if you need it.
Bren