order id problem

hi, hope someone can help me out, after i have changed the order id from 1 to 24468 using tools > store manager then i test my creditcard with a sample item that price 0.01, i tested 2 times, it works well, first time 24468 order id, then second time 24469 order id, i both got all the mail from my site and these order do write into my database, so i though i'm done in this part however

the problem happens , one buyer purchase my item through my site today, then my paypal got the payment, i see his address well in the paypal, but then i cannot see any order history in my site, so then i'm going to test payment again then i find out everytime after i check out i go to the paypal page and enter my creditcard number and then it prompt up the credit card number cannot be use (only the first time checkout it happens), but if i click back to merchant and check out again, the credit card number can use in paypal and make the payment, and why is it happen?

after make the payment, in the order confirmation page it shows to me that the order id is always 24469, that means it never increase by 1 anymore the order id, and of course there is no buy history now in my zencart~~

ok here is my orders table only 3 rows so far and i 've seen the orders_id here, the orders_id is set to be auto increment

orders_id customer_id .. .. ..
1 1
24468 1
24469 1

and order_products id
table

order_prodcuts_id orders_id
1 1
2 24468
3 24469

why the orders_id lost its increment value? is it a key that because it lost its increment value so it cannot log the history into my cart anymore? thx

and ok if i just do not care the order id and the previous test order history , how could i reset all of these back to normal ?? i do not want to import back my database again since i did add a lot of items previosuly, is that i can truncate the table orders and orders_products? it seems will have a problem if i manually truncate the database

and further more i'm now trying to use the reset order id to higher number from 24469 to something 32570, and i test with the payment again, i can pay with the creditcard, and the order no at the confirmation check out page is 32570, but then when i try another purchase again the problem still exist, the reset id yes can reset one time , but if i make 2 purchase later on the id number frozen and cannot increment , and i found out that the order id just overwrite the last row's order's id ! (previously i have 3 order that is order 1, order 2 and order 24469, and now become order 1, order 2 , and order 32570)

how to reset all these problem in fact? thank you it takes me so long time now

ok now i keep searching post and trying to recover the system, i just wanna reset all and delete all the orders history etc, i do search and i truncate all the table related to orders, and suppose that will work and then test to purchase through my store again, yes again i can pay with the paypal with my creditcard , but once i click back to merchant page, the success check out page show

your order number is :

you've got a blank order number after i truncate all the data in orders related table

and again no history in my zencart after payment, the payment is success, and it never write any data into the order related tables, any idea ? thx

ALL of your "problems" with order_id apparently not incrementing are related to a problem your server has with PayPal. It has nothing to do with your orders tables or auto_increment at all.

When you use the PayPal IPN / Website Payments Standard module to make payments, your server must wait for PayPal's server to contact your server to notify it of the payment. If anything goes wrong in that communication, you'll never see the order in your store.

See this article for troubleshooting steps to try to resolve the problems between your server and PayPal's server: http://www.zen-cart.com/wiki/index.php/PayPal

Also, switching to Express Checkout instead of Website Payments Standard/IPN will avoid the problems you mention.

hi dr. i did read all these carefully and i've been trying on this whole day, i'm using a godaddy host, i've turned the crul setting off, or even follow to add the false && for an alternative fix, it still cannot solve the problem

i don't have a business paypal a/c right now so is that godaddy cannot work with standard ipn?

What's showing in the PayPal log files since you enabled debugging?

i did use your suggest method to check my ipn , i downloaded the ipncheck 139 and upload to my site

here is the result

IPNCHECK.PHP - Version 1.3.9

IPN TESTING - Response Received via CURL -- COMMUNICATIONS OKAY

IPN TESTING - Confirmation/Validation response with fsockopen(): FSOCKOPEN() RESPONSE RECEIVED - Communications OKAY
Default method likely to be used for communications is: CURL, with the fallback method being FSOCKOPEN if possible.Script finished.

where to see my paypal log? i can see the ipn history log and all the ipn status is retrying that means nothing can pass back to my site

okay i searched your post again and in zencart payment turn debug mode to log file and i'm going to make a few try again to post back what i can see in my log file thx

Jun 04 2009 10:21 -- Keys for submission: Array
(
[charset] => iso-8859-1
[lc] => US
[page_style] => Primary
[custom] => zenid=po59dod3jrivrtruoi0vlcrup1
[business] => [email protected]
[return] => http://www.mysite.com/index.php?main_page=checkout_process&referer=paypal
[cancel_return] => http://www.mysite.com/index.php?main_page=checkout_payment
[shopping_url] => http://www.mysite.com/index.php?main_page=shopping_cart
[notify_url] => http://www.mysite.com/ipn_main_handler.php
[redirect_cmd] => _xclick
[rm] => 2
[bn] => zencart
[mrb] => R-6C7952342H795591R
[pal] => 9E82WJBKKGPLQ
[first_name] => my first name
[last_name] => my last name
[address1] => My address
[city] => United States
[state] => 0
[zip] => 001
[country] => US
[email] => myloginemail
[address2] => my address2
[H_PhoneNumber] => 12345678
[night_phone_b] => 12345678
[day_phone_b] => 12345678
[0] =>
[upload] => 1
[currency_code] => USD
[cmd] => _ext-enter
[item_name] => Your mysite.com Purchase
[item_number] => Store Receipt
[amount] => 0.01
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00
)
This is what i've seen in the log?? some of the personal data i've changed to something like mysite.com my address, the log seems no problem??

That's only the first part of the transaction ... ie: the part that is prepared BEFORE sending to Paypal ... it shows what got sent.
If you're not getting any other logs, then PayPal's server is not successfully reaching your server ... which is why you're never seeing anything more about the transactions.

hi i don't have any other thing for log, that means paypal have trouble try to communicate back to my godaddy host ? so any suggestion to find out and solve it for a new zenner?? :)

DrByte:

Also, switching to Express Checkout instead of Website Payments Standard/IPN will avoid the problems you mention.
Have you tried Express Checkout, as I suggested earlier?

i couldn't since i don't have a business paypal yet, is this is the only option though?

PayPal allows you to have 2 accounts: one personal, and one business/premier.
If you want to keep your personal one for personal things, that's fine. Your store will need a business account or a premier account.

yes i have a premier a/c however seems express checkout requires api that is something business account could have only, isnt it ?

Both Premier and Business accounts can handle Express Checkout transactions

ok before this i hire some programmer to solve the ipn basic, hope i can understand what he changed afterward if he done, if this cannot be done i'll try use express checkout instead to see what happen, thanks for replying dr.byte