Keywords/Tags input field limitation

Discuss PivotX 2.0.x here. Non-PivotX related discussions go in The Drain.

Keywords/Tags input field limitation

Postby ningus » Wed Apr 20, 2016 10:59 am

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?
ningus
 
Posts: 33
Joined: Fri Jun 21, 2013 4:05 pm
Location: Europe

Re: Keywords/Tags input field limitation

Postby hansfn » Thu Apr 21, 2016 8:19 am

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.
hansfn
Developer
 
Posts: 3280
Joined: Sun Nov 25, 2007 7:48 pm
Location: Molde, Norway


Return to 2.x Discussion

Who is online

Users browsing this forum: No registered users and 3 guests

cron