Author Topic: SQL syntax error on virtuemart default page.  (Read 3703 times)

vasiljevski

  • Beginner
  • *
  • Posts: 15
SQL syntax error on virtuemart default page.
« 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.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9997
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: SQL syntax error on virtuemart default page.
« Reply #1 on: March 09, 2012, 13:43:39 pm »
No, is not your template override, I fix it. Will be in the C version soon.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

TarGG58

  • Beginner
  • *
  • Posts: 9
Re: SQL syntax error on virtuemart default page.
« Reply #2 on: March 14, 2012, 11:49:00 am »
and when will the C version come?

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9997
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: SQL syntax error on virtuemart default page.
« Reply #3 on: March 14, 2012, 19:37:46 pm »
today, is there
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

DrEddison

  • Beginner
  • *
  • Posts: 1
Re: SQL syntax error on virtuemart default page.
« Reply #4 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!

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9997
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: SQL syntax error on virtuemart default page.
« Reply #5 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
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/