I'm having a couple of problems that I think are database related. Here's the more straightforward of the two.

I can run mythfilldatabase just fine; I don't see any obvious errors when it runs. However, my MythWeb status page says:



Note lack of started on and ended on times and the next run year of 1970.

MythTV wiki says there should be fields in the Settings table called mythfilldatabaseLastRunStart, mythfilldatabaseLastRunEnd, and mythfilldatabaseLastRunStatus. I don't see any of those fields (using Webmin), let alone values there, which would certainly explain my status page.

Should those fields be there? Do you have those fields? And if they should be there, since I don't have them, what can I do to repair the database structure? Is it easier to just do a reinstall than try to repair manually?

Thank you in advance for any help for a very nagging problem.

Yes.

The fix_settings.sh script is a new utility which allows you to easily query and update the mythconverg settings table from the command line. You can get it here: http://www.knoppmythwiki.org/index.php?binary=internal%3A%2F%2Faf43c6b75dbf876a763069c369e1da22.bin

Use "fix_settings.sh -h" to see the available options.

The script confirms that I don't have the appropriate fields.

1. As far as I can tell, the script won't let me ADD IN the appropriate fields, correct? I only see an option for removing an entry.

2. I suspect I'm missing other fields I don't know about. Is there any way to confirm if the appropriate fields are there and repair the database manually?

3. If there's no easy way to fix things manually, I'm guessing an KnoppMyth auto-upgrade might do so. Do I have to worry about backing up and restoring my current incomplete database?

1) Letting you update or add things easily was the very first thing it did. Dumping the values was a convenience that only came later. The usage message and examples show you how:

You can use the -m option if the settings need to be machine specific, but these aren't. Using my earlier values:


2) Possibly. Use the -l option and compare it against the settings in "/usr/local/share/knoppmyth/KnoppMyth.sql". You can use the insert statements from that to add back anything that is missing.

3) Auto Upgrade involves restoring from a backup of your database which means you would get back the same incomplete state. There are tricks for doing partial restores but that's more complicated than extracting the appropriate insert statements from KnoppMyth.sql and piping them into mysql. If you search for "mysql" "mythconverg" and "KnoppMyth.sql" you should find example commands.