I get emails about some database error on profile, the Boonex team havent answerd or anything on a ticket for 5 days, so...
i hope someone could help me :)
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` = '9' AND `Check` =1
UNION
SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '9' 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/wallb0/public_html/pratebobla.com/inc/profiles.inc.php' at line 435.
Called 'db_res' function with erroneous argument #0.
