Bagisto Forum

    Bagisto

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

    Resolved - General error: 1267 Illegal mix of collations

    Installing Bagisto
    2
    2
    225
    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.
    • R
      rbiscaino last edited by

      Hi everyone, I recently had a problem creating new categories in Bagisto Admin, I got an error with Illegal Mix of Collactions and couldn't find a solution to this problem, so I dug a little deeper into the root causes and verified that this was a problem with character and grouping in my database, as there is a trigger that is executing information and concatenating data, I am using MySql 8 and to solve my problem I made the following instruction: In the my.cnf file of your Mysql insert the following code:

      [server]
           collation-server = utf8_general_ci
           init-connect='SET NAMES utf8'
           character-set-server = utf8
      

      I hope I could help, a big hug to everyone

      ashish2409 1 Reply Last reply Reply Quote 0
      • ashish2409
        ashish2409 @rbiscaino last edited by ashish2409

        @rbiscaino
        Hello there,
        May I know which version of Bagisto you are using so that we can help you.
        If you are using V1.5.0 or above kindly use DB collection utf8mb4_unicode_ci.

        Thank You.

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