Add new category throw error
Megalight last edited by Megalight
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
Vaishali Agarwal last edited by
please follow the solution added here
ket-c last edited by
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
satty last edited by
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.