Database error in (sitename)

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.

 

Quote · 5 Mar 2015

The error is saying that the following setting option is empty :

'Number of friends displayed per page in profile'

Login to your Admin Panel, go to your Settings section and put back a value for that option.

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 5 Mar 2015

Hi,

I just checked it out and I can see I have 14 members on that option, could you please cgo to this site to see if the site opens on you browser, thank you .

Quote · 5 Mar 2015
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.