Recent Topics

image categories error 1305 bagisto 1.1.2

  • 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***

    Screen Shot 2020-12-19 at 1.16.32 PM.png

    I'm using bagisto 1.1.2
    MySQL 5.7
    PHP 7.3


  • 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.

  • please where i should check to see if function is exsist

  • This post is deleted!

  • @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.

Log in to reply