Occasional orders not going into the database

[colonel_t]

I'm having an issue after transferring servers. (Linux to Windows, if that makes any difference)

When orders are completed, the order confirmation is sent successfully, but the secondary email with the missing credit card numbers is not. Worse, the order is not entered into the database. The order numbers seemed to reset as well.

Any ideas?


Zen: 1.3.7

I've also got an issue with the per item module appearing when it shouldn't, but I'll post that in the appropriate forum.

[econcepts]

There are a number off differences in Linux vs. Win servers.

1) For email, you need to make sure that the "old method" you used on the Linux server (probably "sendmail" -- the default with Zen) is indeed installed on that win server and you can access it.

More than likely, the email issue could be the fact that you need to alter the program that you are using (from within the Admin) "Configuration > Email Options" and set that to the proper info yoru new Win server requires.

It may require you to set the Email Transport Method to something different than your previous server.

It may also require you to enter settings for the fields near the bottom of that same section which look like this:
SMTP Email Account Mailbox YourEmailAccountNameHere Info
SMTP Email Account Password YourPasswordHere Info
SMTP Email Mail Host mail.EnterYourDomain.com Info
SMTP Email Mail Server Port 25

2) Make sure all your directory permissions are correctly set on your new server. Setting directory permissions under Windows is different than Linux.


3) For the database issues, I am not sure if you had to move that as well. If so, make sure you moved everything from your old DB to the new one. Also, what payment gateway are you using? Is it one that requires you to set the Return URL (PayPal) and if so, did you set it properly (assuming you had not originally pointed to the "domain name" -- rather than IP etc..).

Just some thoughts to go over while you are checking it all out.

Good luck!

[stevensmedia]

I'm having a similar issue... SOME orders don't make it into the database. Most do, but not all. All orders are successfully processed by Authorize.net. ZC version 1.3.7. Any ideas?

[stevensmedia]

A few more details... I have ot_total enabled. If I search for an order number, I will find it, but the order is a NEW order from a different customer. For example, order #256 from customer Joe Brown comes to me via email, but doesn't show up in ZC admin. I can search for and find order #256, but the order number is simply being re-assigned to a different order--nowhere can I find Joe Brown's order in ZC admin.

The last two times this happened, the missing orders were sent to Authorize.net multiple times, like Joe had perhaps clicked the Confirm Order button multiple times. All the orders show up in Authorize, none of them show up in ZC. I'm trying to determine if this is a characteristic of ALL missing orders or just these last two.

One of the possible causes of this problem that's occurred to me is a brief blip with PHP on the server. Occasionally with this web host, PHP goes down for about 1 second. Apparently, it's a bug in the Ensim control panel software. I haven't seen this happen on this particular website, but the problem is completely sporadic and so short that it's hard to nail it down. If PHP goes down for that 1 second right when Joe submits an order... I guess that would prevent it from being saved to the database... but then wouldn't the order NOT be passed to Authorize.net?

[DrByte]

What addons/contributions have you installed?
Have you installed and later removed any?
What customizations have you made to your site?

[stevensmedia]

What addons/contributions have you installed?

This site is pretty simple, just the Authorize.net payment module and the MySQL backup plugin.

Have you installed and later removed any?

About a week ago I upgraded the Authorize.net module, but this problem with occasional missing orders pre-dates that upgrade.

What customizations have you made to your site?

A custom template, but most changes are in the CSS file and images. The fact that this seems to be an intermittent problem suggests to me that the theme is probably not an issue.

[colonel_t]

Well it turns out I'm an idiot.

There was an old file that wasn't overwritten and had instructions for the wrong
database on the server. Bah.

[DrByte]

Thanks for confirming the nature of the problem.

Those old files can really bite nasty sometimes !!