Post by jrb1 » Fri Feb 17, 2012 6:48 am

Hi, I'm using OC 1.5.1.3 there seems to be a character limit set in the Information section where I want to paste my Terms & Conditions. When I paste my terms & conditions only half of the information is saved. Does anyone know how to increase this limit?

Thanks in advance.

Newbie

Posts

Joined
Sun Nov 27, 2011 12:42 am

Post by fido-x » Fri Feb 17, 2012 7:06 am

The description field for information pages is a "text" field, which allows for something like 32,768 characters (you can't increase this). The only validation done is to check that there is a minimum of 3 characters.

You shouldn't be having any issues with the length of your Terms & Conditions, unless you're trying to paste into the wrong field.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by jrb1 » Fri Feb 17, 2012 7:14 am

Hi Fido-x

Thanks for the quick reply - I've just checked, my terms & conditions have 58,100 characters. There in lies the problem.

Julian

Newbie

Posts

Joined
Sun Nov 27, 2011 12:42 am

Post by rph » Fri Feb 17, 2012 3:15 pm

Code: Select all

ALTER TABLE `information_description` CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
EDIT: For those looking for more explanation, the above is an SQL query which you can run in phpmyadmin. It changes description from TEXT which has a 64KB limit to MEDIUMTEXT which has a 16MB limit.
Last edited by rph on Sat Apr 14, 2012 3:52 am, edited 1 time in total.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by jrb1 » Sat Feb 18, 2012 3:34 am

Thanks for your help Ryan

Worked perfectly

Cheers

Newbie

Posts

Joined
Sun Nov 27, 2011 12:42 am

Post by rph » Sat Feb 18, 2012 3:55 am

No problem.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by Krammig » Tue Jun 21, 2016 2:03 pm

I cannot believe after all these years this is still an issue with Opencart.

I have been sitting here for a good amount of time trying to work out why the Description field was truncating my data. So frustrating.

Thanks Ryan this fixed my problem.

Perhaps the Opencart team can get their act together enough to update this issue.

cheers

New member

Posts

Joined
Mon Sep 01, 2014 4:01 pm

Post by zjasper » Thu Sep 22, 2016 11:21 pm

Thanks a lot! It is a pitty it is still limited in version 2.3.02.

Newbie

Posts

Joined
Thu Sep 22, 2016 11:20 pm

Post by richardvaneck » Thu Dec 01, 2016 11:17 pm

Works still great with opencart 2.3.0.2

Code: Select all

ALTER TABLE `oc_information_description` CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL

Newbie

Posts

Joined
Thu Dec 01, 2016 9:25 pm
Who is online

Users browsing this forum: No registered users and 107 guests