GeoBrowser does not show category tree.

Some errors I am getting in Firefox error console:

"Error: syntax error
Source File: http://waldirlieb.villageonline.com.br/?q=geobrowser_xml_controller&func...
Line: 2, Column: 3
Source Code:
Query failed: --^"

and also,

"Error: syntax error
Source File: http://waldirlieb.villageonline.com.br/?q=geobrowser
Line: 2, Column: 3
Source Code:
Query failed: --^"

I am also getting mysql error:
"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 ') GROUP BY nid ) AS Temp0 ON waldirlieb_node.nid = Temp0.nid ' at line 12 query: SELECT waldirlieb_location.latitude AS geobrowser_lat, waldirlieb_location.longitude AS geobrowser_lon, waldirlieb_location.eid AS geobrowser_vid, waldirlieb_node.nid AS geobrowser_nid, tid0 as term_node_tid, waldirlieb_node.title AS node_revisions_title, waldirlieb_votingapi_vote.value IS NULL AS isnull FROM waldirlieb_location INNER JOIN waldirlieb_node ON waldirlieb_node.vid = waldirlieb_location.eid INNER JOIN (SELECT nid, tid as tid0 from waldirlieb_term_node WHERE waldirlieb_term_node.tid IN () GROUP BY nid ) AS Temp0 ON waldirlieb_node.nid = Temp0.nid LEFT JOIN waldirlieb_votingapi_vote ON waldirlieb_node.nid = waldirlieb_votingapi_vote.content_id WHERE waldirlieb_location.longitude < -43.07292938232422 AND waldirlieb_location.longitude > -43.291282653808594 AND waldirlieb_location.latitude < -22.85545468986725 AND waldirlieb_location.latitude > -22.95017375097801 ORDER BY isnull ASC, waldirlieb_votingapi_vote.value ASC LIMIT 0, 30 in /home/restricted/home/villageonline1/public_html/waldirlieb/includes/database.mysql.inc on line 172"
which I think comes from "function geobrowser_xml_controller".
Any ideas? Thks.

A quick read of readme file should help, but-

A quick look at the mysql error you are receiving tells me that you have not added any categories; you must have the modules listed installed namely location, taxonomy image, taxonomy, and fivestar. Make sure that those modules are enabled, then add 1 category(taxonomy)

eg: crime

then you need to add the terms to the category,

eg: Robbery, Car theft, Assault.....

Now you can either create a new content type or modify your page type, you want to make sure that you have locatative information enabled for that content type.

eg: Using "Page" as a basis point, you would want to expand the "locative" information on the Page Type Edit page.

In that you will select "Maximum number of locations for this content type:" set it to 1- this will turn on the locative data for the content type.

Next Set the default to 1. That should do it for the minimum setting.

Now add some content under page and associate it with the category/term and select the location on the map.
Check your settings on Admin/Site Configuration/Geobrowser and set the geobrowser Vocab Id to the category ID of Crime (if first category added- should be 1)

If I have repeated tasks that you have already done, I apologize, I trust that some of this assists you.

Simon.

Thanks for the tips. Unfortunately I have done all these things already. Maybe uninstalling the modules, getting new versions, install again may correct. I have checked all the help, the readme.txt and seems to be configured fine, but... Thanks anyway.

Hrm.

I wish I had more advice for you..

If you *do* find what's wrong - could you please post a bug report?

Try downloading the latest version - some of the core sql code has been rewritten

P

I'm setting this to closed. If you download the latest version and are still having a problem, feel free to re-open this thread.