SQL syntax error on virtuemart default page.

[vasiljevski]

Joomla! 1.5.22
VirtueMart SVN revision 5642

Getting this when debug is on:

Code Select Expand

vmdebug self::$_jpConfig->lang sr_yu
vmdebug vmTime: loadConfig db no: 0.0092549324035645
vmdebug Start used Ram 6.5M
vmdebug exeSortSearchListQuery error in class VirtueMartModelProduct sql: Var1:

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 'ASC LIMIT 0, 3' at line 1 SQL=SELECT  * FROM `jos_virtuemart_products_sr_yu` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) ASC LIMIT 0, 3

vmdebug exeSortSearchListQuery error in class VirtueMartModelProduct sql: Var1:

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 'ASC LIMIT 0, 3' at line 1 SQL=SELECT  * FROM `jos_virtuemart_products_sr_yu` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) ASC LIMIT 0, 3

vmdebug vmTime: VirtuemartControllerVirtuemart Finished task : 0.28944301605225
vmdebug End used Ram 13.25M
vmdebug Peak memory peak 13.25M
vmdebug exeSortSearchListQuery error in class VirtueMartModelProduct sql: Var1:

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 'ASC LIMIT 0, 1' at line 1 SQL=SELECT  * FROM `jos_virtuemart_products_sr_yu` as l JOIN `jos_virtuemart_products` AS p using (`virtuemart_product_id`) ASC LIMIT 0, 1

I understand that the problem is that missing part is : ORDER BY  `virtuemart_product_id` ASC LIMIT 0,1
And I cannot find what file should I fix this in.

Does anyone know what can be the problem here? Might it be that my overides caused this problem?

I just want to list Feature, Top 10 and Latest product on my entry page.

[Milbo]

No, is not your template override, I fix it. Will be in the C version soon.

[TarGG58]

and when will the C version come?

[Milbo]

today, is there

[DrEddison]

Hello!

I've got the same problem. I load the VM today. What is a C Version an where can I find it?

Thanks a lot!

[Milbo]

It is now the I version, and we are goint to upload J version today, so wait a bit for the j version and look here http://forum.virtuemart.net/index.php?board=136.0