After a member joined the site,now i keep getting this error when i try to go to members on the admin site. the following error message was sent via email to me. can anybody help.
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`
, `IDLevel`, IF(ISNULL(`MemLevels`.`Name`),'', `MemLevels`.`Name`) AS `MemName`
FROM `Profiles`
LEFT JOIN `ProfileMemLevels` ON `ProfileMemLevels`.`IDMember` = `Profiles`.`ID`
LEFT JOIN `MemLevels` ON `ProfileMemLevels`.`IDLevel` = `MemLevels`.`ID`
WHERE
1 AND (`Couple`=0 OR `Couple`>`Profiles`.`ID`)
GROUP BY `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 19
Found error in file /home/repursel/public_html/admin/profiles.php
at line 268. Called db_res function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/repursel/public_html/admin/profiles.php
[line] => 268
[function] => db_res
[args] => Array
(
[0] =>
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`
, `IDLevel`, IF(ISNULL(`MemLevels`.`Name`),'', `MemLevels`.`Name`) AS `MemName`
FROM `Profiles`
LEFT JOIN `ProfileMemLevels` ON `ProfileMemLevels`.`IDMember` = `Profiles`.`ID`
LEFT JOIN `MemLevels` ON `ProfileMemLevels`.`IDLevel` = `MemLevels`.`ID`
WHERE
1 AND (`Couple`=0 OR `Couple`>`Profiles`.`ID`)
GROUP BY `Profiles`.`ID`
ORDER BY DateLastLogin deleted
LIMIT 0, 30
)
)
)
Called script: /admin/profiles.php
Request parameters:
Array
(
[sortor] => DateLastLogin
[sorttype] => deleted
[ZP_CAL] => \'fdow\':null,\'history\':\"2008/08/30/22/37\",\'sortOrder\':\"asc\",\'hsize\':9
[lang] => en
)
--
Auto-report system