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

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

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:
These S&P 500 companies reporting earnings next week have momentum on their side
Jim Cramer's top 10 things to watch in the stock market Friday
China strikes conciliatory tone ahead of expected Trump-Xi meeting
How to tackle private credit’s ‘cockroaches’ as contagion fears build
Warren Buffett's Berkshire is lagging the S&P 500 by the largest gap so far this year
Here are the 3 big things we're watching in the stock market this week
Buy MSG stock because the winning New York Knicks are growing in value, Citigroup says
Melissa strengthens into a Category 4 hurricane, threatening catastrophic flooding in Jamaica, Haiti
Workers reject Boeing's latest offer after nearly three months on strike
Earnings playbook: Five 'Magnificent Seven' members are set to report in busy week