Major issue happened after database crash (1 Viewer)

[trillex]

Heya,

I booted up my mediacenter today and saw that something had decided to wipe my entire database of series. Big deal, I thought. It's just all the tagged thing that's lost.

I then try to import once more and I'm struck with these errors. I have absolutely no idea what they mean, other than that something is terribly wrong.

 

[trillex]

I've tried to delete and recreate the database but the errors keep on coming. Anyone got an idea?

 

[luksmann]

Just had the same problem! TVSeries would show all those errors and although it found all my series it didn't show any episodes any more!

This fixed it for me:

Physically delete the TVSeries database, located in your %appdata%/Team Mediaportal/Database folder (I'm on ubuntu right now, so maybe the folder structure is somehow different)
Delete TVSeries.dll from your MediaPortal/Plugins/Windows folder

Download TVSeries 2.0 from Media Portal homepage and put the TVSeries.dll from the zip file into the Plugins/Windows directory

Reconfigure TVSeries

This did the trick for me, TVSeries is working just fine right now

 

[trillex]

Was afraid I'd have to reinstall it. Would be nice to know a cause, though.

 

[CaptSonic]

Same with my plugin

I delete physically the database (the path luksmann writes is right), but I didn't "reinstall" the .dll.
It has function quite well.

The cause for the crash is, I think, the use of the latest svn of MP, because my Moving Pictures database was also corrupt.

 

[trillex]

Alright, my database now wiped itself again. This is getting rather annoying :|

 

[BobMysterios]

I had this happen to me, where I was just getting #TVSeries.DESCRIPTION and things like that on the front end. Being a database guy all day/everyday I figured how hard can it be.

I snagged this tool SQLite Database Browser and then exported my entire TVSeries DB to a sql file. I then deleted my database (i had a backup copy). I then opened up TVSeries config and set things up (mostly). This was to get a DB in place (since I had deleted mine).

I closed TVSeries Config and using the above tool reimported my export sql file into my shiny new (mostly empty) TV Series DB. Fixed it right up.

fast forward a few months - I install RC3 today - wiped it clean for me. So considerate.

I think the hardest thing are the regex - if you've got handy ones that work back those up - everything can just be redownloaded.

Good luck.

 

[trillex]

I'm just wondering why it started happening. I know my mediacenter isn't being treated very nicely (Being turned off by family members without actually waiting for windows and mediaportal to close) and some of my files are a bit messy with various charset but it still shouldn't just randomly crash the DB or fill it with gibberish.

I should just make a little batch script that backs it up every hour or so - since it's a lot of files that suddenly looses it's tagged flag and it's quite a bastard to remember what episode you got to in big shows like Naruto, The Simpsons or others.

 

[BobMysterios]

I agree completely.

DB corruption can happen for any number of reasons most of which you've touched on. If you do an hourly backup, make sure to keep 12+ backups and maybe only copy every few hours. If not you'll overwrite your good database in a scenario such as:

You watch a program before bed - the DB corrupts at 3 am - you wake up go about your business - get home from work and try to watch a program - but the DB is corrupt. All of your copies are corrupt too. You're sad.

Just something to think about.