Multiple setting definitions in mythconverg.settings
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mythbuntu |
Won't Fix
|
Undecided
|
Unassigned |
Bug Description
I've noticed some settings are getting duplicated in the settings table.
While most have the same setting, some do not. (SecurityPin, TruncateDeletes
I noticed this when auto-enabling a user job (since I can't find the option in settings????)
This is what happens when tables don't have a primary key...
SELECT Count(*) As Number, value,GROUP_
FROM settings
GROUP BY value,hostname
HAVING Number > 1
returns
Number value GROUP_CONCAT(data)
2 BackendServerIP 127.0.0.1,127.0.0.1
2 BackendServerPort 6543,6543
2 BackendStatusPort 6544,6544
2 DisableFirewire
2 JobAllowCommFlag 1,1
2 JobAllowTranscode 1,1
2 JobAllowUserJob1 1,1
2 JobAllowUserJob2 0,0
2 JobAllowUserJob3 0,0
2 JobAllowUserJob4 0,0
2 JobQueueCheckFr
2 JobQueueCPU 1,1
2 JobQueueMaxSimu
2 JobQueueWindowEnd 23:59,23:59
2 JobQueueWindowStart 00:00,00:00
2 MiscStatusScript ,
2 MythFillFixProg
2 SecurityPin 0000,
2 TruncateDeletes
We really do appreciate you opening this ticket to help improve Mythbuntu, but it needs to be closed for a number of reasons. The biggest one is that upstream believes this to be fixed in the latest version. Could you please verify if this issue still exists in the latest version?
Please do not let the closing of this ticket dissuade you from opening a new ticket if this (or any other) problem occurs with the newer versions.