customer but no order error

[doon1947]

Hi,

 

Using 2.2ms2

 

Website works just fine. However I have problem under the following conditions:

 

1) New customer has items in the shopping cart

2) They create an account.

3) They do not complete the payment process at Paypal or the Paypal payment process fails.

 

Now when the store owner logs in to the Admin area

Selects "Customers"

Highlights "the customer we are talking about"

Then clicks "Orders"

We get the following:

 

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 '-100, 100' at line 1

 

select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.customers_id = '15' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -100, 100

 

When I examine the underlying databases there are no orders for customer_id = 15

Therefore the error message above is indeed correct but it freaks out the store owner and he complains to me about lost orders.

 

Is there some way to modify /Admin/orders.php to produce a better response such as "There are no orders for this customer"

 

Thanks,

Al Moodie.