Database Error

If  some one unregister I get   database error

 

Query:

SELECT `cmt_id`, `cmt_parent_id` FROM [db_prefix]_cmts WHERE `cmt_author_id` = '896' AND `cmt_replies` = 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 '[db_prefix]_cmts WHERE `cmt_author_id` = '896' AND `cmt_replies` = 0' at line 1

Found error in the file '/home/homepages/apps/dolphin-7.0.1/inc/classes/BxDolCmtsQuery.php' at line 167.
Called 'getAll' function with erroneous argument #0.

Quote · 27 Oct 2010

Hello [db_prefix] should be replaced with real db table!

PS: If possible do not write me personally, please try to ask on the forum first
Quote · 28 Oct 2010

in '/home/homepages/apps/dolphin-7.0.1/inc/classes/BxDolCmtsQuery.php' at line 167.

there is

$a = $this->getAll ("SELECT `cmt_id`, `cmt_parent_id` FROM {$this->_sTable} WHERE `cmt_author_id` = '$iAuthorId' AND `cmt_replies` = 0");

 

So where should I replace this?

Thank you very much!

Quote · 28 Oct 2010
 
 
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.