BIG PROBLEM WITH VM3018

[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. 

[GJC Web Design]

WHERE 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?

[garces0209]

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