MYSQL Query Error

Hi

I am receiving a lot of email indicates a syntax problem in select query as follow:

Database error in *****

Query:

SELECT
            `tgs`.`Tag` as `Tag`,
            `tgs`.`Date` as `Date`,
            COUNT(`tgs`.`ObjID`) AS `count`
            FROM `sys_tags` `tgs`  WHERE `tgs`.`Tag` IS NOT NULL AND `tgs`.`Type` = 'bx_videos' union all select null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null where 'x'='x' GROUP BY `Tag` LIMIT 30

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 'where 'x'='x' GROUP BY `Tag` LIMIT 30' at line 5

Found error in the file '/home/****/public_html/inc/classes/BxDolTags.php' at line 151.
Called 'db_res' function with erroneous argument #0.

any idea what is the problem?

you need to enable full_debug mode on dolphin for mysql this will give you more information. once you have that information you can post back in here. 

/inc/classes/BxDolDb.php

change debug mode from false to true

thanks DosDawg

I'll enable it and back again

thanks