Error 1064 - Category View

[jeffhoneyager]

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

[jeffhoneyager]

Anyone else have this problem and a possible fix?

[GJC Web Design]

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

[jeffhoneyager]

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.

[GJC Web Design]

SQL=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?

[jeffhoneyager]

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!

[GJC Web Design]

plus NO 3rd party SEO exts are needed by J3/VM3...