Problem to enter into topics of events, groups

When I create new topic into events or groups, - it's good, but after that I try to open new topics - error

 

Error
Database query error
Query:
SELECT SQL_CALC_FOUND_ROWS `p`.* FROM `Profiles` AS `p` INNER JOIN `bx_groups_fans` AS `f` ON (`f`.`id_entry` = '3' AND `f`.`id_profile` = `p`.`ID` AND `f`.`confirmed` = 1 AND `p`.`Status` = 'Active' ) ORDER BY `f`.`when` 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 1
 
Found error in the file '/var/www/center/inc/classes/BxDolTwigModuleDb.php' at line 305.
Called 'getAll' function with erroneous argument #0.
 
 
Please help me to solve this.
Quote · 26 Sep 2013

The range is mising from  the SQL statement.

SELECT SQL_CALC_FOUND_ROWS `p`.* FROM `Profiles` AS `p` INNER JOIN `bx_groups_fans` AS `f` ON (`f`.`id_entry` = '3' AND `f`.`id_profile` = `p`.`ID` AND `f`.`confirmed` = 1 AND `p`.`Status` = 'Active' ) ORDER BY `f`.`when` DESC LIMIT 0, [missing number]

If you would try

SELECT SQL_CALC_FOUND_ROWS `p`.* FROM `Profiles` AS `p` INNER JOIN `bx_groups_fans` AS `f` ON (`f`.`id_entry` = '3' AND `f`.`id_profile` = `p`.`ID` AND `f`.`confirmed` = 1 AND `p`.`Status` = 'Active' ) ORDER BY `f`.`when` DESC LIMIT 0,30


you see the query will output something

Dedicated servers for as little as $32 (28 euro) - See http://denre.com for more information
Quote · 26 Sep 2013

I don't know where i must change query to sql

Quote · 26 Sep 2013

In modules/boonex/events/classes/BxEventsModule.php

Below the line :

define ('BX_EVENTS_FILES_TAG', 'events');

You should see :

define ('BX_EVENTS_MAX_FANS', 1000);


You are getting an error because your site has been modified and someone has messed with that line in bold. You need to have that line in place and it must be set to a positive number


The same applies to Groups

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 26 Sep 2013
 
 
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.