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
Assigned: volmark » clemens.tolboom

I still cannot reproduce this.

I installed i18n and expected that on the annotations tab the error should be produced.

The version of annotate.module on demo site when testing is '1.6.2.7'

Any suggestions?

clemens.tolboom’s picture

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

(changed my nonsense and dead link)
I can find annotate_ym in error. But not annotate.

volmark’s picture

volmark commented
Component: Code » annotate (private)

Im still getting a bug, now on the local development server

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\Servers\xampp\htdocs\drupal\modules\annotate\annotate.module on line 328

clemens.tolboom’s picture

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

The version used on http://annotate.build2be.com/nl/node/104/annotations right now is:

// $Id: annotate.module,v 1.6.2.9 2008/01/19 09:22:02 clemenstolboom Exp $

Can you please check this.

clemens.tolboom’s picture

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

I see no other option then to close this issue.
- no user feedback.
- unable to reproduce.

deliriumbg’s picture

deliriumbg commented 
* 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 'AND n.status = 1 AND n.promote=1 ) ORDER BY vc.value DESC, n.created LIMIT 5' at line 1 query: SELECT * FROM node n LEFT JOIN votingapi_cache vc ON vc.content_id=n.nid LEFT JOIN term_node t ON n.nid = t.nid WHERE ( 1=1 ) AND ( 1=1 AND vc.content_type='node' AND vc.value_type='points' AND vc.tag='vote' AND vc.function = 'sum' AND n.type='drigg' AND n.created > UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - 60*60*72 AND t.tid= AND n.status = 1 AND n.promote=1 ) ORDER BY vc.value DESC, n.created LIMIT 5 in /home/onlinega/public_html/includes/database.mysql.inc on line 172.
    * 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 'AND n.status = 1 AND n.promote=0 ) ORDER BY vc.value DESC LIMIT 5' at line 1 query: SELECT * FROM node n LEFT JOIN votingapi_cache vc ON vc.content_id=n.nid LEFT JOIN term_node t ON n.nid = t.nid WHERE ( 1=1 ) AND ( 1=1 AND vc.content_type='node' AND vc.value_type='points' AND vc.tag='vote' AND vc.function = 'sum' AND n.type='drigg' AND n.created > UNIX_TIMESTAMP(CURRENT_TIMESTAMP()) - 60*60*48 AND t.tid= AND n.status = 1 AND n.promote=0 ) ORDER BY vc.value DESC LIMIT 5 in /home/onlinega/public_html/includes/database.mysql.inc on line 172.

I have such problem. How i can solve it?

clemens.tolboom’s picture

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

This has nothing to do with annotate right?

I would try to run the query directly on the database with ie phpmyadmin and then try to fix it first. Then maybe file a bug @ votingapi module?