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

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

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:
Polymarket launches trading of heavily leveraged 'perps' contracts
Amazon launches GLP-1 weight loss program, promising 'fast, convenient' access
Oil edges lower after Trump extends ceasefire with Iran
Bike horn for warning oblivious pedestrians
Pet death logistics
Hormuz is just a ‘dry run’ if China and U.S. go to war in the Pacific, Singapore foreign minister warns
SpaceX says it can buy Cursor later this year for $60 billion or pay $10 billion for 'our work together'
These stocks may rip if the Iran conflict is resolved, UBS says
Japan's Nikkei 225 rises to record high as Trump extends Iran ceasefire
Apple incoming CEO John Ternus faces a defining challenge: Fixing the company's AI strategy