I’ve got following error when clicking on nodes.
"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 FROM test_annotations a INNER JOIN test_no' at line 1 query: SELECT n.title, u.name, u.uid, DISTINCT(n.nid), a.visibility, a.note FROM test_annotations a INNER JOIN test_node n ON a.nid= n.nid INNER JOIN test_users u ON a.uid=u.uid LEFT JOIN test_i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( a.nid = 9 AND 1=1) in /hsphere/local/home/volmark/....../drupal/includes/database.mysql.inc on line 172."
I happen after enabling Annotate module 5.x-1.x-dev

Comments

clemens.tolboom’s picture

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

I'm trying to reproduce this bug. In which I fail :-/ ... It it the same with beta4 release?

volmark’s picture

volmark commented

Errors in last release 14. dec.
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /hsphere/local/home/volmark/danskliv.dk/drupal/modules/annotate/annotate.module on line 328

volmark’s picture

volmark commented

I can not disable Annotate module. I’m unchecking the module in Modules panel, then clicking on Save button and then getting following error:
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /hsphere/local/home/volmark/danskliv.dk/drupal/modules/annotate/annotate.module on line 328
WHAT SHOULD I DO TO RESCUE MY SITE??

volmark’s picture

volmark commented

I’ve simply deleted the annotate catalog and it works again :o)

volmark’s picture

volmark commented

Hi Clemens. Did you fix errors?? Your last release was also buggy, see below.
Errors in last release 14. dec.
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /hsphere/local/home/volmark/danskliv.dk/drupal/modules/annotate/annotate.module on line 328

clemens.tolboom’s picture

clemens.tolboom
Primary language Dutch
Location Groningen, 🇳🇱/🇪🇺
commented
Status: Active » Closed (fixed)

Yeah ... this is stupid of me ... using cvs as a storage ... i'm using two computers ... one still without php. I close the dev for now. be back soon.

And close this issue as it looks like a duplicate of #209369

Regards,
Clemens

clemens.tolboom’s picture

clemens.tolboom
Primary language Dutch
Location Groningen, 🇳🇱/🇪🇺
commented
Assigned: volmark » clemens.tolboom