Add new category throw error
SQLSTATE: Syntax error or access violation: 1305 FUNCTION megaligh_admin.get_url_path_of_category does not exist (SQL: update
updated_at= 2021-02-08 14:15:11 where
mysql 8.0.22 charset is utf8mb4_unicode_ci,.
I change charset to utf8_unicode_ci, but get this error
change all collation of table and its fields of categories , category_filterable_attributes and category_translations to utf8_general_ci
because all the collation of the three tables are not the same that is why you get that error
Try this one.
Note:- Always take DB backup before changing in DB and making changes in setting/config or other in admin panel.
Check function present in DB or Not
show create FUNCTION get_url_path_of_category;
If not, execute sql manually .
*Actually it is present in DB when we export DB,but don't know why not executed during migration.
Then change collation for all tables and columns
Its work for me.
Hope its works for others.