cron email - Database query error

I get a cron tab email every 10-15 while im working on my site and the email i receive is broken html with this message

Database query error

thats it, I have no idea how to track down what is wrong.

On my site everything "appears" to be working though and I receive no errors on the front end

My errors logs dont show any database related errors, im stumped

Hello

You need to edit inc/classes/BxDolDb.php file and find the following line

define( 'DB_FULL_DEBUG_MODE', false );

Replace false with true and save. In this case you should receive a detailed description of Database Error.

Note. If the error appeared in user end this detailed error log will be available to common users or visitors. So, you need to disable Debug mode when the problem is resolved.  

thank you the reply

this worked

there seems to be a problem with one of modzzz modules

SELECT `author_id`, count(`author_id`) as Cnt FROM
`bx_groups_main` WHERE `status` = 'approved' AND `author_id` NOT
IN (SELECT `member_id` FROM `modzzz_achieve_main` WHERE
`achieve_id`=14) GROUP BY `author_id` HAVING `Cnt` >= 3

[error_message] => Table 'mydb.bx_groups_main' doesn'texist

than you should post this in his support thread or contact him. He will help.

Good luck

ok, it seems the groups module needed to be installed for the achievement module to work.

Its strange because when I install the achievement module, it does not ask that I need groups or events installed first.

Looks like an oversight.  You should let the developer know about the missing dependency.