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

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

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:
Polymarket launches trading of heavily leveraged 'perps' contracts
Gates Foundation reviewing Jeffrey Epstein ties, will slash 20% of staff, WSJ reports
Alaska Air pulls forecast as Iran-linked fuel surge hits margins
Pet death logistics
Movie: Roommates
Book: Purgatorio: Canto 14
Movie: The Mosquito Coast
Hormuz is just a ‘dry run’ if China and U.S. go to war in the Pacific, Singapore foreign minister warns
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