News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

You have an error in your SQL syntax 1064

Started by QQ, August 15, 2017, 23:57:17 PM

Previous topic - Next topic

QQ

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


QQ

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 :)

QQ

Egain show up if I edit product, same error any clue what could be wrong?

QQ

#3
I didn't choose language for product and category. Could this be a cause of this problem?

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/

QQ

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.

QQ

After installing com_virtuemart.3.2.3.9624_extract_first.zip everything works fine.