HELP! All Orders Get Stuck

[Pammydee]

I am running a digital scrapbooking site so I am selling files (zipped). After payment through paypal customers are supposed to be redirected back to their account page where they can access download links to the files they just bought...

The problem is that after someone is taken back to their order to get their download links are not there. They are getting stuck in the database and the store isn't releasing the links until I go in and tell it to using the view stuck orders menu. This has been happening to 1 in every 6-7 orders since I set up my site 3 months ago but since yesteryday it is happening to EVERY single paid order.

This is my site
www.peppermintcreative.com


If ANYONE can offer some insight it would be greatly appreciated.

[Ajeh]

What version of Zen Cart are you running?

unix or windows server?

What version php?

What version MySQL?

[Pammydee]

What version of Zen Cart are you running? 1.2.7 - database patch level 1.2.7

unix or windows server? unix

What version php? 4.4.2 (Zend: 1.3.0)

What version MySQL? MySQL 4.0.27-standard

[24#Karat_fan]

what changes have you made?
what change has your host made?

[Pammydee]

Do you mean upon installation or in the last 2 days. All day yesterday orders were getting stuck - at about 4am my site went dead and all I got was an error messsage when I went to the URL. I contacted my host and they said that mySQL had died (no idea what that means) and then they said they fixed it and the site was back up...however orders are still all stuck...

Plus this was happening (although less frequently) since day one....

I contacted other site owners using zen cart who are also running site very similar to mine (selling same types of files etc) and they have no experience with this problem. It makes me think I did somehting wrong at set up?

[24#Karat_fan]

one of the issues is paypal sends the ipn ONCE. if there is an oopps anywhere in the connection you dont get it.

Sounds like there was a server issue yesterday
try going into paypal.com and refunding 1 penny on an order and see if that dosnt fix it

[Pammydee]

I understand what you mean by the oops factor. I refunded someone's purchase - the entire purchase but the next 3 orders still got stuck. Perhaps I misunderstood what you meant? Otherwise, it didn't work.

AGH!

[24#Karat_fan]

by refunding 1 cent of the order you can trigger the IPN to respond

[Pammydee]

Alright I tried it, I refunded a penny - no dice. The order stayed stuck.

[24#Karat_fan]

manually navigate to your ipn page see what you get