Answered: Where is configurations of max length of the categories?

Post date: 2021-04-13 23:51:19
Views: 79

The length of category names is limited by the size of the title field in the respective database table:

MariaDB dbname]> describe qa_categories;
+------------+----------------------+------+-----+---------+----------------+
| Field      | Type                 | Null | Key | Default | Extra          |
+------------+----------------------+------+-----+---------+----------------+
| categoryid | int(10) unsigned     | NO   | PRI | NULL    | auto_increment |
| parentid   | int(10) unsigned     | YES  | MUL | NULL    |                |
| title      | varchar(80)          | NO   |     | NULL    |                |
| tags       | varchar(200)         | NO   |     | NULL    |                |
| content    | varchar(800)         | NO   |     |         |                |
| qcount     | int(10) unsigned     | NO   |     | 0       |                |
| position   | smallint(5) unsigned | NO   |     | NULL    |                |
| backpath   | varchar(804)         | NO   | MUL |         |                |
+------------+----------------------+------+-----+---------+----------------+

The size limit is set when the table is created and the value for the limit is defined in qa-include/db/maxima.php:

$maximaDefaults = array(
  ...
  'QA_DB_MAX_CAT_PAGE_TITLE_LENGTH' => 80,
  ...
};

Please click Here to read the full story.
 
Other Top and Latest Questions:
Not really a fan of nature, are you?
Interview with the Vampire: The Vampire Lestat: The Failures Books Included
Maximum Pleasure Guaranteed: Full season 1
Book: The September House
Stargate SG-1: Summit Rewatch
Morgan Stanley likes these stocks heading into second-quarter earnings
Lucid dismisses report that it is weighing filing for bankruptcy or going private after shares plunge
Jim Cramer says concerns about AI market froth are overblown. Here's why
IBM stock craters 25%, the worst day on record, after company issues second-quarter earnings warning
Caution warranted on this red hot AI cloud data stock that's now 'priced for perfection,' says Todd Gordon