Error
Database query error
Query:
SELECT DISTINCT
`Profiles`.*,
(LastNavTime > SUBDATE(NOW(), INTERVAL 5 MINUTE)) as is_onl
FROM Profiles
INNER JOIN `Tags` USING( `ID` ) WHERE Status = 'Active' AND `Tags`.`Type` = 'profile' AND ( `Tags`.`Tag` = 'witty' )
ORDER BY
1 DESC,
Profiles.LastLoggedIn DESC
LIMIT 0, 10
Mysql error:
Unknown column 'LastNavTime' in 'field list'
Found error in file
/home/toto2k10/filipinofriendsterworld.com/search_result.php
at line
575. Called
db_res function
with erroneous argument #
0
Debug backtrace:Array
(
[1] => Array
(
[file] => /home/toto2k10/filipinofriendsterworld.com/search_result.php
[line] => 575
[function] => db_res
[args] => Array
(
[0] =>
SELECT DISTINCT
`Profiles`.*,
(LastNavTime > SUBDATE(NOW(), INTERVAL 5 MINUTE)) as is_onl
FROM Profiles
INNER JOIN `Tags` USING( `ID` ) WHERE Status = 'Active' AND `Tags`.`Type` = 'profile' AND ( `Tags`.`Tag` = 'witty' )
ORDER BY
1 DESC,
Profiles.LastLoggedIn DESC
LIMIT 0, 10
)
)
)
Called script: /search_result.php
Request parameters:Array
(
[tag] => witty
)