Your card was not billed. The following error was received: DUPLICATE

Submitted by Ralph Manis on Thu, 2009-12-03 22:53

I just had a customer call me unable to place an order due to error:

Your card was not billed. The following error was received:
DUPLICATE

I just tried myself and got the same result.

Drupal 5.20
ecommerce 5.36

http://www.rock-band-t-shirts.com

Any help would be greatly appreciated due to lack of sales during the busiest season,

Ralph

Groups:

e-Commerce Module

duplicate

webengr - Fri, 2009-12-04 16:03

What you may be experiencing is that LinkPoint (1st Data) will not process on the same order number if the previous transaction failed or if the order number has already been used. Not only that, if the credit card failed and you rerun it with a different order number, but in less than 10 minutes it will fail also.

The manual solution is to make sure that 10 minutes have elapsed since that card was used and to make sure the order number is different. The better solution I fear is to go to authorize.net which will have more fees per month... Linkpoint and variants just don't have as much features as other payment systems. for example linkpoint really can't store credit card numbers, authorize.net can with tokens.

I think the ubercart people found this out also and were talking about it and on 6.x they may have made some auto increment on the order number for retries... not sure.

One suggestion was to use phpmyadmin or mysql to change the order number in the mysql tables for the customer in question. since I was doing transactions I changed the order number or rentered a new order for the customer....

Sorry...

I wish that e-commerce 6.x would be finished with the invoicing like 5 has but even when the stable releases the "invoice" feature is not going to be available at first, it it was I'd look into rolling the linkpoint gateway fixes... but the last release candidate was awhile back, 2009-May-31.

The only reason I have not abandoned e-commerce yet is that ubercart developers are not interested in supporting the "invoicing" feature of ecommerce 5.x at all and at list Gordon says they will some day put it back in.

Thanks for the insight! I

Ralph Manis - Fri, 2009-12-04 16:21

Thanks for the insight! I thought it was Linkpoint but, it's good to know just what's happening. Unfortunately my bank is not affiliated with Authorize.net.

I lost a bunch of data in a crash and had to rebuild the data base manually with what little backup info I had and lost some transaction order numbers. Since rebuilding, the order numbers started at the number of the last saved backup. Do you think that the order numbers will create duplicates now or will it just continue from whatever number is last in the db?

Thanks again,

Ralph

Ralph Manis
http://www.infinitee-designs.com/
http://www.infiniteewebdesign.com/
http://www.rock-band-t-shirts.com/

order number for e-commerce

webengr - Fri, 2009-12-04 17:11

I would think the core e-commerce handles the order numbers, not the gateway add on modules.

Like a check book I'd not start at one, maybe reset that part to start at 1001.

I looked through the drupal 5 implementation of e-commerce and I see an interesting table, sequences.
Read http://drupal.org/node/213091
I also see in that table for me a row for "txnid"
and that's like my order number for transactions.

I don't know for sure, but maybe your order numbers don't use a table auto_increment feature,
but are instead saved in the drupal sequences?
Perhaps the number you need to change is in that table?

BTW, for you ubercart readers here is the faq link for changing order numer in ubercart:
http://www.ubercart.org/faq/2892

"Like a check book I'd not

Ralph Manis - Fri, 2009-12-04 17:45

"Like a check book I'd not start at one, maybe reset that part to start at 1001"

That is what I was thinking... Change the last txnid in the transactions table to a number way beyond what I know is the my last order before the crash. I just wanted to make sure this wouldn't screw anything up at this delicate time period.

Thanks for you help,

Ralph Manis
http://www.infinitee-designs.com/
http://www.infiniteewebdesign.com/
http://www.rock-band-t-shirts.com/

transaction table is not auto_increment I think

webengr - Fri, 2009-12-04 18:05

Do be careful, I don't think changing the last entry in ec_transactions will cause the next number to be larger...

It could be that the next transaction number is taken by looking up the sequence table.

So, do you have any other

Ralph Manis - Fri, 2009-12-04 18:16

So, do you have any other suggestions on increasing the the increment?

Ralph Manis
http://www.infinitee-designs.com/
http://www.infiniteewebdesign.com/
http://www.rock-band-t-shirts.com/

edit mysql table

webengr - Fri, 2009-12-04 20:47

As hinted above, edit the sequence table

use whatever way you edit mysql tables and change the value for "ec_transaction_txnid" in table "sequences" to a larger integer.

Then do a transaction and see if it gives you the expected order number.

Then report back if that worked, and write up your experience and do a faq on drupal e-commerce notes somewhere appropriate on "how to change the starting order/transaction number"

did it work

webengr - Tue, 2009-12-08 23:32

So Ralph, did it work?

I have not tried it since I

Ralph Manis - Tue, 2009-12-08 23:47

I have not tried it since I been receiving orders without any problems. I was going to wait until I got another complaint about it not working. I may test it out again but, I don't want to break it if it 'aint broke! Especially at this time of the year.

I am also very busy.

Thanks for asking and all your help,

Ralph

Ralph Manis
http://www.infinitee-designs.com/
http://www.infiniteewebdesign.com/
http://www.rock-band-t-shirts.com/