Textpattern CMS

#1 2013-10-01 11:44:07

m.young

Member

Registered: 2012-02-22

Posts: 10

How to increase the Keywords limit of 255 characters?

Hi,
I want to increase Textpattern’s keyword character limit. I understand it is set to 255 characters by default in MySQL.
I have looked in there using phpMyAdmin, however, there are a lot of pages, tabs & variables.

I just need to know the name of the variable which controls the Keywords limitation, once I know that I can try to increase the limit.

Thanks in advance of an answer!

#2 2013-10-01 11:54:38

philwareham

Core designer

From: Haslemere, Surrey, UK

Registered: 2009-06-11

Posts: 3,564

Website GitHub Mastodon

Re: How to increase the Keywords limit of 255 characters?

Yes, it’s in the ‘textpattern’ table. Look for ‘Keywords’ then change it’s type from ‘varchar(255)’ to ‘text’.

#3 2013-10-01 17:53:25

CodeWalker

Member

From: Hampshire, UK

Registered: 2010-01-08

Posts: 110

Website

Re: How to increase the Keywords limit of 255 characters?

As an aside you can also run into this on the custom fields. Same fix.

#4 2013-10-03 15:36:21

m.young

Member

Registered: 2012-02-22

Posts: 10

Re: How to increase the Keywords limit of 255 characters?

Hi philwareham & CodeWalker,
Thank you for your advice. I’ve successfully amended the values in myPHPAdmin. Thanks for your advice… you’ve saved me from even more head-scratching & frustration!
Thanks,
Martin