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.