Wednesday, 10 January 2018

Mysql [SOLVED] ERROR 1227 (42000) at line *: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Mysql [SOLVED] ERROR 1227 (42000) at line 1080: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Either remove the DEFINER=.. statement from your sqldump file, or replace the user values with CURRENT_USER.

Like

Find
DEFINER=`olddbusername`@`localhost`

Then replace

DEFINER=`newdbusername`@`localhost`

Thanks,

Monday, 1 January 2018

When save a Category Error : A technical problem with the server created an error. Try again to continue what you were doing. If the problem persists, try again later.

Solved this problem with below command line:

php bin/magento maintenance:enable; 
php bin/magento setup:upgrade; 
php bin/magento setup:static-content:deploy -f; 
php bin/magento cache:clean; 
php bin/magento maintenance:disable

if can not solve then remove category content and save it.


Any issues please email me.

Thanks,
Kuldeep singh