I get the following error when I try to run this:



Does anyone know what is going on here? I am running R5A26.

Well, either MySQL isn't running or 'mythpoint' isn't your hostname...

_________________
cesman

When the source is open, the possibilities are endless!

I tried checking both of those.

I logged in to MySQL. It is working fine.

I tried using the command-line parameters to set both "host" and "dbhost" to the IP adresses. I also tried running it with the user and pass for "root".

weird, eh...

Red5, did you figure this out yet?

I am having the exact same problem with R5A30.2. The backend and MySQL are definitely running, the hostname is correct and resolves to 127.0.0.1, etc... I'm not sure what else to try.

_________________
mnorton.com | orangebuffalo.ca | tkc5.ca

hi all
to clear my database i used:
mysql> delete from videometadata; #without the *
and it worked !!!

TilTNimpuS,

I don't want to *clear* the database, I want to *rebuild* it.

_________________
mnorton.com | orangebuffalo.ca | tkc5.ca

I ran into the same problem. From the knoppmyth wiki, I ran:

myth.rebuilddatabase.pl --dbhost=localhost

http://www.knoppmythwiki.org/index.php? ... storeHowTo

This worked, and allowed me to type in the names and descriptions of all the orphans on my computer.

At the end of this process, all info on commericial cutting is lost, but you can still skip f/b in time while watching. Haven't tried burning yet.

My friend just hit the RESTORE button in Mythtv and his database reverted back a month and he thus had orphaned mpg files on his hard drive that he couldn't access.

I just tried this script on my friend's R5C7 KnoppMyth machine - same machine specs as mine.

myth.rebuilddatabase.pl --dbhost=localhost

It gives me the following feedback but does nothing:


I looked at the script and it seems to be looking for .nuv files. The newer revisions of Mythtv record to mpg files rather than nuv files. So is this script useless now?

Does anyone have a modification of the script that works with the current KnoppMyth versions?

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner

In KnoppMyth R5C7, use the following command line to call the script:

Then, the script will look for orphan mpg files - critical for newer Mythtv versions.

I just did this and it added a bunch of errored recordings to the database, then I was able to delete them from the harddrive.

I also found a newer version of this script on the mythtv site, but I'm not sure if it's compatible with Knoppmyth R5C7 or not:
http://cvs.mythtv.org/trac/browser/trunk/mythtv/contrib/myth.rebuilddatabase.pl?rev=10047

Enjoy!
Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner

libtime-format-perl_1.00-1_all.deb is needed.

once that is installed (doesnt have any nasty dependencies)

http://cvs.mythtv.org/trac/browser/trun ... ?rev=10047

seems to run fine on RC57, and is much improved.

How do you update/install libtime-format-perl_1.00-1_all.deb

Thanks,
esurfer

Search for "apt-get". Also note that you don't want to do this naively or you may end up having to reinstall the whole system. There are instructions on the wiki for making sure you're pointed to the stable repositories, and other hints floating around here to make sure you don't hose yourself doing this.