Opened 13 years ago
Closed 13 years ago
Last modified 13 years ago
#9108 closed defect (Fixed)
Restore script mythconverg_restore.pl selects incorrect collation
Reported by: | Owned by: | sphery | |
---|---|---|---|
Priority: | minor | Milestone: | 0.23-fixes |
Component: | Contributed Scripts & Apps | Version: | 0.23.1 |
Severity: | low | Keywords: | Restore mythconverf_restore.pl |
Cc: | Ticket locked: | no |
Description
When used for a full restore of a Myth database that was originally created using Fedora instructions with character set latin1 with collation latin1_swedish_ci results in errors creating temporary tables for mythfilldatabase and unsuccessful schedule download.
The mythconverg_restore.pl script sets default collate to latin1_general_ci which results in the following error from mythfilldatabase creating temporary table in the database to build the schedule:
QMYSQL3: Unable to execute query Database error was: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
The fix was to change the database default collate back to latin1_swedish_ci with:
mysql> alter database mythconverg default character set latin1 default collate latin1_swedish_ci
Change History (7)
comment:1 Changed 13 years ago by
Component: | MythTV - Mythfilldatabase → Contributed Scripts & Apps |
---|---|
Milestone: | unknown → 0.24 |
Owner: | changed from stuartm to sphery |
Status: | new → assigned |
comment:2 Changed 13 years ago by
Status: | assigned → infoneeded |
---|
comment:3 Changed 13 years ago by
Milestone: | 0.24 → 0.23-fixes |
---|---|
Status: | infoneeded → assigned |
Version: | Unspecified → 0.23.1 |
comment:4 Changed 13 years ago by
Resolution: | → Fixed |
---|---|
Status: | assigned → closed |
The default collation for 0.22+ should be utf8.
Can you tell us which version you are using?