Something went wrong while saving the category.

[purvishvrif740]

Hi Team,

When I am adding the new category then I can see this line. Something went wrong while saving the category.

I have checked in env php file there is developer mode so its fine but when I have checked in exception.log then I can see following types of issue.

[2021-11-24 08:11:15] main.CRITICAL: SQLSTATE[42000]: Syntax error or access violation: 1142 TRIGGER command denied to user 'harakatv_harakatus'@'localhost' for table 'catalog_category_entity', query was: UPDATE `catalog_category_entity` SET `children_count` = children_count+1 WHERE (entity_id IN('1', '2')) {"exception":"[object] (Zend_Db_Statement_Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1142 TRIGGER command denied to user 'harakatv_harakatus'@'localhost' for table 'catalog_category_entity', query was: UPDATE `catalog_category_entity` SET `children_count` = children_count+1 WHERE (entity_id IN('1', '2')) at /home/demoharkat/public_html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:110, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1142 TRIGGER command denied to user 'harakatv_harakatus'@'localhost' for table 'catalog_category_entity' at /home/demoharkat/public_html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:91)"} []

[Sanjay Jethva · Accepted solution]

@purvishvrif740 

Please run the below command:

rm -rf var/cache/*
rm -rf var/page_cache/*
rm -rf var/generation/*
rm -rf generated

Then run the below commands:

php bin/magento setup:di:compile
php bin/magento setup:static-content:deploy -f

[purvishvrif740]

Yes - its working fine thanks.

[pandahelped78d]

Yes, I had the same issue while adding a new category for my panda helper, as well as tweakbox webs. However, utilizing super contributor responses, the problem was rectified; I also performed that commends and created a new category without any previous error commends, thankyou.