Unknown error occured when trying to timeshift (1 Viewer)

[Spragleknas]

Suddenly* MP-server won't timeshift any channels.

From log I get:

Gentle.Common.GentleException: show columns from `program` ---> MySql.Data.MySqlClient.MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired

IOW - DB is crapped? Can I repair or de I need to replace/delete?

*(well, after a windo error when I wswas away - this happens now and then but is normally fixed with a reboot.)

 

[HomeY]

IOW - DB is crapped? Can I repair or de I need to replace/delete?

Let's try repair first:

1. Open a command line by clicking start, type "cmd", hit return/enter.
2. Type cd C:\Program Files\MySQL\MySQL Server 5.1\bin (this should be the path to the bin subdirectory within your MySQL install folder) and hit return/enter.
3. Type mysqlcheck mptvdb --auto-repair -e -u root -p, and hit return/enter.
4. A password prompt should appear. The default password is MediaPortal (case sensitive).

Double check the path, if you're on 5.6 you'll have to adjust it.

 

[Spragleknas]

FRIGGING GREAT! Need to do a batchscript for this. Btw, is this in the wiki? (If so - sorry for missing it. If not - let's add it!).

 

[HomeY]

http://wiki.team-mediaportal.com/1_...Troubleshooting/TV/Repairing_database_(MySQL)

 

[Spragleknas]

Would be nice to have a button for it in config

 

[HomeY]

Would be nice to have a button for it in config

A button in TV Server Config that runs the script you mean?
I think we should assume these problems normally never happen
But if they do >> Wiki contains the info

 

[mm1352000]

I think we should assume these problems normally never happen

...or if they happen, they happen significantly less often. That was the point of the DB upgrade in MP 1.6...

 

[Spragleknas]

Ah... Yes... Starting to loose control over the development . I've had my fair screwed DB's - be it MovPic, TVSereies or TV .