Page 1 of 1

Keywords/Tags input field limitation

PostPosted: Wed Apr 20, 2016 10:59 am
by ningus
This is not really a bug I guess(!?), but anyway: text field for keywords/tags seem to accept only inputs up to about 250 characters. This number is reached by about 20 tags of average length, or less when tags are long words. Unfortunately words are cut off, when characters’ limit is reached.

This behaviour is reproducible in PivotX 2.3.7, 2.3.9, 2.3.11, tested with MySQL 5.1 – 5.5 and PHP 5.4 – 5.6.

I know there is no active PivotX development anymore, but is it possible to tweak tag field’s limitation or make it unlimited?

Re: Keywords/Tags input field limitation

PostPosted: Thu Apr 21, 2016 8:19 am
by hansfn
I think this can qualify as a bug - a collection of keywords should not be limited to 255 characters.

The reason for the 255 character limitation is that the keywords column in the entries and pages table has type "tinytext" - see the functions makeEntriesTable and makePagesTable in the file data.php. The solution is to change the type to "text". You can probably do this in PHPMyAdmin.