Bagisto Forum

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

    General error: 1267 Illegal mix of collations

    Installing Bagisto
    3
    11
    632
    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

      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

        Hi there,
        Please change your database collation with utf8mb4_unicode_ci

        1 Reply Last reply Reply Quote 0
        • danieldino
          danieldino last edited by

          @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

            Which version of Bagisto are you using?

            1 Reply Last reply Reply Quote 0
            • danieldino
              danieldino last edited by

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

              1 Reply Last reply Reply Quote 0
              • danieldino
                danieldino last edited by

                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
                • danieldino
                  danieldino last edited by

                  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

                    works as I changed to

                    utf8mb4_general_ci;

                    1 Reply Last reply Reply Quote 0
                    • danieldino
                      danieldino last edited by

                      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

                        error2.png

                        1 Reply Last reply Reply Quote 0
                        • A
                          Amitk-Webkul last edited by

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

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