• 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
687
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.
  • 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
                      11 out of 11
                      • First post
                        11/11
                        Last post