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

Bagisto

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

General error: 1267 Illegal mix of collations

Installing Bagisto
3
11
1.7k
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.
  • danieldino
    danieldino last edited by 9 Mar 2023, 18:11

    I want to add categories and I have this error?

    SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
    update categories set _lft = case when _lft >= 14 then _lft+2 else _lft end, _rgt = case when _rgt >= 14 then _rgt+2 else _rgt end where (_lft >= 14 or _rgt >= 14)

    1 Reply Last reply Reply Quote 0
    • sanjay-webkul
      sanjay-webkul last edited by 13 Mar 2023, 07:17

      Hi there,
      Please change your database collation with utf8mb4_unicode_ci

      1 Reply Last reply Reply Quote 0
      • danieldino
        danieldino last edited by 14 Mar 2023, 08:38

        @sanjay-webkul said in General error: 1267 Illegal mix of collations:

        de_ci

        I have in the database utf8mb4_unicode_ci

        1 Reply Last reply Reply Quote 0
        • sanjay-webkul
          sanjay-webkul last edited by 14 Mar 2023, 13:20

          Which version of Bagisto are you using?

          1 Reply Last reply Reply Quote 0
          • danieldino
            danieldino last edited by 14 Mar 2023, 14:54

            bagisto: 1.4.5
            addons: livestream , marketplace vendor
            php:8.1

            1 Reply Last reply Reply Quote 0
            • danieldino
              danieldino last edited by 16 Mar 2023, 13:33

              ok, problem

              problem solved

              i have next one it is in marketplace

              when i go to the dealer

              Attempt to read property "id" on null (View: /var/www/html/bagisto/packages/Webkul/Marketplace/src/Resources/views/shop/velocity/sellers/account/catalog/products/accordians/categories.blade.php) (View: /var/www/html/bagisto/packages/Webkul/Marketplace/src/Resources/views/shop/velocity/sellers/account/catalog/products/accordians/categories.blade.php)

              1 Reply Last reply Reply Quote 0
              • 12 days later
              • danieldino
                danieldino last edited by 28 Mar 2023, 17:03

                hi,

                I install new bagisto , only shop , a have same problem

                SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='

                update
                categories
                set
                _lft = case
                when _lft between 0 and 0 then _lft + 1
                when _lft between 0 and 1 then _lft -1
                else _lft
                end,
                _rgt = case
                when _rgt between 0 and 0 then _rgt + 1
                when _rgt between 0 and 1 then _rgt -1
                else _rgt
                end
                where
                (
                _lft between 0 and 1
                or _rgt between 0 and 1
                )

                1 Reply Last reply Reply Quote 0
                • danieldino
                  danieldino last edited by 29 Mar 2023, 06:32

                  works as I changed to

                  utf8mb4_general_ci;

                  1 Reply Last reply Reply Quote 0
                  • 29 days later
                  • danieldino
                    danieldino last edited by 27 Apr 2023, 13:52

                    hi,

                    I install bagisto shop 1.5 , a have problem

                    look the screen
                    error1.png

                    I don't see any tab

                    database set to

                    'charset' => 'utf8mb4',
                    'collation' => 'utf8mb4_general_ci',

                    i change on utf8mb4_unicode_ci

                    no changes ?

                    I've run out of ideas

                    1 Reply Last reply Reply Quote 0
                    • danieldino
                      danieldino last edited by 27 Apr 2023, 14:02

                      error2.png

                      1 Reply Last reply Reply Quote 0
                      • A
                        Amitk-Webkul last edited by 27 Apr 2023, 14:26

                        Hi there,
                        Can you please share the steps which you are following for installing the Bagisto?

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