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

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

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:
FDA approves psoriasis pill from J&J that rivals shots Tremfya, Skyrizi
As Americans struggle with rising costs, many states’ unemployment benefits fall short, analysis finds
Disney embarks on new chapter as Josh D'Amaro takes over as CEO
Alternatives to Outlook, Gmail and AOL for a web-based Email Provider?
Social Media Poster - Auto-share your Q2A content everywhere
Top Chef: Puckerbutt
Asia markets track Wall Street losses as Iran war fuels energy worries; BOJ rate decision on deck
How China is getting everyone on OpenClaw, from gearheads to grandmas
Jim Cramer says you can still find stocks to buy on tough days in the market
These income-generating plays can yield up to 6% as the Fed holds rate steady