Related to Database access violation: 1305 When Creating Categories on Local

h3ck4rz

syntax error or access violation: 1305 FUNCTION mybagistostore.get_url_path_of_category does not exist (SQL: update categories set category_product_in_pwa = 1, categories.updated_at = 2021-07-25 21:16:41 where id = 2)

devansh-webkul

Hi @h3ck4rz,

Make sure this function is present in your database,
get_url_path_of_category

Ahed

this error is show to my when add new category and the function get_url_path_of_category is exsist in the database
please can help me

ashish2409

@Ahed Please check the Database, there you will be able to see tables and functions is you database.
In function you will be able to see get_url_path_of_category
and if in case the issue appears then please change the collection - utf8mb4_unicode_ci

davinderamr

@devansh-webkul said in Related to Database access violation: 1305 When Creating Categories on Local:

Make sure this function is present in your database,
get_url_path_of_category

i face the same issue. and where i find this function in database get_url_path_of_category

ashish2409

@davinderamr you can find the "get_url_path_of_category" in your Database,
Check the functions section and there you can see the details.
Please check the screenshot which I am attaching.
alt text