We sometimes have requests for urls with special chars in the url. This gives the following error:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation ' IN ': SELECT tag, invalidations FROM {cachetags} WHERE tag IN ( :tags__0, :tags__1, :tags__2, :tags__3, :tags__4, :tags__5, :tags__6, :tags__7, :tags__8, :tags__9, :tags__10 ); Array ( [:tags__0] => 4xx-response [:tags__1] => banner:465 [:tags__2] => block_content:1 [:tags__3] => block_content:2 [:tags__4] => config:block_list [:tags__5] => config:system.site [:tags__6] => http_response [:tags__7] => page_manager_route_name: [:tags__8] => panelizer_default:node:page:full [:tags__9] => panelizer_default:node:page:full:default [:tags__10] => social_media:/artikel/watcliëntenparticipatie )
Needs review
2.0
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
It looks like the issue is still relevant.
Here is a patch compatible with the 2.0.x branch
Hello Guys,
I have reviewed & Implemented Patch #14 on my Drupal website having version 9.5, PHP version - 8.1
Patch #14 has been implemented successfully. Can be moved to RTBC!
Please & Thank You.