News:

Looking for documentation? Take a look on our wiki

Main Menu

SQL syntax error on virtuemart default page.

Started by vasiljevski, March 09, 2012, 13:06:45 PM

Previous topic - Next topic

vasiljevski

Joomla! 1.5.22
VirtueMart SVN revision 5642

Getting this when debug is on:
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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

TarGG58


Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/