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

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

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:
Jim Cramer fears SpaceX's IPO could be 'destructive' for the rest of market
How to plan a trip for medical tourism and the best resources
Trump touted Palantir on Truth Social after buying the company's stock, records show
What are the current weather conditions in northern BC, AB, or SK?
ISO: Good board games for 2 people to play outside while waiting in line
Special Event: Eurovision 2026: The Grand Final
The Boys: The Frenchman, the Female, and the Man Called Mother's Milk
Book: Don Quixote, chapter 3
Trump went big on tech stocks in first quarter of 2026, new filings show
China signals tariff cuts, advances in farm market access after Trump-Xi summit