image categories error 1305 bagisto 1.1.2

[cmpengineers]

Hello

i'm trying to add image for categories but it give me this error

QLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION drovapp.get_url_path_of_category does not exist (SQL: update `categories` set `image` = category/10/5haI3yfbuV5VofTKMToz6wIHkx7GmwknP8Y2fa5M.jpeg, `categories`.`updated_at` = 2020-12-19 10:11:39 where `id` = 10)

***i already switched my database collation utf8_unicode_ci

still giving me same error***

I'm using bagisto 1.1.2
MySQL 5.7
PHP 7.3

regards

[devansh-webkul]

Hi @cmpengineers,

There are some triggers in DB which calls the function i.e. get_url_path_of_category. In your case, it is not in the db, please check the database.