i have 6.1.4 .
Database error in Dateing
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 LastLoggedIn
LIMIT 0, 30
Mysql error:
Unknown column 'LastLoggedIn' in 'order clause'
Found error in file /home/dateing/public_html/admin/profiles.php
at line 268. Called db_res function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/dateing/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`
FROM `Profiles`
need help...
