Opened 9 years ago

Closed 9 years ago

Last modified 9 years ago

#9108 closed defect (Fixed)

Restore script mythconverg_restore.pl selects incorrect collation

Reported by: dennismccloud@… 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 9 years ago by stuartm

Component: MythTV - MythfilldatabaseContributed Scripts & Apps
Milestone: unknown0.24
Owner: changed from stuartm to sphery
Status: newassigned

The default collation for 0.22+ should be utf8.

Can you tell us which version you are using?

comment:2 Changed 9 years ago by stuartm

Status: assignedinfoneeded

comment:3 Changed 9 years ago by sphery

Milestone: 0.240.23-fixes
Status: infoneededassigned
Version: Unspecified0.23.1

comment:4 Changed 9 years ago by sphery

Resolution: Fixed
Status: assignedclosed

(In [26856]) Fixes #9108. Don't assume that a DB upgrade will occur after a database is restored with --drop_database --create_database. This updates the DB default character set and collation after replacing an existing database rather than relying on the TV schema DB upgrade to do so.

comment:5 Changed 9 years ago by sphery

(In [26857]) Refs #9108. Update the DB default character set and collation after replacing an existing database. Backports [26856] from trunk.

comment:6 Changed 9 years ago by sphery

(In [26859]) Refs #9108. Actually change the pre-0.22 collation, which I forgot to do in [26856].

comment:7 Changed 9 years ago by sphery

(In [26860]) Refs #9108. Change the pre-0.22 collation. Backports [26859] from trunk.

Note: See TracTickets for help on using tickets.