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

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

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:
Ken Griffin says Citadel unwound more than 80% of risk tied to Situational Awareness portfolio
As GOP warns data centers put Ohio Senate seat at risk, Husted defends energy policy
Kalshi traders think the bitcoin rally could end the year near current levels
Bitcoin surges 22% for the week as investor optimism floods back
Book: The Lives Of The Muses: Nine Women & the Artists They Inspired
Book: Red Dragon
Stargate SG-1: Sentinel Rewatch
Movie: The Swindle
Ray Dalio says Bessent move is sign that a debt crisis is getting closer; recommends gold and bitcoin
Supreme Court allows Trump to continue White House ballroom construction for now