Print Page - BIG PROBLEM WITH VM3018

Title: BIG PROBLEM WITH VM3018
Post by: garces0209 on November 22, 2016, 00:54:02 AM

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

Title: Re: BIG PROBLEM WITH VM3018
Post by: mcmannehan2002 on November 22, 2016, 08:48:49 AM

First you should read this:

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

With this information help is possible. 8)

Title: Re: BIG PROBLEM WITH VM3018
Post by: GJC Web Design on November 22, 2016, 10:19:43 AM

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?

Title: Re: BIG PROBLEM WITH VM3018
Post by: garces0209 on November 22, 2016, 21:30:51 PM

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

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: garces0209 on November 22, 2016, 00:54:02 AM