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

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

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:
Jim Cramer says these 2 cybersecurity stocks can keep climbing as AI threats grow
The best retirement planning tools for every stage of your journey
Hayden Panettiere, who starred in ‘Heroes’ and ‘Nashville,’ dies at 36
Cool lil stickers
How to make my apartment feel less like an oven?
Meta faces ‘astronomical’ consequences as legal fight reaches critical moment in California
Supreme Court again rejects Trump bid to overturn E. Jean Carroll verdict
'Don't get too comfortable': Wall Street’s ‘fear gauge’ hits 2026 low — here's why it's unlikely to last
Oil prices little changed as Iran rules out interim deal extension, threatens to escalate conflict
What the results of a Connecticut congressional primary race may mean for Social Security