Collation Error When Searching

  • Resolved slwg

    (@slwg)


    1 year, 3 months ago

    I have a table that functions properly, except that I cannot search it. When I try to search, I get the following error:

    DataTables warning: table id=pretty_membership_v21 - Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation 'like'

    ‘pretty_membership_v2’ is the view I’m displaying, and ‘utf8mb4_general_ci’ is the default collation of the database. I’m guessing that the search is creating a temporary table with the db’s default collation instead of WordPress’ default, which seems to be ‘utf8mb4_unicode_520_ci’.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    1 year, 3 months ago

    Could you provide a public URL to your table as well as the create table statement?

    If you would like to share this information privately, please use the contact form on the plugin website.

    Thread Starter slwg

    (@slwg)

    1 year, 3 months ago

    The table is not on a public area of the site, unfortunately. I might be able to create a user for you, though if it becomes a roadblock.

    Which table specifically do you want the create statement for? The table in the error, ‘pretty_membership_v21’, is not one we created. My assumption is that it’s auto-created for search purposes.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    1 year, 3 months ago

    We do create temporary tables, but only for validation purposes. Searches are performed on tables, views, and custom queries. Looks like it is something else.

    Can you send us an export of the Data Table and the database table? The database table just needs to contain a few rows for testing purposes. You can use the contact page on the plugin website to send your files in private.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Collation Error When Searching’ is closed to new replies.