Difference between revisions of "Myth.rebuilddatabase.pl"

From MythTV Official Wiki
Jump to: navigation, search
(Mention deprecation and that videos not recorded by MythTV should be placed in MythVideo.)
(Point people to the removed script)
Line 1: Line 1:
 
{{Wrongtitle|myth.rebuilddatabase.pl}}
 
{{Wrongtitle|myth.rebuilddatabase.pl}}
 
{{Warning box|This script is deprecated.  Please put any videos that are not recorded by your MythTV system into [[MythVideo]].}}
 
{{Warning box|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.

Revision as of 03:19, 22 January 2017

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.