VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: speedwolf on February 22, 2012, 13:32:01 PM

Title: Problems with Default Products Theme @ the Frontpage
Post by: speedwolf on February 22, 2012, 13:32:01 PM
Hello,

when i use the default_products page on the Frontpage and enable the Top 10 Products or the new Products features nothing is showing up.
The Debug Output says:

QuoteYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC LIMIT 0, 5' at line 1 SQL=SELECT  * FROM `jos_virtuemart_products_de_de` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) ASC LIMIT 0, 5

Where is the Problem? The Feature works in the Module Feature very well, but not on the Shop Frontpage.

Greetings
Title: Re: Problems with Default Products Theme @ the Frontpage
Post by: speedwolf on February 27, 2012, 12:03:45 PM
Ommmg... the same Problem in Version 2.0.2 !!!

I downgrade to version 2.0 and all is Perfect, but in the Versions of

2.0.2
com_virtuemart.2.0.2
2.0.1
com_virtuemart.2.0.1.h
com_virtuemart.2.0.1.K
com_virtuemart.2.0.1.N

there is the Bug with showing the Top Ten and the last added Product on the Frontend, but the featured Product is showing.

Why??? Has anyone the same Problem ???

greetings