I have this error I do not understand WHY?
Query:
SELECT
`Profiles`.* , if(`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE ), 1, 0) AS `is_online`
FROM
`Profiles`
LEFT JOIN
`sys_profile_rating`
ON
`Profiles`.`ID` = `sys_profile_rating`.`pr_id`
WHERE
`Profiles`.`Status` = 'Active' and (`Profiles`.`Couple` = 0 or `Profiles`.`Couple` > `Profiles`.`ID`)
ORDER BY
`sys_profile_rating`.`pr_rating_sum` DESC
LIMIT 1360, 5
Mysql error: Incorrect key file for table '/tmp/#sql_1026_0.MYI'; try to repair it
Found error in the file '/home/metrology.tv/public_html/templates/base/scripts/BxBaseBrowse.php' at line 729.
Called 'db_res' function with erroneous argument #0.
