SMF icon indicating copy to clipboard operation
SMF copied to clipboard

Published 20 hours ago • verified publisher icon SimpleMachines

Search custom index: log_search_words not built in correct collation

Open sbulen opened this issue 1 year ago • 4 comments

Description

log_search_words is built in the DB default collation, not utf8mb3_general_ci to match the rest of SMF tables.

image

Steps to reproduce

  1. Create a new DB with a default collation latin1_swedish_ci
  2. Install vanilla 2.1
  3. Build a custom search index; its collation will be latin1_swedish_ci

Environment (complete as necessary)

  • Version/Git revision: current
  • Database Type: mysql
  • Database Version: 8.0
  • PHP Version: 8.2

sbulen avatar Aug 18 '23 02:08 sbulen

should be a mysql only issue

albertlast avatar Aug 18 '23 19:08 albertlast

Yep

sbulen avatar Aug 18 '23 19:08 sbulen

Possibly unrelated. But I have a forum that is failing to upgrade to UTF-8 because of this table. I have to change the words column to varchar(80) to get the upgrade to complete.

jdarwood007 avatar Aug 19 '23 00:08 jdarwood007

@jdarwood007 - Note that there are no text columns in this table, so I think your utf8 conversion failing is due to another table.

My suspicion is your error was with log_search_subjects, and that what you saw is a dupe/alt symptom of #6405 ... Still need to properly get to mb4 (#6409 ).

sbulen avatar Nov 25 '23 20:11 sbulen