Error 1064 when setting GeoMaps module position

[Chris Zecca]

Hello,

 

I purchased your great product some days ago, thank you  :) I'm a newbie to Joomla and I have no knowledge of code and realted issues. I was trying to set up my site in local using EasyPHP and when I tried to "explore" the GeoMaps module, I first set up a position for it and took a look at the preview for my page and saw it said there was no content to display or something like that (no module title was displayed even if I set the option to do so, the rest of the page was ok), then I added some latitude and longitude info to see if the map appeared, I looked at my page again and got a blank page showing the following error:

 

Error 1064

(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 Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:0' at line 41 SQL=SELECT Listing.id AS `Listing.listing_id`, Listing.title AS `Listing.title`, Listing.alias AS `Listing.slug`, Listing.state AS `Listing.state`, Listing.publish_down AS `Listing.publish_down`, Listing.publish_up AS `Listing.publish_up`, 'com_content' AS `Listing.extension`, Category.id AS `Listing.cat_id`, Category.alias AS `Category.slug`, JreviewsCategory.criteriaid AS `Criteria.criteria_id`, JreviewsCategory.dirid AS `Directory.dir_id`, JreviewsCategory.marker_icon AS `Geomaps.icon`, Field.featured AS `Listing.featured`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Field. `Geomaps.lat`, Field. `Geomaps.lon`, ListingType.state AS `Criteria.state`, ListingType.config AS `ListingType.config`, Totals.media_count AS `Listing.media_count`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count` FROM l496q_content AS Listing LEFT JOIN l496q_categories AS Category ON Listing.catid = Category.id LEFT JOIN l496q_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN l496q_jreviews_content AS `Field` ON Field.contentid = Listing.id INNER JOIN l496q_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN l496q_jreviews_criteria AS ListingType ON JreviewsCategory.criteriaid = ListingType.id LEFT JOIN l496q_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id WHERE 1 = 1 AND ( Field. <> '' AND Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2013-11-17 23:59:59" ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2013-11-17" ) AND Category.access IN (1,5) AND Listing.access IN (1,5) ) LIMIT 5000)

 

I tried to change the module position but the error is still there, so I didn't select any position and the error was gone, and of course it was gone when I suspended the module. I published it again and tried different positions but the error is still the same. I tried to uninstall and install the module back, no luck.

 

Can you please help me, taking into consideration you have to be so kind to tell me what I can do step by step to solve the issue as I don't understand things when they get too technical? Thank you very much.

 

Chris

[Alejandro]

This section is only visible with a valid subscription. If you have a valid subscription, please login.

[Chris Zecca]

This section is only visible with a valid subscription. If you have a valid subscription, please login.

[Chris Zecca]

This section is only visible with a valid subscription. If you have a valid subscription, please login.