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

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

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:
Tesla recalls 3 million vehicles in China over doorhandle safety, driver monitoring
Pentagon fires U.S. military newspaper leadership
Trump to allow import of 300,000 metric tons of ground beef without tariff
Big week coming up with PCE, Nvidia earnings and then Jackson Hole. Here's what to expect
Bitcoin surges 22% for the week as investor optimism floods back
Most Americans aren't anti-vaccine. They're uncertain — and that's a growing public health challenge
Gift ideas for a 6 year old engineer!
Stargate SG-1: Sentinel Rewatch
Ted Lasso: Richmond's Got Talent
Ray Dalio says Bessent move is sign that a debt crisis is getting closer; recommends gold and bitcoin