cancel
Showing results for 
Search instead for 
Did you mean: 

Something went wrong while saving the category.

SOLVED

Something went wrong while saving the category.

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)"} []

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Something went wrong while saving the category.

@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
Problem solved? Click Kudos and "Accept as Solution".
200+ Magento 2 Extensions for Enhanced Shopping Experience.

View solution in original post

3 REPLIES 3

Re: Something went wrong while saving the category.

@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
Problem solved? Click Kudos and "Accept as Solution".
200+ Magento 2 Extensions for Enhanced Shopping Experience.

View solution in original post

Re: Something went wrong while saving the category.

Yes - its working fine thanks.

Re: Something went wrong while saving the category.

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.