Site search db api call not working

ogallagher / tejos_textiles

An online arts journal for publishing works in a new medium

MIT License

1 stars 0 forks source link

Site search db api call not working #97

Closed ogallagher closed 2 years ago

ogallagher commented 2 years ago

site search error

ogallagher commented 2 years ago

Current search implementation in db api server is described in #16.

ogallagher commented 2 years ago

Webserver error

db: search_all [<term>]
error in db data fetch: Error: ER_CANT_AGGREGATE_2COLLATIONS: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'regexp_like'

I believe it’s an issue with the search_all procedure.

ogallagher commented 2 years ago

Fixing the search_all procedure to use an explicit charset for theregex_in arg: in regex_in varchar(128) character set utf8mb4.

ogallagher commented 2 years ago

Fixing other similar charset errors with procedure argument charsets:

[x] authenticate_person
[x] add_difficulty
[x] add_rating
[x] user_activity
[x] user_records