Data too long for column 'ordIP'

Author	« Topic »
trendyhounds Advanced Member 245 Posts	Posted - 10/27/2020 : 18:41:21 I just updated to version 7.2.4 & got this error. Does anybody know what this error is & how to correct it? Checking for Admin Shipping upgrade Terminated but with errors Data too long for column 'ordIP' at row 1120 Edited by - trendyhounds on 10/27/2020 19:18:17
Phil ECT Moderator United Kingdom 7622 Posts	Posted - 10/28/2020 : 01:49:50 Hi Kath, I've taken a quick look at this and fixed it for you. I'll have a quick word with Vince and see what he recommends for the future. * Database Migrations and Conversions* * ASP to PHP Cart Conversions* *Contact Us* *Buy The PHP Capture Card Plugin* Rate Our Services/View Our Feedback
Vince Administrator 42473 Posts	Posted - 10/28/2020 : 02:48:50 Firstly, thanks to Phil for stepping in with a solution so quickly and it seems that what you've done is fine. The reason for the change is because certain types of database table structure have a limit to the size of a row and the orders table was approaching that. So columns like the IP Address which used a default max of 255 characters were reduced to reduce this row size and was set to something in this case which should allow for even the longer IPv6 addresses. For some reason in your orders table there is a slightly longer value which caused the change to fail. I've made a change so this won't cause a problem in the future and what Phil has done for your site, Trendyhounds, is fine and you won't have any problems. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
trendyhounds Advanced Member 245 Posts	Posted - 10/28/2020 : 06:27:57 Thanks Phil & Vince!!!!
	« Topic »