I keep getting this error, what may be the cause of it?

user 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 'DISTINCT(n.nid)) , n.title FROM index_node n INNER JOIN index_video v WHERE n.t' at line 1
query: SELECT DISTINCT (DISTINCT(n.nid)) , n.title FROM index_node n INNER JOIN index_video v WHERE n.type = 'video' AND n.status = 1 AND n.moderate = 0 ORDER by v.clicks DESC LIMIT 0, 10 in /var/www/vhosts/sabrina.sg/httpdocs/includes/database.mysql.inc on line 66.

Thanks in advance.

Comments

keve’s picture

keve commented

This query is not produced by TAC.
Check another module that use tables 'index_video' and 'index_node', and then please, change the 'project' property of this bug report.

Sabrina’s picture

Sabrina commented

This problem only appears when I active TAC.

keve’s picture

keve commented

. To know which can generate this sql query, please indicate what other modules you use.

keve’s picture

keve commented

I could not find any module for which you created tables 'index_node' and 'index_video' in your database. Is it your own module?

keve’s picture

keve commented
Status: Active » Closed (fixed)

Without more comments from user, I close this issue.