VirtueMart Forum

VirtueMart 2 + 3 => Virtuemart Development and bug reports => Topic started by: vasiljevski on March 09, 2012, 13:06:45 pm

Title: SQL syntax error on virtuemart default page.
Post by: vasiljevski on March 09, 2012, 13:06:45 pm
Joomla! 1.5.22
VirtueMart SVN revision 5642

Getting this when debug is on:
Code: [Select]
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.
Title: Re: SQL syntax error on virtuemart default page.
Post by: Milbo on March 09, 2012, 13:43:39 pm
No, is not your template override, I fix it. Will be in the C version soon.
Title: Re: SQL syntax error on virtuemart default page.
Post by: TarGG58 on March 14, 2012, 11:49:00 am
and when will the C version come?
Title: Re: SQL syntax error on virtuemart default page.
Post by: Milbo on March 14, 2012, 19:37:46 pm
today, is there
Title: Re: SQL syntax error on virtuemart default page.
Post by: DrEddison on April 04, 2012, 13:57:25 pm
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!
Title: Re: SQL syntax error on virtuemart default page.
Post by: Milbo on April 05, 2012, 12:41:30 pm
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