Post by SamNabz » Fri Mar 09, 2012 3:55 pm

Hi all,

Is there a character limit set on the information page? I've looked in the corresponding files and can't seem to find it.

Reason I ask is I am trying to add a Colour Chart on one of the pages which is a table of 1000+ colour 'cards' but it throws the page out after about 30 or so rows..

Any info is appreciated.
Last edited by SamNabz on Sun Mar 11, 2012 11:38 am, edited 1 time in total.

Cheers, Sam


Active Member

Posts

Joined
Wed Jul 06, 2011 7:32 am
Location - Sydney, Australia

Post by grgr » Fri Mar 09, 2012 8:51 pm

You could try changing the 'description' field type from 'text' to 'mediumtext' on the 'information_description' table through your phpMyAdmin.

-
Image Image Image Image
VIEW ALL EXTENSIONS * EXTENSION SUPPORT * WEBSITE * CUSTOM REQUESTS


User avatar
Active Member

Posts

Joined
Mon Mar 28, 2011 4:08 pm
Location - UK

Post by SamNabz » Sun Mar 11, 2012 8:02 am

Hi grgr, thanks for the quick reply.

It worked, but I ended up using LONGTEXT, as MEDIUMTEXT wasn't enough.

Code: Select all

ALTER TABLE `information_description` CHANGE `description` `description` LONGTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
Thanks again.

Cheers, Sam


Active Member

Posts

Joined
Wed Jul 06, 2011 7:32 am
Location - Sydney, Australia

Post by mandamexico » Mon Dec 17, 2012 8:00 am

worked perfectly, thank you grgr!

My Extensions

OpenCart Developer (OCD) Tools

Donate - If I ever helped you.


User avatar
Active Member

Posts

Joined
Mon Jun 29, 2009 10:14 am
Location - Los Angeles, CA

Post by doannhien » Fri Aug 15, 2014 4:58 pm

grgr wrote:You could try changing the 'description' field type from 'text' to 'mediumtext' on the 'information_description' table through your phpMyAdmin.
Worked too. Thank Grgr :)

Newbie

Posts

Joined
Thu Nov 21, 2013 5:41 pm

Post by CoronaTechniek » Wed Dec 14, 2016 5:52 pm

SamNabz wrote:Hi grgr, thanks for the quick reply.

It worked, but I ended up using LONGTEXT, as MEDIUMTEXT wasn't enough.

Code: Select all

ALTER TABLE `information_description` CHANGE `description` `description` LONGTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
Thanks again.
Thanks this works on 2.2.0.0 too :ok: :ok:

http://www.koienvijvercentrum.nl Alles voor Koi en Vijver Opencart 2.3.0.2


User avatar
Active Member

Posts

Joined
Sat Dec 17, 2011 4:25 am
Location - Groningen

Post by Mored1984 » Thu Feb 22, 2018 12:05 pm

Work for me, thanx

=======
Regards
M.Taleb
=======


User avatar
Newbie

Posts

Joined
Tue Jan 23, 2018 10:58 pm
Who is online

Users browsing this forum: No registered users and 394 guests