close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Error on checkout (needs attention)

Thread began 10/11/2010 6:44 pm by johnb | Last modified 10/13/2010 6:45 pm by Jason Byrnes | 2061 views | 6 replies |

johnb

Error on checkout (needs attention)

Need some assistance getting PS3 to process the payment. It keeps telling me there is a duplicate order.

As a sidenote I have modified PS3 to use Firstdata (linkpoint) to process payments. This was working on the test server before but now its not on the live server.

Id like to add that no orders are showing in the database either.

When a payment is processed the failure page outputs the following results:

...AVS
746fa410f270d6bece14faf3ce0a851d ...Order Number
SGS-005003: The order already exists in the database. ...Error
DUPLICATE ...Approved
...Code
...Message
Mon Oct 11 18:36:41 2010 ...Time
...Ref
...tdate
...Tax
...Shipping
...Score
1001245243/home/stnicks/public_html/linkpoint/1001245243.pemsecure.linkpt.net1129SALELIVE0.647.957.9516.54Shawn Sealy5221 S. Santa Fe Dr.LittletonCO80120US720-581-1882shawn@stnicks.com54741501008346120912218Shawn Sealy5221 S. Santa Fe Dr.LittletonCO80120US117.95NUNSPECIFIED746fa410f270d6bece14faf3ce0a851d944100 Icicle Lights Clear (White Cord)7.951Mon Oct 11 18:36:41 2010SGS-005003: The order already exists in the database.746fa410f270d6bece14faf3ce0a851dDUPLICATE


Any Ideas?

Sign in to reply to this post

CraigRBeta Tester

I have taken a look at this in an attempt to help John out, but haven't got much further, other than when I attempt a transaction for the first time, i get a transaction declined.
Any subsequent attempt gets the duplicate order message.

I have taken the source from the failed transaction page in each instance and a modified version is below

<order>
<merchantinfo>
<configfile>1000000000</configfile>
<keyfile>/path/1000000000.pem</keyfile>
<host>secure.linkpt.net</host>
<port>1129</port>
</merchantinfo>
<orderoptions>
<ordertype>SALE</ordertype>
<result>LIVE</result>
</orderoptions>
<payment>
<tax>2.4</tax>
<shipping>15.95</shipping>
<subtotal>29.95</subtotal>
<chargetotal>48.30</chargetotal>
</payment>
<billing>
<name>John</name>
<address1>S Garland St</address1>
<address2></address2>
<city>Lake</city>
<state>CO</state>
<zip>80226</zip>
<country>US</country>
<phone>303</phone>
<fax></fax>
<email>johntest@logo.com</email>
</billing>
<creditcard>
<cardnumber>4111111111111111</cardnumber>
<cardexpmonth>12</cardexpmonth>
<cardexpyear>12</cardexpyear>
<cvmvalue>123</cvmvalue></creditcard>
<shipping>
<name>John</name>
<address1>S Garland St</address1>
<address2></address2>
<city>Lake</city>
<state>CO</state>
<zip>80226</zip>
<country>US</country>
<items>1</items>
<weight>1</weight>
<total>29.95</total>
</shipping>
<transactiondetails>
<taxexempt>N</taxexempt>
<terminaltype>UNSPECIFIED</terminaltype>
<oid>bcdf1fd6f946e2bee1d24cee082cdb68</oid>
</transactiondetails>
<items>
<item>
<id>992</id>
<description>10 Budweiser Can Lights</description>
<price>29.95</price>
<quantity>1</quantity>
</item>
</items>
</order>
<r_csp></r_csp>
<r_time>Tue Oct 12 08:48:33 2010</r_time>
<r_ref></r_ref>
<r_error>SGS-000001: D:DeclinedXXUX:</r_error>
<r_ordernum>bcdf1fd6f946e2bee1d24cee082cdb68</r_ordernum>
<r_message>DECLINED</r_message>
<r_code></r_code>
<r_tdate>1286887713</r_tdate>
<r_score></r_score>
<r_authresponse>X07</r_authresponse>
<r_approved>DECLINED</r_approved>
<r_avs></r_avs>

Test 2

<order>
<merchantinfo>
<configfile>1000000000</configfile>
<keyfile>/path/1000000000.pem</keyfile>
<host>secure.linkpt.net</host>
<port>1129</port>
</merchantinfo>
<orderoptions>
<ordertype>SALE</ordertype>
<result>LIVE</result>
</orderoptions>
<payment>
<tax>2.4</tax>
<shipping>31.9</shipping>
<subtotal>29.95</subtotal>
<chargetotal>64.25</chargetotal>
</payment>
<billing>
<name>John</name>
<address1>S Garland St</address1>
<address2></address2>
<city>Lake</city>
<state>CO</state>
<zip>80226</zip>
<country>US</country>
<phone>3039193007</phone>
<fax></fax>
<email>johntest@logo.com</email>
</billing>
<creditcard><cardnumber>4111111111111111</cardnumber>
<cardexpmonth>12</cardexpmonth>
<cardexpyear>12</cardexpyear>
<cvmvalue>456</cvmvalue>
</creditcard>
<shipping>
<name>John</name>
<address1>S Garland St</address1>
<address2></address2>
<city>Lake</city>
<state>CO</state>
<zip>80226</zip>
country>US</country>
<items>1</items>
<weight>1</weight>
<total>29.95</total>
</shipping>
<transactiondetails>
<taxexempt>N</taxexempt>
<terminaltype>UNSPECIFIED</terminaltype>
<oid>bcdf1fd6f946e2bee1d24cee082cdb68</oid>
</transactiondetails>
<items>
<item>
<id>992</id>
<description>10 Budweiser Can Lights</description>
<price>29.95</price>
<quantity>1</quantity>
</item>
</items>
</order>
<r_csp></r_csp>
<r_time>Tue Oct 12 08:57:19 2010</r_time>
<r_ref></r_ref>
<r_error>SGS-005003: The order already exists in the database.</r_error>
<r_ordernum>bcdf1fd6f946e2bee1d24cee082cdb68</r_ordernum>
<r_message></r_message>
<r_code></r_code>
<r_tdate></r_tdate>
<r_score></r_score>
<r_authresponse></r_authresponse>
<r_approved>DUPLICATE</r_approved>
<r_avs></r_avs>



If anyone has used this payment gateway before, can I check, do the test c/c details work in a live environment ?

Sign in to reply to this post

Jason ByrnesWebAssist

on the confirm page, how is the oid being generated:

php:
$LinkPointAPI_itemized[0][1] = "transactiondetails->oid";

  $LinkPointAPI_itemized[1][1] = "".session_id()  ."";




usually, it should use the session_id()


if it is using the session_id() already, make sure that the session id is working correctly.

Create a new page and add the following code:

php:
<?php 

if(!session_id()) session_start(); 
echo(
session_id()); ?>




open this page in fire fox, then again in IE and compare the ID's, they should be different.

Sign in to reply to this post

johnb

According to your reply everything checks out okay.

If a customer places an order that declines and then tries to place it again correctly will the session cause it to send the same order number causing the transaction to fail as a duplicate? Or if they place one successful order then place a second successful one afterward?

Sign in to reply to this post

Jason ByrnesWebAssist

trey adding this code on the success page at the very end:

php:
<?php

// Initialize the session.
// If you are using session_name("something"), don't forget it now!
@session_start();

// Unset all of the session variables.
$_SESSION = array();

// If it's desired to kill the session, also delete the session cookie.
// Note: This will destroy the session, and not just the session data!
if (ini_get("session.use_cookies")) {
    
$params session_get_cookie_params();
    @
setcookie(session_name(), ''time() - 42000,
        
$params["path"], $params["domain"],
        
$params["secure"], $params["httponly"]
    );
}

// Finally, destroy the session.
session_destroy();
session_regenerate_id();
?>
Sign in to reply to this post

johnb

I see this code already at the end:

php:
<?php 

if ("" == ""){
  
// WA_ClearSession
    
$clearAll FALSE;
    
$clearThese explode(",","OrderID,WA_Store_Cart_Items,specialinstructions");
    if(
$clearAll){
        foreach (
$_SESSION as $key => $value){
            unset(
$_SESSION[$key]);
        }
    }
    else{
        foreach(
$clearThese as $value){
            unset(
$_SESSION[$value]);
        }
    }
}
?>




How is he code you suggested to put at the end different? I guess I'm asking what it does differently? Also would I replace this code or add it afterward?

Sign in to reply to this post

Jason ByrnesWebAssist

that code just clears the session variables, it will not reset the session id.

You can replace that code or just add the new code after it.

either way will work

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...