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

Bagisto

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

Categories Addition Issues

Bug Report
2
2
127
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.
  • I
    imshibaji last edited by 24 Feb 2021, 11:00

    When I want to added a category under the root or different position. That time i faced the problem.

    SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' (SQL: update bccategories 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)).

    Please Resolved this problem in your latest version.

    1 Reply Last reply Reply Quote 0
    • V
      Vaishali Agarwal last edited by 25 Feb 2021, 05:31

      @imshibaji
      This error is coming because of database mis configuration
      kindly check the below solution, hope this work
      https://github.com/bagisto/bagisto/issues/4347#issuecomment-744276804
      https://github.com/bagisto/bagisto/issues/3790
      https://forums.bagisto.com/topic/1414/error-while-adding-categories

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