Handle databases that have auto increments other than 1

[mdabbs]

This patch adds a method to retrieve the RecGroupID from the database instead of assuming that the enumerated values match the auto-increments from the DB.

For DBs that have auto-increments of something other than 1, this will provide the correct ID as it was assigned by the DB.

[mdabbs]

Patch to provide ability to get RecGroupIDs form the DB instead of the enumeration

[Peter Bennett]

Before I can do anything about implementing this I need the name and email address of author of the code change to use in the github commit. I have the email address, but I do not know your name.

[mdabbs]

Author name: Mike Dabbs

[Peter Bennett]

My feelings on this

• It likely affects very few users.
• The proposed change adds database accesses.
• It is possible that some users have decided to update the database and change the name of their default group to something else. The proposed change would clobber them.

I recommend a simple change rather in dbcheck.cpp to insert the special groups with the correct ids in the first place, regardless to the auto increment value. This should have been done at the start and this problem would never have happened.

For those who already have the wrong values, run this:

update recgroups set recgroupid = 1 where recgroup = 'Default';
update recorded set recgroupid = 1 where recgroup = 'Default';

Repeat for the other two special group names.

[Peter Bennett <pbennett@…>]

In da558ca5f/mythtv:

Error: Processor CommitTicketReference failed

GIT backend not available

[Peter Bennett <pbennett@…>]

In 5cde0578d8/mythtv:

Error: Processor CommitTicketReference failed

GIT backend not available

[Peter Bennett <pbennett@…>]

In 7668cc59ab/mythtv:

Error: Processor CommitTicketReference failed

GIT backend not available

[Peter Bennett <pbennett@…>]

In bf8956a98/mythtv:

Error: Processor CommitTicketReference failed

GIT backend not available

[Peter Bennett]

I have updated the title of the bug to reflect the problem that it being fixed. Closing the bug because it has been fixed, in a different way from the original description.