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

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

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:
'Silent killers': How AI start-ups are trying to solve one of the retail industry's biggest problems
CNBC Points Pro: How soon should I use my credit card points after earning them?
Elon Musk seeks ouster of OpenAI CEO Sam Altman as part of lawsuit
USDA Secretary Brooke Rollins sent Easter email to staff touting 'Jesus' and 'God'
FedEx trucking spinoff targets 2026 operating margin of 12%
Playing Alphabet using a bullish options trade after tech giant recently topped a key level
Delta, Southwest raise checked bag fees $10 amid jet fuel price surge, joining other carriers
Trump threatens tariffs of 50% on countries 'supplying military weapons to Iran'
Monarch: Legacy of Monsters: Requiem
Ray Dalio: Trump-Xi meeting to focus on trade, capital flows