Project

General

Profile

Actions
Copy link

Bug #8058

closed

Databases with utf8mb4 character set do not give queue counting in myamiweb LOI

Added by Anchi Cheng over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Anchi Cheng
Category:
-
Target version:
Appion/Leginon 3.5
Start date:
09/27/2019
Due date:
% Done:

0%

Estimated time:
Affected Version:
Appion/Leginon 3.4
Show in known bugs:
No
Workaround:

Description

OpenSUSE Leap 15, for example installs mysql server with such default. It makes all tables in such collation and causes an error in sql query involving

CONVERT(_utf8 string latin1) COLLATE latin1_swedish_ci
Actions
Copy link
 #1

Updated by Anchi Cheng over 4 years ago

The revision removes the convertion. Should be o.k. if the character set used in the database is consistent, even if it might sort a bit differently.

Actions
Copy link
 #2

Updated by Anchi Cheng over 4 years ago

  • Status changed from Assigned to Closed

tested by user

Actions
Copy link

Also available in: Atom PDF