LinkPoint and Error SGS-005000

[Rasyr]

We have had a number of customers receive the following error:

SGS-005000: The server encountered a database error.

There seems to be no rhyme or reason behind the receiving of this error.

A google search for the Error Number turns up the following:

SGS-005000: The server encountered a database error.

Make sure you have not exceeded the character limit for any of the fields. The <items><description> field has a limit of 120 characters.

None of those who receive it are from the same location or ordering the same products. We have had larger orders, and we have had smaller orders. We have had orders with the same products go through.

We have had folks receive this error on Linkpoint for CC, and then use their CC through Paypal and have it work properly.

I have a number of debug files for these folks, if somebody would be willing to take a look to see if there is anything that might be causing this error.

None of our product names (what shows up in the description field) is anywhere near 120 characters long.

We are at a complete loss to explain this problem...

Can anybody please shed some light on it...

[tstamplis]

I had this error today as well. I called linkpoint and they told me one of the fields contained more characters than allowed, though they didn't tell me which one. We are an engraving company so we use a lot of attributes including two text fields for instructions and engraving text. ALL of this information is passed to linkpoint (not sure why). Is there anyone that can help in this regard?

[Rasyr]

Does anybody know how to stop it from passing the Options?

We had a fellow try his order 1 item at a time and it seems to be multiple options causing it to blow up

[DrByte]

What version of Zen Cart?
v1.3.8 already limits the 'description' parameter to 100 characters.

You may or may not find this patch useful: http://www.zen-cart.com/forum/showth...462#post520462

[tstamplis]

What version of Zen Cart?
v1.3.8 already limits the 'description' parameter to 100 characters.

You may or may not find this patch useful: http://www.zen-cart.com/forum/showth...462#post520462

I am running 1.3.8a. Below is the info from the cc review (x's added for personal info):
DECLINED
5466XXXXXXXX2809
Expires: 12/10
10-folO3c

SGS-005000: The server encountered a database error.

result=LIVE; oid=10-folO3c; ip=xx.xxx.xxx.xx; ponumber=; subtotal=21.95; tax=0; shipping=6.9; chargetotal=28.85; cardnumber=5466XXXXXXXX2809; cardexpmonth=12; cardexpyear=10; cvmindicator=provided; cvmvalue=xxx; userid=15; customerid=15; name=xxxxxx xxxxx; company=; address1=xxx xth Avenue; address2=; city=xxxxx xxxxxxxxx; state=Wisconsin; country=US; phone=xxx-xxx-xxxx; [email protected]; addrnum=xxxx xth Avenue; zip=53172; sname=xxxxxxxx xxxxx; saddress1=xxxx xth Avenue; saddress2=; scity=xxxxx xxxxxxxxx; sstate=Wisconsin; szip=53172; scountry=US; comments=Website Order; items=Array ( [0] => Array ( [id] => 5:2f803c6aa0a51baf41daf82c9d646829 [description] => Personalized Black Anodized License Plate [quantity] => 1 [price] => 21.95 [options0] => Array ( [name] => Do you want this item engraved? [value] => Yes ) [options1] => Array ( [name] => Font [value] => 27. Script MT Bold ) [options2] => Array ( [name] => Engraved Text [value] => THE RAVEN ) [options3] => Array ( [name] => Layout and Special Instructions [value] => I would like to have both words centered on the liscense, THE above RAVEN and also have the word RAVEN larger then THE. Email me with any questions [email protected] ) [options4] => Array ( [name] => Emailing add'l images or text? [value] => No ) ) ) ; ordertype=SALE;

I am wondering if it is because of all the attributes being sent, is that possible? And if so, can they be "turned off" as I don't think it's pertinent. Any help would be appreciated.

[tstamplis]

I am running 1.3.8a. Below is the info from the cc review (x's added for personal info):
DECLINED
5466XXXXXXXX2809
Expires: 12/10
10-folO3c

SGS-005000: The server encountered a database error.

result=LIVE; oid=10-folO3c; ip=xx.xxx.xxx.xx; ponumber=; subtotal=21.95; tax=0; shipping=6.9; chargetotal=28.85; cardnumber=5466XXXXXXXX2809; cardexpmonth=12; cardexpyear=10; cvmindicator=provided; cvmvalue=xxx; userid=15; customerid=15; name=xxxxxx xxxxx; company=; address1=xxx xth Avenue; address2=; city=xxxxx xxxxxxxxx; state=Wisconsin; country=US; phone=xxx-xxx-xxxx; [email protected]; addrnum=xxxx xth Avenue; zip=53172; sname=xxxxxxxx xxxxx; saddress1=xxxx xth Avenue; saddress2=; scity=xxxxx xxxxxxxxx; sstate=Wisconsin; szip=53172; scountry=US; comments=Website Order; items=Array ( [0] => Array ( [id] => 5:2f803c6aa0a51baf41daf82c9d646829 [description] => Personalized Black Anodized License Plate [quantity] => 1 [price] => 21.95 [options0] => Array ( [name] => Do you want this item engraved? [value] => Yes ) [options1] => Array ( [name] => Font [value] => 27. Script MT Bold ) [options2] => Array ( [name] => Engraved Text [value] => THE RAVEN ) [options3] => Array ( [name] => Layout and Special Instructions [value] => I would like to have both words centered on the liscense, THE above RAVEN and also have the word RAVEN larger then THE. Email me with any questions [email protected] ) [options4] => Array ( [name] => Emailing add'l images or text? [value] => No ) ) ) ; ordertype=SALE;

I am wondering if it is because of all the attributes being sent, is that possible? And if so, can they be "turned off" as I don't think it's pertinent. Any help would be appreciated.

Notice the 2nd text array value for name "Layout and Special Instructions", it is more than 120 characters long. This is the only field I notice that is over 120 characters.

[Rasyr]

What version of Zen Cart?
v1.3.8 already limits the 'description' parameter to 100 characters.

You may or may not find this patch useful: http://www.zen-cart.com/forum/showth...462#post520462

I am using v. 1.3.8a

It is appearing as if Linkpoint is adding some text from the various options into the <item><description> fields causing the error.

We tested with a customer, he can successfully order with 1 attribute, but when he placed an order for one with 4 options, it threw the error.

Here is the debug file from one of the failed orders

Apr-12-2008 03:51:19
=================================

Response Code: DECLINED

Sending to Gateway: 
result = LIVE
oid = 960-q12dKi
ip = 71.182.231.207
ponumber = 
subtotal = 108.99
tax = 0
shipping = 9.19
chargetotal = 118.18
cardnumber = ******
cardexpmonth = 05
cardexpyear = 09
cvmindicator = provided
cvmvalue = ******
userid = 264
customerid = 264
name = William Hxxxxxxx
company = 
address1 = 39 Txxxxxxxx Ln
address2 = 
city = Spxxxxxxxxxx
state = New York
country = US
phone = xxx-xxx-xxxx
email = [email protected]
addrnum = 39 Txxxxxx Ln
zip = 14559
sname = William Hxxxxxxx
saddress1 = 39 Txxxxxxxx Ln
saddress2 = 
scity = Sxxxxxxxxx
sstate = New York
szip = 1xxxx
scountry = US
comments = Website Order
items = Array
(
    [1] => Array
        (
            [id] => 184:722d000d4aa3b69cc6a01b83ec227853
            [description] => HARP Combat Cards PDF
            [quantity] => 1
            [price] => 5.00
            [options0] => Array
                (
                    [name] => Download 1
                    [value] => PDF
                )

        )

    [2] => Array
        (
            [id] => 384:dca3197a19d64c2e93d1467573da9e4c
            [description] => HARP VP 2
            [quantity] => 1
            [price] => 86.10
            [options0] => Array
                (
                    [name] => With Bundled
                    [value] => PDF
                )

            [options1] => Array
                (
                    [name] => With Bundled
                    [value] => PDF2
                )

            [options2] => Array
                (
                    [name] => With Bundled
                    [value] => PDF3
                )

            [options3] => Array
                (
                    [name] => With Bundled
                    [value] => PDF4
                )

        )

    [3] => Array
        (
            [id] => 182:f5b9cdbd8bb9608c6dad80b55bbf2987
            [description] => HARP Gamemaster Screen
            [quantity] => 1
            [price] => 22.00
            [options0] => Array
                (
                    [name] => With Bundled
                    [value] => PDF
                )

        )

    [4] => Array
        (
            [id] => 181:a6d84afbf7f94c38446c7fc11eae6de3
            [description] => The Codex PDF
            [quantity] => 1
            [price] => 8.00
            [options0] => Array
                (
                    [name] => Download 1
                    [value] => PDF
                )

        )

)

ordertype = SALE
host = secure.linkpt.net
port = 1129
keyfile = xxxxxxxxxxxxxxxxxx/xxxxxx.pem
configfile = 560492
transactionorigin = ECI
terminaltype = UNSPECIFIED


Result: 
(
    [r_csp] => 
    [r_time] => Sat Apr 12 13:49:19 2008
    [r_ref] => 
    [r_error] => SGS-005000: The server encountered a database error.
    [r_ordernum] => 960-q12dKi
    [r_message] => 
    [r_code] => 
    [r_tdate] => 
    [r_score] => 
    [r_authresponse] => 
    [r_approved] => DECLINED
    [r_avs] => 
)

We had him purchase each item separately, and everything went through find, except for item #2.

And when we looked back through the other debug files, we found the same pattern -- all failing on items with more than 1 optional item listed.

[tstamplis]

Rasyr,

Have you been able to find a fix for this yet?

[Rasyr]

Sort of....

Where we had Value Packs (i.e. multiple books), and we wanted to be able to bundle PDFs with them, we dropped the individual listings for the PDFs, and instead did it as a single zip file containing all of the PDFs (so, instead of picking and choosing, you now have the option of purchasing none or all (though the PDFs are also sold separately, but the bundled versions were 50% normal price).

What appears to be happening is that Linkpoint is including at least SOME of the Option information in the description field (possibly all of it), so for each product, not only was it including the product name, but also "With Bundled PDF" for each PDF that was bundled, and 16 characters multiplied by 3 or 4 times per Value Pack really added up.

The ideal solution would be to find a way to make it so that the Options Information is not sent to Linkpoite (thus not overloading their "description" field).

BUt my attempts at doing that only ended up with getting a blank screen during checkout process....

[tstamplis]

Sort of....

Where we had Value Packs (i.e. multiple books), and we wanted to be able to bundle PDFs with them, we dropped the individual listings for the PDFs, and instead did it as a single zip file containing all of the PDFs (so, instead of picking and choosing, you now have the option of purchasing none or all (though the PDFs are also sold separately, but the bundled versions were 50% normal price).

What appears to be happening is that Linkpoint is including at least SOME of the Option information in the description field (possibly all of it), so for each product, not only was it including the product name, but also "With Bundled PDF" for each PDF that was bundled, and 16 characters multiplied by 3 or 4 times per Value Pack really added up.

The ideal solution would be to find a way to make it so that the Options Information is not sent to Linkpoite (thus not overloading their "description" field).

BUt my attempts at doing that only ended up with getting a blank screen during checkout process....

Keep me posted here if you should find a solution. I am very suseptable <sp> to this as an engraver as people tend to leave long-winded instructions for layout.