user warning: You have an error in your SQL syntax;

Hi:

Are you sure that you are using Version 6.x-1.x-dev? There is no query on line 278 of the pop_links.module for this version.

What other modules are you using in conjuction with pop_links?

--sicjoy

It looks like another module is using hook_db_rewrite_sql improperly. It is incorrectly altering a query that External Link Popularity has exposed through this hook.

I'm 99% positive that this is the problem. The other module is inserting DISTINCT(n.nid) into my query, which causes the error.

You can try turning off the other modules, one by one, until the problem goes away. You'll know the problem is gone by checking the log without getting the sql error. That way we can single out the culprit and report a bug in their issue queue.

--sicjoy

Closing due to inactivity. Please re-open if anyone is experiencing this error.

Having the same problem. I found that this is because of conflict with "Taxonomy Access Control Lite" module.

user warning: 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, p.url, u.name, p.hostname, p.timestamp FROM pop_links_' at line 1 query: SELECT p.cid, DISTINCT(n.nid), n.title, p.url, u.name, p.hostname, p.timestamp FROM pop_links_stats p LEFT JOIN users u ON u.uid = p.uid LEFT JOIN node n ON n.nid = p.nid ORDER BY p.timestamp DESC LIMIT 0, 30 in /var/www/mysite/sites/all/modules/pop_links/pop_links.module on line 278.

This problem is with the Taxonomy Access Control Lite module. It is not implementing hook_db_rewrite_sql() properly. Most likely, that module is assuming that all queries exposed by db_rewrite_query() are related to nodes, and that's not a good assumption.