MySQL error

[codeman43]

Hello,

It seems I have another issue. I sometimes can make orders. At first I was having this issue; Query Failed: INSERT INTO Orders. But some how it went away for now.

In testing the cart, I deleted the cookies so I could create a new order just like I was a new customer. The cart worked just fine up into I received the following message after the 2checkout.com processed the order and I was looking at the thank you page.

MySQL error: 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 '' at line 1
Query was: SELECT record_number FROM Orders WHERE Order_Number =

Any ideas?

Thanks

[codeman43]

Hello,

Is there anyone who can help me with this? :(

Along with the other problem I posted I'm still having from September because of this upgrade to 1.5.3. I have this additional problem.

After eyeing the league all of the zeros that he located in the order manager. I tried to complete an order and the following error is returned on the thank you for your order page after I returned from 2checkout.com.

Please print this page for your records.

MySQL error: 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 '' at line 1
Query was: SELECT record_number FROM Orders WHERE Order_Number =

If after I receive the above error and I tried to place another order, I receive the message I already posted for, http://www.ldev.com/forums/showthread.php?t=1257

I have to then go into the auto manager and delete the order with the "0000-00-00 00:00:00". This is very similar to the problem I had in September, the only in addition is this MySQL error.

Please, I would really appreciate some help here.

Thanks.

[Jamie]

Hi,

I don't believe these are 2 separate problems. Let's use your other post for this. If the error in this one still happens after the other one is resolved we can come back to this. I'm about 99.99 % sure that it won't. :squirrel:

[codeman43]

Okay, cool... :squirrel: