I tried both beta4 and the dev version and I get:

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), a.visibility, a.note, a.timestamp FROM annotations a INNER JOIN' at line 1 query: SELECT n.title, u.name, u.uid, DISTINCT(n.nid), a.visibility, a.note, a.timestamp FROM annotations a INNER JOIN node n ON a.nid= n.nid INNER JOIN users u ON a.uid=u.uid WHERE a.nid = 14 AND 1=1

I have MySQL 4.1.22 on that server and I think this might be the problem.

Comments

clemens.tolboom’s picture

clemens.tolboom
Primary language Dutch
Location Groningen, 🇳🇱/🇪🇺
commented

Could you try to change the annotate.module code by placing "n.nid" in front of the string.

Check both functions
- _annotate_list_by_user
- _annotate_list_by_node

I do not have a mysql 4.x version around. My guess is that DISTINCT must be the first part of the SQL statement. If not can you test the demo site then. Maybe I overlooked something.

Regards,
Clemens

clemens.tolboom’s picture

clemens.tolboom
Primary language Dutch
Location Groningen, 🇳🇱/🇪🇺
commented
Status: Active » Postponed (maintainer needs more info)
clemens.tolboom’s picture

clemens.tolboom
Primary language Dutch
Location Groningen, 🇳🇱/🇪🇺
commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Unfortunately no user feedback received.