Duplicate order ID - geomerchant gateway

[fxchain]

Hello All,

I have been having this "duplicate order ID" problem for a while. I have tried many things to fix it, but none succeeded.

Customers cannot check out because zen cart assigns them the same order id as the person that just checked out before. The payment gateway rejects duplicate order ids.

We run version 1.3.8a. The problem was happening on 1.3.6 too.

We have several mods installed:
Image handler
ultimate SEO URLs
Fedex
Goemerchant payment mod
Free Gifts - Dangling Carrot (problem happened before installing this mod.)

We run a cluster, 2 web servers are serving the html files.
1 DB server

We average about 120 orders a day.

We just did a marketing campaign and this problem occurs way more during high traffic.


Help! How/Where can I look at this problem?


Thanks for any help on this!

[DrByte]

The clustering can sometimes cause that sort of thing, as can a busy site.
You may have to search for and adapt the "external order number generator" mod that was posted on the forum some time ago.

Or update your custom payment module to add some random additional letters to the order number to enhance uniqueness during the transmission phase, since you're probably currently just guessing what the next order number will be, when in fact the "real" order number can't be duplicated anyway. (Basically I'm saying that the order number submitted to your gateway isn't entirely accurate anyway, so adding some unique random characters to it will make it unique and therefore bypass the error you're encountering.)

[fxchain]

Thanks for the reply. I will look into the cluster to try to see if it causes the problem.

I installed External Order Number Generator a while back, but I forgot I did, so I didn't mentioned in this post.

Adding a random number in the payment gateway order does not work. The BIG problem with this fix is that customers are able to check out, and there card is processed. But zen cart still hold the same order id for multiple orders and only records one order.

So we end up with people having their CC charged, but no info on their order in Zen cart.

To fix this, we need to be able to have zen cart create unique order IDs. I don't think we can do anything on the payment gateway.

[fxchain]

This a custom log of today alone (had to remove some because I exceeded the max char amount):

05/05/2009 01:56:58 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 34605 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Chrome/1.0.154.59 Safari/525.19$

05/05/2009 02:12:40 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91770 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)$

05/05/2009 02:13:15 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91770 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)$

05/05/2009 02:14:58 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91770 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)$

05/05/2009 04:47:30 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91772 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0)$

05/05/2009 04:50:26 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91772 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0)$

05/05/2009 05:05:07 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91772 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0)$

05/05/2009 05:06:29 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91772 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0)$

05/05/2009 05:08:48 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91773 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10$

05/05/2009 05:09:46 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91773 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10$

05/05/2009 05:11:05 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91773 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10$

05/05/2009 05:24:05 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91773 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10$

05/05/2009 06:03:11 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91774 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_6; en-us) AppleWebKit/525.27.1 (KHTML, like Gecko) Version/3.2.1 Safari/525.27.1$

05/05/2009 06:32:34 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 29910 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30618)$

05/05/2009 06:33:42 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 29910 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30618)$

05/05/2009 06:35:26 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 29910 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30618)$

05/05/2009 06:37:16 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 29910 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30618)$

05/05/2009 06:41:41 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 29910 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30618)$

05/05/2009 06:43:59 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 29910 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30618)$

05/05/2009 06:44:03 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 29910 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30618)$

05/05/2009 06:46:49 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 29910 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.5.30729; .NET CLR 3.0.30618)$

05/05/2009 06:54:36 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91775 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 07:05:30 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91777 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4; en-US; rv:1.9.0.6) Gecko/2009011912 Firefox/3.0.6$

05/05/2009 07:06:16 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91777 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.4; en-US; rv:1.9.0.6) Gecko/2009011912 Firefox/3.0.6$

05/05/2009 07:18:59 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91779 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 07:23:29 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91779 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 07:26:06 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91779 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 07:28:20 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 72073 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.28 (KHTML, like Gecko) Version/3.2.2 Safari/525.28.1$

05/05/2009 07:31:07 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91779 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 07:39:12 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91780 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)$

05/05/2009 07:41:29 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91780 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)$

05/05/2009 07:43:10 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91780 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)$

05/05/2009 07:51:51 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91780 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)$

05/05/2009 07:53:41 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91780 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)$

05/05/2009 08:49:43 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91784 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_6; en-us) AppleWebKit/525.27.1 (KHTML, like Gecko) Version/3.2.1 Safari/525.27.1$

05/05/2009 08:50:23 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91783 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6)$

05/05/2009 08:51:54 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91783 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6)$

05/05/2009 08:53:37 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91783 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6)$

05/05/2009 08:54:29 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91783 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6)$

05/05/2009 08:55:05 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91783 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6)$

05/05/2009 08:55:17 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91783 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6)$

05/05/2009 08:55:20 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91783 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6)$

05/05/2009 09:00:58 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91784 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_6; en-us) AppleWebKit/525.27.1 (KHTML, like Gecko) Version/3.2.1 Safari/525.27.1$

05/05/2009 09:06:14 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91654 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)$

05/05/2009 09:13:26 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 76099 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_5; en-us) AppleWebKit/525.26.2 (KHTML, like Gecko) Version/3.2 Safari/525.26.12$

05/05/2009 09:14:36 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 76099 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_5; en-us) AppleWebKit/525.26.2 (KHTML, like Gecko) Version/3.2 Safari/525.26.12$

05/05/2009 09:15:19 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 76099 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_5; en-us) AppleWebKit/525.26.2 (KHTML, like Gecko) Version/3.2 Safari/525.26.12$

05/05/2009 09:16:55 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 76099 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_5; en-us) AppleWebKit/525.26.2 (KHTML, like Gecko) Version/3.2 Safari/525.26.12$

05/05/2009 09:18:01 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 76099 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_5; en-us) AppleWebKit/525.26.2 (KHTML, like Gecko) Version/3.2 Safari/525.26.12$

05/05/2009 09:35:18 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91787 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)$

05/05/2009 09:36:04 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91787 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)$

05/05/2009 09:38:18 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91787 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)$

05/05/2009 09:52:17 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91788 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; Media Center PC 4.0; .NET CLR 2.0.50727; .NET CLR 1.1.4322)$

05/05/2009 10:02:52 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91772 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0)$

05/05/2009 10:03:44 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91772 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0)$

05/05/2009 10:07:45 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91772 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0)$

05/05/2009 10:08:23 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91772 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0)$

05/05/2009 10:12:22 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91772 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0)$

05/05/2009 10:16:04 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91772 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0)$

05/05/2009 10:20:15 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91791 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.4) Gecko/2008102920 (CK-MITLL) Firefox/3.0.4$

05/05/2009 10:22:06 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91791 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.4) Gecko/2008102920 (CK-MITLL) Firefox/3.0.4$

05/05/2009 10:23:59 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91772 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Media Center PC 5.0)$

05/05/2009 10:29:00 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 13678 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; WOW64; SLCC1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; InfoPath.2; .NET CLR 3.5.21022; MS-RTC LM 8; .NET CLR 3.5.30729; .NET CLR 3.0.30618)$

05/05/2009 10:30:09 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91791 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.4) Gecko/2008102920 (CK-MITLL) Firefox/3.0.4$

05/05/2009 10:35:06 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91793 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6)$

05/05/2009 10:36:50 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91793 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6)$

05/05/2009 10:42:51 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91795 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10$

05/05/2009 10:44:22 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91795 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10$

05/05/2009 10:48:39 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91797 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; InfoPath.2; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 10:49:37 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91797 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; InfoPath.2; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 11:03:48 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91797 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; InfoPath.2; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 11:04:20 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91797 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; InfoPath.2; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 11:07:13 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91800 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; AOL 9.1; AOLBuild 4334.34; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; Tablet PC 2.0)$

05/05/2009 11:11:58 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91797 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; InfoPath.2; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 11:12:14 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91797 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; InfoPath.2; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 11:13:13 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91797 - OrderID:64984 - Browser/OS: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8; InfoPath.2; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)$

05/05/2009 11:13:31 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91783 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.16) Gecko/20080702 Firefox/2.0.0.16$

05/05/2009 11:13:56 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91802 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)$

05/05/2009 11:15:07 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91802 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)$

05/05/2009 11:17:13 - error_message: The OrderID: oc64984 has already been used. The value must be unique. | - Customer ID: 91802 - OrderID:64984 - Browser/OS: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)$


ANY PROFESSIONAL HELP WELCOME!

[DrByte]

So, basically the logs are telling you that the gateway is rejecting all your orders because it's submitting the SAME order number over and over again. ie: 64984
80 of 80 entries in that log show the SAME order number.

Sounds like a bug in your payment module that's causing the SAME order number to be submitted for (what appears to be) EVERYONE.

[fxchain]

Here is the code from the payment gateway:

$new_order_id = zen_get_Order_ID(zen_session_id());   // JTD:01/25/06 

and in includes/functions/extra_functions/functions_orders_id.php

function zen_get_Order_ID($session_id) {
    global $db;

    // If there is already an orders_id associated with this session then return it
    if (isset($_SESSION['orders_id']))
        return $_SESSION['orders_id'];

    // otherwise return the first orders id that has no session associated
    $result = $db->Execute("select orders_id from " . TABLE_ORDERS_ID . " where session_id = '' limit 1");
    if ($result->RecordCount() != 0)
        {
        $db->Execute("update " . TABLE_ORDERS_ID . " set session_id = '" . $session_id . "' where orders_id = '" . $result->fields['orders_id'] . "'");
        $_SESSION['orders_id'] = $result->fields['orders_id'];
        return $_SESSION['orders_id'];
        }

    // if there are no empty orders_ids available to use, then generate a new one and associate it with this session
    $sql_data_array = array('session_id' => $session_id);
    zen_db_perform(TABLE_ORDERS_ID, $sql_data_array);
    $_SESSION['orders_id'] = $db->Insert_ID();
    return $_SESSION['orders_id'];
} 

This code is from the "external order number generator" mod. Can anyone see any problems here?