hi, i deleted the old version also checked that the table is deleted and installed the beta2 version now...

the annotation showing and saving seems work, but on every site i get the following warning.


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), visibility, note FROM annotations WHERE nid = 459 AND 1=1' at line 1 query: SELECT uid, DISTINCT(n.nid), visibility, note FROM annotations WHERE nid = 459 AND 1=1 in /database.mysqli.inc on line 151.

greets

Lausch

Comments

Lausch’s picture

Lausch commented

addition

SORRY GUYS.

i cannot edit / view the annotation form

only error shown and no form

greets

Lausch

clemens.tolboom’s picture

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

Executing the query mentioned above in mysql client gives the same result.
BUT ... using beta2 on a drupal-5.2 fails to reproduce the error.

The code uses a db_rewrite_sql so i have to check for drupal-5.3 to make sure i cannot reproduce it.

What version of drupal are you using?

clemens.tolboom’s picture

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

I cannot reproduce this on a drupal-5.3 environment.

clemens.tolboom’s picture

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

In bug http://drupal.org/node/190452 the solution is to remove all words 'db_rewrite_sql' in annotate.module.

Can you please confirm this. I released beta3 now so others not running into this too ... hopefully.

Lausch’s picture

Lausch commented
Version: 5.x-1.0-beta2 » 5.x-1.0-beta3
Status: Active » Fixed

hi clemens

i use 5.3

i confirm that beta3 is working for drupal 5.3 now :-)

thank you very much

greets

Lausch

clemens.tolboom’s picture

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