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

BIG PROBLEM WITH VM3018

Started by garces0209, November 22, 2016, 00:54:02 AM

Previous topic - Next topic

garces0209

Hi, when i change the status of order, virtuemart says: 1064 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 ') AND created_on BETWEEN '2016-11-21 00:00:00' AND '2016-11-21 23:59:59'' at line 1 SQL=SELECT SUM(order_total) as total, order_currency FROM elect3_virtuemart_orders WHERE order_status IN () AND created_on BETWEEN '2016-11-21 00:00:00' AND '2016-11-21 23:59:59'

and virtuermart dont send a email to my costumer with the change of status of order.

please help me!
thanks

mcmannehan2002

First you should read this:

https://forum.virtuemart.net/index.php?topic=79799.0

With this information help is possible.  8)

GJC Web Design

QuoteWHERE order_status IN ()

the order status is missing

should be e.g.  WHERE order_status IN ('C','P')

have you changed or deleted core status values etc?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

garces0209

i havent change or deleted any status...
please help me