2012-01-18, 00:26
Hello everybody,
since yesterday I am not able to brows my TV Shows anymore, it's just blank.
If I choose to browse files, I see the directories but I can't log into them.
I look at the xbmc log and saw some MySQL errors (see http://pastebin.com/2Ms37Uaz for the log file)
Then I logged into MySQL Query Browser, and saw that I can only see one database, xbmc_video, which is my old video database. xbmc_video58 and xbmc_music18 are not displayed.
I used another login, the one I use for the connection of XBMC from Windows and the AppleTV2, and I can see the xbmc_video58 and xbmc_music18 databases.
This is the first weird point, as I always was able to see al my databases with both logins.
I then ran a command, just to check:
And got:
I then launched MySQL Administrator to check the tables, here is the result :
http://pastebin.com/eryLvZvE
I don't know what happened, I have a backup of my Database from 2 weeks ago, so it is not really a problem for me, but I think I should notice it to the community.
If you need further information to investigate, just let me know it.
since yesterday I am not able to brows my TV Shows anymore, it's just blank.
If I choose to browse files, I see the directories but I can't log into them.
I look at the xbmc log and saw some MySQL errors (see http://pastebin.com/2Ms37Uaz for the log file)
Then I logged into MySQL Query Browser, and saw that I can only see one database, xbmc_video, which is my old video database. xbmc_video58 and xbmc_music18 are not displayed.
I used another login, the one I use for the connection of XBMC from Windows and the AppleTV2, and I can see the xbmc_video58 and xbmc_music18 databases.
This is the first weird point, as I always was able to see al my databases with both logins.
I then ran a command, just to check:
Code:
SELECT count(1) FROM tvshowview LIMIT 1
And got:
Quote:Table './xbmc_video58/episode' is marked as crashed and should be repaired
I then launched MySQL Administrator to check the tables, here is the result :
http://pastebin.com/eryLvZvE
I don't know what happened, I have a backup of my Database from 2 weeks ago, so it is not really a problem for me, but I think I should notice it to the community.
If you need further information to investigate, just let me know it.