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.

[Ahed]

please where i should check to see if function is exsist

[ashish2409]

This post is deleted!

[ashish2409]

@Ahed
Please check the Database, there in the Database where we can see the tables there is another option where we can see the functions as well. when you will check the function table there we can see get_url_path_of_category.