Intermittent PayPal problem. Confirmation email and order details often absent.

[breezie1977]

OK, here's the logs for a test transaction I put through fine shortly after the logs that I posted previously didn't go through as they should.

The transactions which don't go through have only two files, the ones which do have three.

Here's the answers to the questions too:

Using Zen1.3.9h. Upgraded from 1.3.8 but had issues during the upgrade so wiped everything off and did a fresh install of 1.3.9h. Connected to the previous database and all seemed ok.

The reason I upgraded was because I was having trouble getting paypal to recognise Japanese characters on their website. If a customer went through checkout and then tried to pay on paypal (IPN) via credit card their information was auto-filled on the paypal form but came out as nonsensical characters... all apart from one field!! Very strange, contacted paypal, and they told me to change the settings on their site so that they see my site as a Japanese language site, no joy. Changed the settings in PayPal so they read my site as UTF8, no joy. Searched many places and ended up changing the collation of the database to UTF_general. Still no joy. Changed the collation again to UTF_unicode and all relevant individual structures and fields to UTF_unicode too. Still no joy. Gave up thinking that it was just something I'd have to live with... then the sales stopped going through properly and I did this a lot:

As for AddOns, I have the following installed :

WOZ (wordpress for Zencart)
stock by attributes
Image Handler 3
Fual Slimbox v0.1.5
Ship2pay 1.5.1
time zone offset v1.3.9d (which sometimes throws up errors and automatically changes the time zone to 3 hours out of sync with Japan - where my store is based)

Site is hosted by JustHost and was all working fine before the fresh install, database alterations and small changes to PayPal settings. I'd like to reset everything in the database back to latin1 (it all worked then) but am unsure of how much damage I'll do to the database itself by doing this and also if this would solve the issue. I've seen some posts Dr Byte has commented on where he never advises this action as it can corrupt the data. I read that post after making the changes and did this again:

Thanks for any help in advance, I've got a magazine article going out to a possible 500,000 people on March 30th and if this isn't sorted by then, I'm in deep .

Cheers,

Tony