| Project: | External Link Popularity |
| Version: | 6.x-1.4 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
| Issue tags: | sql |
Issue Summary
Hi,
I also have the SQL error with this 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/vhosts/mahnportal.net/subdomains/shop/httpdocs/sites/all/modules/pop_links/pop_links.module on line 278."
Due to my own investigations the reason for this is the "workflow" module - especially the sub-module "workflow_access". At least the error appears the first time after installing this module.
Any idea how to get them work together?
Thanks
Ralf