Hello.
I got this problem on my website, when I try to view any product:
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 'DESC FROM `#__virtuemart_products` as p LEFT JOIN `#__virtuemart_products_en_gb`' at line 1
Was trying:
Optimise database - Msg Database updated
Install or if necessary update tables - Msg Database updated
I am using Joomla! 3.7.4 Stable [ Amani ] 25-July-2017 11:11 GMT
VirtueMart version 3.2.2
Database MySql Version 5.6.10
PHP Version 7.0.21
Web Server nginx/1.12.1
WebServer to PHP Interface fpm-fcgi
After a night of sleep, I turn on my pc test website and it works fine. I didn't change anything, hope it won repeat :)
Egain show up if I edit product, same error any clue what could be wrong?
I didn't choose language for product and category. Could this be a cause of this problem?
Did you try with http://dev.virtuemart.net/attachments/download/1087/com_virtuemart.3.2.3.9624_extract_first.zip ?
Quote from: Milbo on August 18, 2017, 19:26:12 PM
Did you try with http://dev.virtuemart.net/attachments/download/1087/com_virtuemart.3.2.3.9624_extract_first.zip ?
I did choose language and still got the same error.
When I installed com_virtuemart.3.2.3.9624_extract_first.zip error gone will test more.
After installing com_virtuemart.3.2.3.9624_extract_first.zip everything works fine.