I get:
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 '' at line 1 SQL=SELECT cat.description FROM xxxxx_categories cat WHERE cat.id=
On the VM Front Page when selecting a category
Also when creating a menu link to a specific category
...and in a number of other places (e.g. add to cart >>> continue shopping)
MySQLi - 5.6.27
php - 5.5.17
Joomla - Joomla! 3.4.6 Stable
V.M. - 3.0.12
Anyone else have this problem and a possible fix?
well
1. this is a Joomla query.. not VM
2. SELECT cat.description FROM xxxxx_categories cat WHERE cat.id=2 is a valid query (assuming you replaced the xxxxx and there is an id number)
u need to find what is generating this query.. module , plugin etc if the id number is missing
This error occurs when I created a menu item "shop"
With Menu Type = VirtueMart >> Font page
Then going to the menu item (on front end), I get the VM front page with the categories displayed, then the featured items. When clicking on a category, I get the error.
The menu item results in: index.php?option=com_virtuemart&view=virtuemart&productsublayout=0
I also created a VM menu item (category layout)
index.php?option=com_virtuemart&view=category&virtuemart_category_id=14&virtuemart_manufacturer_id=2&categorylayout=categories&showcategory=1&showproducts=1&productsublayout=0
This also gave me the same error.
There is no module or plugin that has been used. I would expect it would be VM that takes it from there - and therefore a VM problem.
After installing VM and the sample content / products, I'd expect the basics to work...
What am I missing?
Thanks for your help.
QuoteSQL=SELECT cat.description FROM xxxxx_categories cat WHERE cat.id=
there is no such query in VM.. why would VM be querying a Joomla cat desc?
std template etc?
investigated with debug and query stack to see where the query comes from?
GJC Web Design - Great Suggestion - Found/Fixed the problem
After enabling debug - Development it showed a problem with a plugin: SEOSimple Dao By Design
I disabled it and all is well.
Thanks All!
plus NO 3rd party SEO exts are needed by J3/VM3...