You went to sql updates and tried to issue a statement to delete a customer, but for some reason you pasted in a bit of the URL you were using admin/sqlpatch.php and so the SQL didn't go through and displayed an error message. You should have used this:
Code:
select o.orders_id, o.date_purchased, o.order_total, o.currency, o.currency_value, cgc.amount from orders o left join coupon_gv_customer cgc on o.customers_id = cgc.customer_id where customers_id='7' order by date_purchased desc
although where you got the SQL and what you were attempting to do is not mentioned and I don't know if Zen has a delete customer option, I would have though that that woule be a bad idea in case accidentally hit. The above should do whatever you were trying to do, and is not anything to do with a security patch, just a cut and pasting error.
Bookmarks