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

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

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:
Alphabet's decline happening at crucial time for stock, raises stakes for next megacap earnings
the emotionally soothing terrarium channel
Alphabet and Tesla test Wall Street's patience as AI spending overshadows growth
Trump says U.S. will hold Iran responsible for Houthi attacks after oil tankers targeted in Red Sea
Tesla misses on earnings, as free cash flow turns negative and margins slide
American Airlines stock tumbles 8% as fuel spike further postpones turnaround
Southwest Airlines' third-quarter forecast falls short as fuel bill climbs
Tesla gets price target cuts from analysts on earnings miss. What they're saying
Silo: Whatever You Do, Don't Go Home Show Only
Star Trek: Strange New Worlds: Valles Marineris