lost ipn transactions..not updating..live site...help

[battleaxe]

Hi
Not sure whether this is the right place michael, move this if necessary. I have had ipn 2.3 installed for a long while. It has been working great apart from the fact that it never updated from paypal processing.
Now I have added the nochex apc mod, which is easy and great (it is based on the ipn mod)! However, it seems to have disabled the updating of transactions, so I never get a transaction from either nochex or paypal in the admin side.

I get an email when a custome purchases from nochex or paypal, but the order status is stuck on processing on both mods.

There is no transaction in the admin side, so for every order i have to look at paypal and/or Nochex to make sure the customer has paid.

This is a live store, and getting pretty busy, so any quick and or dirty fix would be appreciated.

Kind regards
Kim

[michael_s]

I never understand why folks put untested mods in a live shop. Save yourself some headaches and set up a test shop that you can do debugging on. I am always amazed at the chances people take with their businesses.

My quick and dirty recommendation is to uninstall nochex, since that broke your shop. Then, set up a test shop to debug it, so it does not affect your business. A little planning can go a long way.

Have you ever noticed that you never see me posting here about how I am desperate to fix my store because I broke it? It is not because I never break my code, but because I never break my live store code...

Sorry about the soapbox lecture, but the 'Help, Live shop down' problem is easily avoided. You can then take your time to fix the issue correctly and make changes without a 900 LB gorilla on your back. If you break a test shop, no biggie.

[makemethis]

Recently, I had played on my site and added some stuff in the order status id area. I had an order that seemed to be lost. I looked in mysql files and found the order. The order status id was set at the old value. It reminded me to go to admin area...localization...order status and to reset the order status value for PayPal and the other feature I am using...

Possibilty...might check it...maybe it will help

[makemethis]

Just a note...I bet your order status id default is set to processing and that is what PayPal and nochex is set to

[battleaxe]

Hi makemethis,

thanks for the constructive help.....the default order status is set to pending, IPN is set to default (one assumes pending) and Nochex is set to pending also, is there a problem with that? Do they need to be different? My best guess is still that I have accidentally overwritten something on one of the files (it cant be that bad because the site is not really broken), but need to know which php files deal with the automatic updating of status and listing of transactions taken from paypal and nochex.

Hi Michael

Thanks for the soapbox (at least you didnt bring your megaphone!) advice. I have taken your advice and begun to set up my site on another (test) server. Having a leetle problem getting the transferred database up and running though..this is why I have shied away from doing it before, it always seemed it would take longer to set up a mirror test site than it would be to sort out the odd glitch, especially for Nochex as it is such a simple mod. Still working on it though.

Also I have lost so much business from frustrated people not being able to use paypal, that even over the last couple of days I estimate to have saved about seven potential abandoned carts, because they can now use Nochex - for this reason alone, I am hesitant about removing Nochex and would be really grateful if anyone has either experienced this, or is clever enought to work out whatever stupidity I seem to have committed.

Cheers
Kim

[michael_s]

Hi, getting the databse setup should be no biggie. You can do a couple of things. If you have root access to the server, create a new database and just copy all the table data from your original databse direcrtory to the new directory. Instant copy. Takes about a minute to do. Then just edit the configure_php files in your new shop to connect to the new database.

If you are using CPANEL, make a full backup of the original db to your computer. Then, create a new database using CPANEL. Then change the name of the backup you made to match the new database name. Then restore the backup through CPANEL, and it will automatically restore all the data to the new database.

If you are using phpmyadmin, export the structure and data to a batch .sql file using the export page in phpmyadmin. Then create your new database however you lilke, and then use the sql tab to run the batch file on your new database.

Each method is pretty easy. The first is fastest, followed by second and third. None are difficult to do, though.

[makemethis]

go into the data base and look and see if the orders that are missing are in there....look to see what the order_status_id is set to on these missing orders...
this will tell you what value nochex and paypal are sending when they come back to the site
if it is a value that no longer exists in order status, then the order will not appear and will seem to be lost however it is still in the mysql database...you just won't see it from admin
my suggestion...create nochex processing and paypal processing in admin under order status...then set nochex to nochex processing and paypal to paypal processing...
to get missing orders...then go into mysql database and edit missing orders and change the order_status_id to match the number of the right status you want...

hope that helps

[battleaxe]

Thanks makemethis. I have had a look in the database and paypal is set to 99999 as it should be and nochex 50000 as it should be.. (sorry about delay, went to Disneyland Paris with my 9 year old for his birthday).

I think I need to reinstall. Do you know if reinstalling the 2.3 ipn will knock out the order history that exists in the database. If it does, is there any way to avoid this?

[makemethis]

In the table ORDERS, all the recent orders have correct ORDER_STATUS?
Just want to make sure you were not looking at order_status in the config area...

Back up the data only from the table...DO NOT add structure or drop table features...just get the data in a sql file...

If the reinstall drops the info, you can then reload the data.

Pay attention to the old table structure and the new table structure...
if the new table has a different structure, you might have to adjust the sql file before loading...

[makemethis]

one other thought...

PayPal uses a return url...should be set to
https://www.yourwebdomain.com/checkout_process.php

I am not sure about nochex but I would think it would need a similar thing...

Sometimes people don't know and use
https://www.yourwebdomain.com/checkout_success.php
and that won't process the order but will give the customer an okay that their order is okay...

you might check this out to