Could anybody please tell me what do I need to do here, my website is gone, but the administration site is still on, thank you all in advance
Database error in Chat Military
Query:
SELECT `p`.*, `f`.`ID`, if(`DateLastNav` > SUBDATE(NOW( ), INTERVAL 1 MINUTE ), 1, 0) AS `is_online`, UNIX_TIMESTAMP(p.`DateLastLogin`) AS 'TS_DateLastLogin', UNIX_TIMESTAMP(p.`DateReg`) AS 'TS_DateReg' FROM ( SELECT `ID` AS `ID` FROM `sys_friend_list` WHERE `Profile` = '4' AND `Check` =1 UNION SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '4' AND `Check` =1 ) AS `f` INNER JOIN `Profiles` AS `p` ON `p`.`ID` = `f`.`ID` WHERE 1 AND p.`Status`='Active' ORDER BY p.`Avatar` DESC LIMIT 0,
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 '' at line 12
Found error in the file '/home/chatmili/public_html/inc/profiles.inc.php' at line 435.
Called 'db_res' function with erroneous argument #0.