Problem with order confirmation

[OffRoad1]

I receive payments but I do not receive an order process email and the order doesn?t show up in the catalog manager. This has never happened before just this weekend. If someone could help or is seeing this to in there site let me know how to fix it. Thanks

[spikez202]

I receive payments but I do not receive an order process email and the order doesn?t show up in the catalog manager. This has never happened before just this weekend. If someone could help or is seeing this to in there site let me know how to fix it. Thanks

<{POST_SNAPBACK}>

 

 

I get the same error. Then when I look at the orders for the customer, I get this error:

 

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 '-20, 20' 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 = '7' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -20, 20

 

[TEP STOP]

[♥Vger]

If this is happening with Pay Pal payments then you are probably using the standard Pay Pal module without having elected the Auto-Return feature in your Pay Pal account. If you don't sign up for this feature then you are totally reliant on customers hitting the Continue button at the end of the payment procedure to return them to your site. If they don't do that then no order gets returned to you and no e-mails get sent out.

 

Vger

[♥Vger]

Read the 1064 error link below my name.

 

Vger

I get the same error. Then when I look at the orders for the customer, I get this error:

 

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 '-20, 20' 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 = '7' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by orders_id DESC limit -20, 20

 

[TEP STOP]

<{POST_SNAPBACK}>

[spikez202]

Read the 1064 error link below my name.

 

Vger

<{POST_SNAPBACK}>

 

Thanks,

 

In regards to the Paypal observation, the problem happened with 2checkout, but I suppose it's the same idea.

[OffRoad1]

Thanks for all your help! I turned force cookie use to false in sessions and now it seems to work. Seems kinda weird that changing that would solve this, but im glad it works now. Thanks everyone!