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

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

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:
OPEC+ debates making oil output hike amid Iran war paralysis, sources say
Zohran Mamdani and the business exodus? New York's office real estate market is up under new mayor
Sánchez to Trump: Spain won’t ‘applaud those who set the world on fire just because they then show up with a bucket’
We're trimming our stake in an AI winner to take advantage of great prices
Trump praises Hungary PM Viktor Orbán after Vance calls him at Budapest rally
AWS teams working around the clock to keep Middle East services up after drone strikes, CEO says
Book: There is No Antimemetics Division
Monarch: Legacy of Monsters: Requiem
Oil prices plunge after Iran agrees to safe passage through Strait of Hormuz during ceasefire
AI's next bottleneck: Why even the best chips made in the U.S. take a round trip to Taiwan