Can anyone tell me what to do with this??

Thanks!!


Database error in

Query:
SELECT `Profiles`. `ID`, `Profiles`. `NickName`, `Profiles`. `Couple`, `Profiles`. `Sex`, if(`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE ), 1, 0) AS `is_online` FROM `Profiles` WHERE `Profiles`.`Status` = 'Active' and (`Profiles`.`Couple` = 0 or `Profiles`.`Couple` > `Profiles`.`ID`) ORDER BY `Profiles`.`Couple` ASC, `Profiles`.`DateReg` DESC LIMIT -0, 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 '-0, 0' at line 1

Found error in the file '/home/veloroom/public_html/templates/base/scripts/BxBaseIndexPageView.php' at line 372.
Called 'db_res' function with erroneous argument #0.


I tried uploading an attachment of he whole email but I dont know what file type to use. Everything I tried was rejected.

There is an error in that file. This may be because you might have edited this file. Try to reupload a fresh copy. If this doesn't fix, plz. contact us. We will look into that.

Thanks for the quick reply Praveen! My tech support found the problem:


"Do not set zero for the settings `Number of featured members displayed on front page` and `How many results show on index page in top members area` at [admin panel -> settings -> advanced settings -> Index page settings ]
I've set them to 1 so now homepage works.
If you don't want to show featured and members blocks on homepage then use [admin panel -> builders -> page blocks -> Homepage] to hide them."

You are welcome...