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

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

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:
Apple's elevation of silicon head Johny Srouji signals sprint to build in-house chips for all devices
United Airlines slashes 2026 forecast as fuel costs surge
Jim Cramer says these stocks show why you need to trade on fundamentals, not fear
Amazon launches GLP-1 weight loss program, promising 'fast, convenient' access
Gates Foundation reviewing Jeffrey Epstein ties, will slash 20% of staff, WSJ reports
Is it okay to leave the toilet seat up in a shared office space?
Big Mistakes: Big Mistakes
Judge dismisses Kash Patel's defamation lawsuit over claim he frequented 'nightclubs'
Tim Cook turned Apple into a $4 trillion juggernaut by not trying to be Steve Jobs
Trump says 'I'll remember' companies that don’t seek tariff refunds