Errors with MySQL 5.0
Bug #30593 reported by
kacheng
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ubuntu |
Invalid
|
Medium
|
Unassigned | ||
mythtv (Ubuntu) |
Fix Released
|
Medium
|
Unassigned | ||
Dapper |
Won't Fix
|
Undecided
|
Unassigned |
Bug Description
Mythtv problem with MySQL 5.0
MythTV does not work with MySQL 5.0 yet because one of the columns in the dd_schedule table is named "repeat" and MySQL 5.0 now uses "repeat" as a reserved word.
A mythtv-commits post at:
http://
says the solution is to rename "repeat" to "isrepeat" in the datadirect.cpp file.
Presumably this requires a rebuild of mythbackend and mythfilldatabase and an update in the repository.
An alternative solution might be to downgrade mysql-server to 4.1. However, this can't be easily done as mysql-server-5.0 is a dependency of mythtv.
Either the dependency needs to be broken, or the repositories updated.
summary: | + Mythtv problem with MySQL 5.0 |
description: | updated |
Changed in mythtv: | |
status: | New → Won't Fix |
To post a comment you must log in.
I can confirm that the MythTV 0.18 schema is incompatible with MySQL 5. If dapper will ship with MySQL 5, then the MythTV package should be upgraded to the 0.19 release.