Contrib.social

Illegal mix of collations leads to error 500

Open on Drupal.org →
Created on 16 December 2020, over 4 years ago
Updated 13 February 2023, over 2 years ago

"Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (ascii_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=': SELECT name, value FROM {key_value_expire} WHERE expire > :now AND name IN ( :keys__0 ) AND collection = :collection; Array ( [:now] => 1608110913 [:collection] => form [:keys__0] => NS09＜s1﹥DBLʺSNGLʹNS09 ) in Drupal\Core\KeyValueStore\StorageBase->get() (line 35 of /var/www/html/core/lib/Drupal/Core/KeyValueStore/StorageBase.php)."
This issue occurs when we modify the POST request data to a form and insert some utf-8 character in form_build_id.
ParameterName: form_build_id
ParameterType: POST
Payload: NS09＜s1﹥DBLʺSNGLʹNS09
But the database uses 'utf8mb4_general_ci' collation and also all the tables in the database also has 'utf8mb4_general_ci' collation.
I could not find any table using the collation 'ascii_general_ci'

🐛 Bug report
Status

Needs work

Version

10.1 ✨

Component
Database  →

Last updated 2 days ago

  • Maintained by
  • 🇳🇱Netherlands @daffie
Created by

🇮🇳India prabha.venkatesan

Live updates comments and jobs are added and updated live.
  • Security

    It is used for security vulnerabilities which do not need a security advisory. For example, security issues in projects which do not have security advisory coverage, or forward-porting a change already disclosed in a security advisory. See Drupal’s security advisory policy for details. Be careful publicly disclosing security vulnerabilities! Use the “Report a security vulnerability” link in the project page’s sidebar. See how to report a security issue for details.

  • Needs tests

    The change is currently missing an automated test that fails when run with the original code, and succeeds when the bug has been fixed.

  • Needs issue summary update

    Issue summaries save everyone time if they are kept up-to-date. See Update issue summary task instructions.

Sign in to follow issues

Merge Requests

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Comment over 2 years ago →
    🇺🇸United States smustgrave

    This issue is being reviewed by the kind folks in Slack, #needs-review-queue-initiative. We are working to keep the size of Needs Review queue [2700+ issues] to around 400 (1 month or less), following Review a patch or merge request → as a guide.

    Appears to be a bug which will require a test case/coverage

    Also the proposed solution should be added to the issue summary, recommend using default template.

  • First commit to issue fork.
  • Comment 2 days ago →
    🇬🇷Greece dimitriskr

    I'm also getting a similar error, but on a different occasion, for example when a (malicious) request goes to /contact/Perú
    I'll try to reproduce it on a clean install and upload a failing test

    Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (ascii_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=': SELECT "name", "data" FROM "config" WHERE "collection" = :collection AND "name" IN ( :names__0 ); Array ( [:collection] => [:names__0] => contact.form.Perú ) in Drupal\Core\Config\DatabaseStorage->readMultiple() (line 111 of web/core/lib/Drupal/Core/Config/DatabaseStorage.php).
  • Merge request !12266Draft: Resolve #3188740 "Illegal mix of" → (Open) created by dimitriskr
  • Pipeline finished with Failed
    2 days ago
    Total: 247s
    #509367
  • Comment 2 days ago →
    🇬🇷Greece dimitriskr
  • Comment 2 days ago →
    🇬🇷Greece dimitriskr
  • Pipeline finished with Failed
    2 days ago
    Total: 644s
    #509374
  • Comment 2 days ago →
    🇬🇷Greece dimitriskr
contrib.social Blog FAQ Discussions
Production build 0.71.5 2024