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.

Log in to reply