JL Sitemap error on Virtuemart

More
2 weeks 2 days ago #7927 by Margaret
Joomla! 3.9.3
VirtueMart 3.4.2

Generate sitemap works fine with plugins disabled

When you enable JLSitemap - VirtueMart and generate - you get this 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 'as product_name_ FROM `#__virtuemart_products` AS `p` LEFT JOIN `#__virtue' at line 1

Please could you advise

Thanks

Please Log in or Create an account to join the conversation.

© 2010-2019 JoomLine
The Joomla!® name is used under a limited license from Open Source Matters in the United States and other countries. joomline.net is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.

email: This email address is being protected from spambots. You need JavaScript enabled to view it.