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

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

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:
Apple's elevation of silicon head Johny Srouji signals sprint to build in-house chips for all devices
United Airlines slashes 2026 forecast as fuel costs surge
Trump recounts Tim Cook call to 'kiss my ass,' in stark look at White House dealmaking
Pet death logistics
Book: Wind and Truth (Stormlight Archive #5)
Movie: My Life as a Dog
Movie: The Blue Caftan
European stocks set to open lower as Trump refuses to lift Strait of Hormuz blockade
Analysis: Warsh emerges from a difficult hearing with his Fed 'regime-change' plan intact
Trump says 'I'll remember' companies that don’t seek tariff refunds