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

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

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:
Here are the 2 big things we're watching in the stock market in the week ahead
Amazon Prime Day 2026 is in June. Get a $150 Amazon gift card and extra rewards with the right credit card
Major crypto bill slated for May 14 Senate Banking Committee vote
How to take control of the AI data center boom and built it into your own home in the future
Michael Burry says the market today feels like 'the last months of the 1999-2000 bubble'
Is a dedicated circuit needed for smallish refrigerator?
The Terror: The Devil in Silver: November in My Soul Books Included
SEC delay on prediction markets ETFs echoes a long-fought bitcoin fund battle
Bank of America says stocks like Apple have plenty of upside following earnings
Why one of the nation's largest auto lenders isn't worried about high vehicle prices or 'forever loans'