Iam getting an error while creating cataegory

[shayaan.aqeel]

SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION miras2.get_url_path_of_category does not exist (SQL: update categories set _lft = case when _lft >= 37 then _lft+2 else _lft end, _rgt = case when _rgt >= 37 then _rgt+2 else _rgt end where (_lft >= 37 or _rgt >= 37))

[devansh-webkul]

Hi @shayaan-aqeel,

Please check this function i.e., get_url_path_of_category present or not.

[Ahed]

that the fucntion exist still you are getting the error

[ashish2409]

@Ahed
Hello Sir,
In case you are facing the issue, then please change the collection of your Database, Please use utf8mb4_unicode_ci collection and then check it gain.

[Ahed]

hello sir
i changed the collection but the issue is showing

[sanjay-webkul]

Hi there,
Please check the Database, in the database you will be able to see the functions and inside that you will be able to see the get_url_path_of_category
Please check that and also if again facing the issue please check and change the collection
use collection - utf8mb4_uniocde_ci

[shahid993]

@devansh-webkul where to check