Myth.rebuilddatabase.pl

From MythTV Official Wiki
Revision as of 03:19, 22 January 2017 by NigelPearson (talk | contribs) (Point people to the removed script)

Jump to: navigation, search

Important.png Note: The correct title of this article is myth.rebuilddatabase.pl. It appears incorrectly here due to technical restrictions.

Warning.png Warning: This script is deprecated. Please put any videos that are not recorded by your MythTV system into MythVideo.

Once upon a time, Greg Froese wrote a script to re-insert recordings that might have gone missing due to database corruption, et c.

For a while, it even lived in the MythTV source tree, under contrib/recovery, then contrib/maintenance. It was removed before 0.24.

There is an old copy in Myth.rebuilddb.pl, but against recent MythTV versions, it does something like:

 DBD::mysql::st execute failed: Field 'season' doesn't have a default value at ./myth.rebuilddb.pl line 424, <STDIN> line 8.
 Could not execute (insert into recorded (chanid, starttime, endtime, title, subtitle, description, hostname, basename, progstart, progend, storagegroup, recgroup) values ((?), (?), (?), (?), (?), (?), (?), (?), (?), (?), (?), (?)))


Nigel will try to fix this.