検索でエラーが出る

2019年1月11日 at 13:05

サイト内検索をしたくて、検索ブロックを追加したのですが、エラーが出てしまいます。
どうすれば良いでしょうか?

エラーメッセージ
An exception occurred while executing 'SELECT p.cID FROM Pages p LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID WHERE ((psi.cName LIKE ?) OR (psi.cDescription LIKE ?) OR (psi.content LIKE ?) OR (ak_meta_title LIKE ?) OR (ak_meta_description LIKE ?) OR (ak_meta_keywords LIKE ?) OR (ak_header_extra_content LIKE ?) OR (ak_exclude_sitemapxml LIKE ?) OR (ak_exclude_nav LIKE ?) OR (ak_exclude_page_list LIKE ?) OR (ak_exclude_search_index LIKE ?) OR (ak_tags LIKE ?) OR (ak_thumbnail LIKE ?) OR (ak_exclude_subpages_from_nav LIKE ?) OR (ak_eventname LIKE ?) OR (ak_job_posting_department LIKE ?) OR (ak_job_location LIKE ?) OR (ak_event_topic LIKE ?) OR (ak_area LIKE ?) OR (ak_event_date LIKE ?) OR (ak_kikan LIKE ?) OR (ak_blog_entry_topics LIKE ?) OR (ak_project_topics LIKE ?) OR (ak_project_client LIKE ?) OR (ak_project_tasks LIKE ?) OR (ak_project_skills LIKE ?)) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cvIsApproved = 1) AND (p.cIsActive = ?) AND (p.cIsSystemPage = ?) LIMIT 1000' with params ["%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", "%\u4f1d\u7d71\u91ce\u83dc%", true, false]: SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'like'

サーバー:CPI
PC:Windows10

# concrete5 Version
Core Version - 5.7.5.13
Version Installed - 5.7.5.13
Database Version - 20160615000000

# concrete5 Packages
ABC Auto Reply forms (1.0.4), Page List+ (1.3.4)

タグ: