Bagisto Forum

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

    After creating a new category

    Bug Report
    3
    18
    3385
    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.
    • Z
      zainawan99 last edited by

      "SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION new_bagisto.get_url_path_of_category does not exist (SQL: update categories set _lft = case when _lft >= 50 then _lft+2 else _lft end, _rgt = case when _rgt >= 50 then _rgt+2 else _rgt end where (_lft >= 50 or _rgt >= 50)) ◀"

      587015f9-c6a6-4d44-b2a4-b1f4ead5d52d-image.png

      1 Reply Last reply Reply Quote 0
      • V
        Vaishali Agarwal last edited by

        @zainawan99
        could you please mention the database environment.

        Z 1 Reply Last reply Reply Quote 0
        • Z
          zainawan99 @Vaishali Agarwal last edited by

          @Vaishali-Agarwal
          database wamp server 3.23
          mysql 8.0.21
          php 7.3

          a7ac4e2b-c34a-494b-9029-47bf2ab56941-image.png

          1 Reply Last reply Reply Quote 0
          • V
            Vaishali Agarwal last edited by

            @zainawan99
            solution is here https://forums.bagisto.com/topic/1414/error-while-adding-categories/4
            Hope this will work for you.

            Z 1 Reply Last reply Reply Quote 0
            • Z
              zainawan99 @Vaishali Agarwal last edited by

              @Vaishali-Agarwal but same issue come

              1 Reply Last reply Reply Quote 0
              • V
                Vaishali Agarwal last edited by

                @zainawan99
                could you show the database collation type ?

                Z 2 Replies Last reply Reply Quote 0
                • Z
                  zainawan99 @Vaishali Agarwal last edited by

                  @Vaishali-Agarwal said in After creating a new category:

                  collation

                  Which one

                  Z 1 Reply Last reply Reply Quote 0
                  • Z
                    zainawan99 @zainawan99 last edited by

                    @zainawan99 they have bagisto by default

                    1 Reply Last reply Reply Quote 0
                    • Z
                      zainawan99 @Vaishali Agarwal last edited by

                      @Vaishali-Agarwal b5400b94-1b0e-4fd3-b050-c27bc60d13e8-image.png

                      1 Reply Last reply Reply Quote 0
                      • V
                        Vaishali Agarwal last edited by

                        @zainawan99
                        kindly change the collation type to utf8_unicode_ci
                        from database -> Operation -> go down to the collation setting -> choose "utf8_unicode_ci" then apply to all table and column to be safe.

                        Z 1 Reply Last reply Reply Quote 0
                        • Z
                          zainawan99 @Vaishali Agarwal last edited by

                          @Vaishali-Agarwal sir, i m already try this query in database

                          1 Reply Last reply Reply Quote 0
                          • V
                            Vaishali Agarwal last edited by

                            @zainawan99
                            please try again as you may check this all over the forum query and GitHub issue, solution is same for this issue
                            https://github.com/bagisto/bagisto/issues/4175
                            https://github.com/bagisto/bagisto/issues/2562

                            Once check the above link again & change collation type utf8_unicode_ci and clear the cache using
                            php artisan config:cache

                            If still not works then let me know.

                            Z 1 Reply Last reply Reply Quote 0
                            • Z
                              zainawan99 @Vaishali Agarwal last edited by

                              @Vaishali-Agarwal i m already try this link guide lines

                              1 Reply Last reply Reply Quote 0
                              • V
                                Vaishali Agarwal last edited by

                                @zainawan99
                                kindly raise the support ticket here https://bagisto.uvdesk.com/en/customer/create-ticket/ and also provide your SSH/SFTP server details along with website URL, so we could check at our end.

                                Z 1 Reply Last reply Reply Quote 0
                                • Z
                                  zainawan99 @Vaishali Agarwal last edited by

                                  @Vaishali-Agarwal not login required?

                                  1 Reply Last reply Reply Quote 0
                                  • V
                                    Vaishali Agarwal last edited by

                                    @zainawan99
                                    you need to fill the form then your account will automatically create on the support system. You will get the account activation on the provided email.

                                    Z 1 Reply Last reply Reply Quote 0
                                    • Z
                                      zainawan99 @Vaishali Agarwal last edited by

                                      @Vaishali-Agarwal ok

                                      1 Reply Last reply Reply Quote 0
                                      • S
                                        SourabhAkash last edited by

                                        Hi,
                                        This error is because of Access problem actually, please change the mysql
                                        GRANT SYSTEM_USER ON . TO user@localhost;
                                        GRANT SUPER ON . TO user@localhost;

                                        So run above commands and check now.

                                        Regards,
                                        Sourabh Akash

                                        1 Reply Last reply Reply Quote 0
                                        • First post
                                          Last post