Forums / Managing Customers and Orders / Duplicate order ID - geomerchant gateway

Duplicate order ID - geomerchant gateway

Locked

Started by fxchain on 5 May 2009, 5:48 PM · Views: 11,714

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
5 May 2009, 5:48 PM
#1
fxchain avatar

fxchain

New Zenner

Join Date:
Oct 2006
Posts:
29
Plugin Contributions:
0

Duplicate order ID - geomerchant gateway

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!

5 May 2009, 6:10 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Duplicate order ID - geomerchant gateway

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.)

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

5 May 2009, 6:35 PM
#3
fxchain avatar

fxchain

New Zenner

Join Date:
Oct 2006
Posts:
29
Plugin Contributions:
0

Re: Duplicate order ID - geomerchant gateway

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.

5 May 2009, 6:55 PM
#4
fxchain avatar

fxchain

New Zenner

Join Date:
Oct 2006
Posts:
29
Plugin Contributions:
0

Re: Duplicate order ID - geomerchant gateway

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!**

:cry:

5 May 2009, 8:49 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Duplicate order ID - geomerchant gateway

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.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

5 May 2009, 9:14 PM
#6
fxchain avatar

fxchain

New Zenner

Join Date:
Oct 2006
Posts:
29
Plugin Contributions:
0

Re: Duplicate order ID - geomerchant gateway

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

```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?