Ive been getting this error sent to me through the debug email and it states a database error, Ive looked into the specific line it refers to and was wondering if this is a bug in the search_result.php file?
---------------------------------------------------------------------------
Database error in TTchat
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` = 'chat' )
ORDER BY
1 DESC,
Profiles.LastLoggedIn DESC
LIMIT 0, 10
Mysql error:
Unknown column 'LastNavTime' in 'field list'
Found error in file Removed\htdocs\search_result.php //path has been removed
at line 575. Called db_res function
with erroneous argument #0
Debug backtrace:
Array
(
[1] => Array
(
[file] => Removed\htdocs\search_result.php //path has been removed
[line] => 575
[function] => db_res
[args] => Array
(
[0] =>
SELECT DISTINCT
`Profiles`.*,
(LastNavTime > SUBDATE(NOW(), INTERVAL 5 MINUTE)) as is_onl
----------------------------------------------------------------------------------
Now I only posted part of the debug email but I looked in Mysql database and in profiles there is only a column named "DateLastNav" not as it shows from above "LastNavTime" ? If this isnt the problem and someone can help explain let me know and ill post the rest of the debug message to help.
