Author Topic: sql problem. who can help?  (Read 192 times)

dking

  • Beginner
  • *
  • Posts: 2
  • A beginner
sql problem. who can help?
« on: July 05, 2017, 14:26:16 pm »
when I select a specific category I get the following error:  (partly in dutch)

Sorteren op
Gesorteerd artikelnaam Aflopende volgorde
Resultaten 1 - 1 van 1   
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ORDER BY product_available_date DESC LIMIT 0,' at line 1 SQL=SELECT virtuemart_product_id FROM #__virtuemart_products WHERE DATE(product_available_date) >= DATE_SUB(CURDATE(), INTERVAL DAY) ORDER BY product_available_date DESC LIMIT 0,

What seems to be the problem?

Products are shown well.


Usint joomla 3.6
virtuemart 3.2.2
php 5.6

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9327
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: sql problem. who can help?
« Reply #1 on: July 05, 2017, 21:12:52 pm »
That is some 3rd party software
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

dking

  • Beginner
  • *
  • Posts: 2
  • A beginner
Re: sql problem. who can help?
« Reply #2 on: July 05, 2017, 21:46:22 pm »
ok. thanks. already thought it is the template.

Thanks. Have been searching like crazy for a solutions. Let me see what to do.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9327
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: sql problem. who can help?
« Reply #3 on: July 12, 2017, 14:05:49 pm »
uhm, I doubt it is the template,

module or plugin, for example a "show products module"
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/