ProductCart Shopping Cart Software Forums : Error -2147217833 IP Address would be truncated https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 16:24:34 +0000 Sun, 02 Dec 2012 07:38:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=4795 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Error -2147217833 IP Address would be truncated : Thanks Sean, I&#039;ve added your...]]> https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20514.html#20514 Author: Hamish
Subject: 4795
Posted: 02-December-2012 at 7:38am

Thanks Sean,
   I've added your fix to the system for the developers to pick up & incorporate.
Regards,
     Hamish
]]> Sun, 02 Dec 2012 07:38:32 +0000 https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20514.html#20514 <![CDATA[Error -2147217833 IP Address would be truncated : Wow. Thank you very much for...]]> https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20511.html#20511 Author: odathp
Subject: 4795
Posted: 02-December-2012 at 12:16am

Wow.  Thank you very much for this.  I am the original poster that reported this problem and have been dealing with it for at least a year.

This client is currently running PC 4.6a.  The two other locations you identified were never fixed.

Was just getting ready to post again to beg for a solution since we get 9-10 of these weird IPs a month and were potentially losing those orders.

Thanks again!!!!!!!!!!
< id="ezPreviewPO" border="0" scrolling="yes" style="width: 100%; height: 90%">
< id="ezPreview" border="0" scrolling="yes" style="width: 100%; height: 90%">


Edited by Hamish - 02-December-2012 at 6:06am]]> Sun, 02 Dec 2012 00:16:44 +0000 https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20511.html#20511 <![CDATA[Error -2147217833 IP Address would be truncated : Glad it worked for you.Hopefully...]]> https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20169.html#20169 Author: Guests
Subject: 4795
Posted: 18-September-2012 at 7:14pm

Glad it worked for you.

Hopefully EI will add this to their next update.
]]> Tue, 18 Sep 2012 19:14:19 +0000 https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20169.html#20169 <![CDATA[Error -2147217833 IP Address would be truncated : Thanks for the easy to follow...]]> https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20167.html#20167 Author: Wonderfulnews
Subject: 4795
Posted: 18-September-2012 at 6:35pm

Thanks for the easy to follow solution!]]> Tue, 18 Sep 2012 18:35:49 +0000 https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20167.html#20167 <![CDATA[Error -2147217833 IP Address would be truncated : As of v4.5 this appears to have...]]> https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20160.html#20160 Author: Guests
Subject: 4795
Posted: 17-September-2012 at 4:58pm

As of v4.5 this appears to have been addressed in one location, but not in two others.

The fix appears in /pc/opc_GateWayData.asp

It should also be followed through on the following pages:

/pc/pcPay_GoogleCheckout_Notification.asp

find: 
'// Update Risk Management Status

Just above it add:
'save only the first 15 characters in case this is returned as a list of IP addresses
pcv_strIpAddress = left(pcv_strIpAddress,15)

In /pc/pcGateWayData.asp find:
'SAVE customer IP to order

Just above it, add:
'save only the first 15 characters in case this is returned as a list of IP addresses
pcCustIpAddress = left(pcCustIpAddress,15)

]]> Mon, 17 Sep 2012 16:58:03 +0000 https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20160.html#20160 <![CDATA[Error -2147217833 IP Address would be truncated : All,I am wondering if and how...]]> https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20159.html#20159 Author: Wonderfulnews
Subject: 4795
Posted: 16-September-2012 at 4:50pm

All,

I am wondering if and how this issue was resolved. I too have customers complaining about this problem AND have been able to replicate it myself when using a retail wireless router between the cable modem and the desk top computer.

Error Number: -2147217833
Source: Microsoft OLE DB Provider for SQL Server
Description: String or binary data would be truncated.
CustomerIP='123.237.252.153:59147'

thoughts?
]]> Sun, 16 Sep 2012 16:50:22 +0000 https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post20159.html#20159 <![CDATA[Error -2147217833 IP Address would be truncated : Hi, I investigated &amp; it...]]> https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post18485.html#18485 Author: Hamish
Subject: 4795
Posted: 11-October-2011 at 4:48pm

Hi,
   I investigated & it seems we test HTTP_X_FORWARDED_FOR first, so I believe some work is required, but I also couldn't find any references to HTTP_X_FORWARDED_FOR returning the port number.  Ask your customer if they are using a proxy server.  ]]> Tue, 11 Oct 2011 16:48:27 +0000 https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post18485.html#18485 <![CDATA[Error -2147217833 IP Address would be truncated : Yes, we did call the customer...]]> https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post18484.html#18484 Author: odathp
Subject: 4795
Posted: 11-October-2011 at 3:33pm

Yes, we did call the customer and are waiting for him to call back.

I still think there is something fishy with ProductCart code that queries a visitor IP and returns the IP with port number.  I think in ASP you have to specifically request the client port number.

Request.ServerVariables("remote_addr")

vs.

Request.ServerVariables("remote_port")

]]> Tue, 11 Oct 2011 15:33:11 +0000 https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post18484.html#18484 <![CDATA[Error -2147217833 IP Address would be truncated : Of course your right about the...]]> https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post18483.html#18483 Author: Hamish
Subject: 4795
Posted: 11-October-2011 at 2:24pm

Of course your right about the IP address! 
I suspect the PC may have been compromised, but beyond that I'm stumped. Do you have enough info from the failed order to contact the customer to see if they are deliberately doing something unusual? If not, then I suspect they would appreciate the call as, if their PC has been compromised then any transactions they carry out will quite likely lead to their card & personal details being compromised as well. If it is deliberate it would be V interesting to know what they are doing @ why!!    ]]> Tue, 11 Oct 2011 14:24:54 +0000 https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post18483.html#18483 <![CDATA[Error -2147217833 IP Address would be truncated : The IP I mentioned is not the...]]> https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post18482.html#18482 Author: odathp
Subject: 4795
Posted: 11-October-2011 at 1:59pm

The IP I mentioned is not the site IP.  It is the customer IP.

ProductCart is capturing the customer IP with a port number attached.  It cannot save the customer IP since it exceeds the field length in the database.

What does capturing the customer IP have to do with accessing the site via non standard ports?

The only other clue I have is this customer IP is listed on Spamhaus.


Our other customer that had this problem was listed on CBL, but has since been removed.
]]> Tue, 11 Oct 2011 13:59:40 +0000 https://forum.productcart.com/error-2147217833-ip-address-would-be-truncated_topic4795_post18482.html#18482