MySQL error after making changes to component parameters, why directory collapses?

Question

MySQL

Good day everyone. There is a site on Bitrix, I deployed its backup on a local computer for tests.
Aspro online store is connected, the whole site is made on the basis of its template.
I make small changes to the component parameters, namely, I change the field, the number of displayed offers from 10 to any other number, apply them, and the entire catalog collapses, the error is below:
In general, I make any changes to the component parameters and everything collapses.

[Bitrix\Main\DB\SqlQueryException] 
Mysql query error: (1406) Data too long for column 'PARAMETERS' at row 1 (400)
INSERT INTO `b_component_params`(`SITE_ID`, `COMPONENT_NAME`, `TEMPLATE_NAME`, `REAL_PATH`, `SEF_MODE`, `SEF_FOLDER`, `START_CHAR`, `END_CHAR`, `PARAMETERS`) VALUES ('s1', 'bitrix:catalog', 'main', '/catalog/index.php', 'Y', '/catalog/', 94, 80268, 'a:229:{s:11:\"IBLOCK_TYPE\";s:19:\"aspro_mshop_catalog\";s:9:\"IBLOCK_ID\";s:2:\"18\";s:18:\"HIDE_NOT_AVAILABLE\";s:1:\"L\";s:10:\"BASKET_URL\";s:8:\"/basket/
 ...... Сократил......
SE_GIFTS_SECTION\";s:1:\"Y\";s:30:\"USE_GIFTS_MAIN_PR_SECTION_LIST\";s:1:\"Y\";s:31:\"GIFTS_DETAIL_PAGE_ELEMENT_COUNT\";s:1:\"4\";s:29:\"GIFTS_DETAIL_HIDE_BLOCK_TITLE\";s:1:\"N\";s:24:\"GIFTS_DETAIL_BLOCK_TITLE\";s:47:\"Выберите один из подарков\";s:28:\"GIFTS_DETAIL_TEXT_LABEL_GIFT\";s:14:\"Подарок\";s:37:\"GIFTS_SECTION_LIST_PAGE_ELEMENT_COUNT\";s:1:\"4\";s:35:\"GIFTS_SECTION_LIST_HIDE_BLOCK_TITLE\";s:1:\"N\";s:30:\"GIFTS_SECTION_LIST_BLOCK_TITLE\";s:58:\"Подарки к товарам этого раздела\";s:34:\"GIFTS_SECTION_LIST_TEXT_LABEL_GIFT\";s:14:\"Подарок\";s:27:\"GIFTS_SHOW_DISCOUNT_PERCENT\";s:1:\"Y\";s:20:\"GIFTS_SHOW_OLD_PRICE\";s:1:\"Y\";s:15:\"GIFTS_SHOW_NAME\";s:1:\"Y\";s:16:\"GIFTS_SHOW_IMAGE\";s:1:\"Y\";s:18:\"GIFTS_MESS_BTN_BUY\";s:14:\"Выбрать\";s:44:\"GIFTS_MAIN_PRODUCT_DETAIL_PAGE_ELEMENT_COUNT\";s:1:\"4\";s:42:\"GIFTS_MAIN_PRODUCT_DETAIL_HIDE_BLOCK_TITLE\";s:1:\"N\";s:37:\"GIFTS_MAIN_PRODUCT_DETAIL_BLOCK_TITLE\";s:89:\"Выберите один из товаров, чтобы получить подарок\";s:21:\"OFFER_HIDE_NAME_PROPS\";s:1:\"N\";s:15:\"COMPATIBLE_MODE\";s:1:\"Y\";s:28:\"DISABLE_INIT_JS_IN_COMPONENT\";s:1:\"N\";s:30:\"DETAIL_SET_VIEWED_IN_COMPONENT\";s:1:\"N\";s:17:\"SEF_URL_TEMPLATES\";a:5:{s:8:\"sections\";s:0:\"\";s:7:\"section\";s:20:\"#SECTION_CODE_PATH#/\";s:7:\"element\";s:33:\"#SECTION_CODE_PATH#/#ELEMENT_ID#/\";s:7:\"compare\";s:32:\"compare.php?action=#ACTION_CODE#\";s:12:\"smart_filter\";s:53:\"#SECTION_CODE_PATH#/filter/#SMART_FILTER_PATH#/apply/\";}s:16:\"VARIABLE_ALIASES\";a:1:{s:7:\"compare\";a:1:{s:11:\"ACTION_CODE\";s:6:\"action\";}}}')
C:\MAMP\htdocs\bitrix\modules\main\lib\db\mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
  C:\MAMP\htdocs\bitrix\modules\main\lib\db\connection.php:330
#1: Bitrix\Main\DB\Connection->query(string, NULL)
  C:\MAMP\htdocs\bitrix\modules\main\lib\db\connection.php:379
#2: Bitrix\Main\DB\Connection->queryExecute(string)
  C:\MAMP\htdocs\bitrix\modules\main\lib\db\connection.php:454
#3: Bitrix\Main\DB\Connection->add(string, array, string)
  C:\MAMP\htdocs\bitrix\modules\main\lib\orm\data\datamanager.php:798
#4: Bitrix\Main\ORM\Data\DataManager::add(array)
  C:\MAMP\htdocs\bitrix\modules\main\lib\urlrewriter.php:437
#5: Bitrix\Main\UrlRewriter::reindexFile(string, string, string)
  C:\MAMP\htdocs\bitrix\modules\main\classes\general\main.php:1125
#6: CAllMain::OnChangeFileComponent(string, string)
  C:\MAMP\htdocs\bitrix\modules\main\classes\general\module.php:490
#7: ExecuteModuleEventEx(array, array)
  C:\MAMP\htdocs\bitrix\modules\main\classes\general\main.php:2147
#8: CAllMain->SaveFileContent(string, string)
  C:\MAMP\htdocs\bitrix\modules\main\public\component_props2.php:194
#9: require(string)
  C:\MAMP\htdocs\bitrix\admin\component_props.php:1

Answer 1

Check/Increase the length of the PARAMETERS field in the b_component_params table.
Looks like the entry won't fit.