• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Register
  • Login
Bagisto Forum

Bagisto

  • Register
  • Login
  • Search
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups

image categories error 1305 bagisto 1.1.2

Bug Report
4
5
766
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C
    cmpengineers last edited by cmpengineers 19 Dec 2020, 10:16 19 Dec 2020, 10:16

    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

    regards

    1 Reply Last reply Reply Quote 0
    • devansh-webkul
      devansh-webkul last edited by 21 Dec 2020, 11:23

      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.

      1 Reply Last reply Reply Quote 0
      • 2 years later
      • A
        Ahed last edited by 11 Aug 2022, 10:08

        please where i should check to see if function is exsist

        ashish2409 1 Reply Last reply 12 Aug 2022, 06:48 Reply Quote 0
        • ashish2409
          ashish2409 last edited by 12 Aug 2022, 06:47

          This post is deleted!
          1 Reply Last reply Reply Quote 0
          • ashish2409
            ashish2409 @Ahed last edited by 12 Aug 2022, 06:48

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

            1 Reply Last reply Reply Quote 0
            2 out of 5
            • First post
              2/5
              Last post