When calling Visitors Location Map with admin/reports/visitorinfo I am getting a red error message like that one ....

"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 'LEFT JOIN support_ticket st ON n.nid = st.nid WHERE (n.language ='en' OR n.langu' at line 1 query: SELECT DISTINCT * FROM visitorinfo order by csid desc LEFT JOIN support_ticket st ON n.nid = st.nid WHERE (n.language ='en' OR n.language ='' OR n.language IS NULL) AND ( (st.client IN (1) OR st.client IS NULL)) LIMIT 0, 200 in /home/yadayadayada/public_html/blablabla/sites/all/modules/visitorinfo/visitorinfo.module on line 109."

actually it somehow resembles what I described in
http://drupal.org/node/668042
already acouple of weeks ago in an earlier version of Visitor Info.
the patch i got from there worked but not sure if the same patch can be applied here now again ?

Comments

twooten’s picture

twooten commented

I just released a development snapshot - 6.x-1.x-dev which includes the patch. Thanks for testing.

browlands’s picture

browlands commented

Using latest dev. SQL error appears ...

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 'WHERE ((n.moderate != 1)) LIMIT 0, 200' at line 1 query: SELECT * FROM visitorinfo order by csid desc WHERE ((n.moderate != 1)) LIMIT 0, 200 in D:\XAMPP\xampp\htdocs\ecopal\modules\visitorinfo\visitorinfo.module on line 109.

twooten’s picture

twooten commented
Status: Active » Postponed (maintainer needs more info)

I just put out version 6.x-1.5. Can you tell me what version of MySQL you're running, is this a public site?

Tim

browlands’s picture

browlands commented

No, a test site. MySQL version 5.1.41.