2011-07-05, 21:27
i have been using the automatic update client to use the latest nightly builds, but as it turns out for some reason the builds it has been installing have not actually been nightly builds I guess as some features that require nightlies were not working.
When I downloaded an 'official' nightly build from the repo and started xbmc my home screen entries for movies and tv libraries were gone, meaning the db's were empty. This has happened before and I went to the log to investigate.
I found the following in the log:
I searched around the forums and came across a number of threads with people having the same issues. The fix that was suggessted was to drop the 'movieview' and recreate it manually.
I searched some more and was able to drop the movieview and then recreate it with the following:
I didn't get any error when I ran this. However, when I start xbmc I still get the same error and my library is empty.
After further reasearch, I peformed every step in this post (I had to drop the c23 column from each table before I started) to no avail.
Is there something I am missing?
::EDIT:: Just realized that I wasn't on the latest nightly (was previously on 6/30). I upgraded and still no luck:
When I downloaded an 'official' nightly build from the repo and started xbmc my home screen entries for movies and tv libraries were gone, meaning the db's were empty. This has happened before and I went to the log to investigate.
I found the following in the log:
Quote:15:17:29 T:160 M:1487224832 NOTICE: Attempting to update the database xbmc_video from version 51 to 53
15:17:29 T:160 M:1487212544 ERROR: SQL: Undefined MySQL error: Code (1060)
Query: ALTER TABLE movie ADD c23 text
15:17:29 T:160 M:1487187968 ERROR: Error attempting to update the database version!
15:17:29 T:160 M:1487187968 ERROR: Can't update the database xbmc_video from version 51 to 53
15:17:29 T:160 M:1487187968 ERROR: Unable to open database xbmc_video
I searched around the forums and came across a number of threads with people having the same issues. The fix that was suggessted was to drop the 'movieview' and recreate it manually.
I searched some more and was able to drop the movieview and then recreate it with the following:
Quote:CREATE ALGORITHM=UNDEFINED DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `movieview` AS select `movie`.`idMovie` AS `idMovie`,`movie`.`idFile` AS `idFile`,`movie`.`c00` AS `c00`,`movie`.`c01` AS `c01`,`movie`.`c02` AS `c02`,`movie`.`c03` AS `c03`,`movie`.`c04` AS `c04`,`movie`.`c05` AS `c05`,`movie`.`c06` AS `c06`,`movie`.`c07` AS `c07`,`movie`.`c08` AS `c08`,`movie`.`c09` AS `c09`,`movie`.`c10` AS `c10`,`movie`.`c11` AS `c11`,`movie`.`c12` AS `c12`,`movie`.`c13` AS `c13`,`movie`.`c14` AS `c14`,`movie`.`c15` AS `c15`,`movie`.`c16` AS `c16`,`movie`.`c17` AS `c17`,`movie`.`c18` AS `c18`,`movie`.`c19` AS `c19`,`movie`.`c20` AS `c20`,`movie`.`c21` AS `c21`,`movie`.`c22` AS `c22`,`movie`.`c23` AS `c23`,`files`.`strFilename` AS `strFileName`,`path`.`strPath` AS `strPath`,`files`.`playCount` AS `playCount`,`files`.`lastPlayed` AS `lastPlayed` from ((`movie` join `files` on((`files`.`idFile` = `movie`.`idFile`))) join `path` on((`path`.`idPath` = `files`.`idPath`)))
I didn't get any error when I ran this. However, when I start xbmc I still get the same error and my library is empty.
After further reasearch, I peformed every step in this post (I had to drop the c23 column from each table before I started) to no avail.
Is there something I am missing?
::EDIT:: Just realized that I wasn't on the latest nightly (was previously on 6/30). I upgraded and still no luck:
Quote:15:33:13 T:5276 M:1455435776 NOTICE: Attempting to update the database xbmc_video from version 51 to 54
15:33:13 T:5276 M:1455423488 ERROR: SQL: Undefined MySQL error: Code (1060)
Query: ALTER TABLE movie ADD c23 text
15:33:13 T:5276 M:1455407104 ERROR: Error attempting to update the database version!
15:33:13 T:5276 M:1455407104 ERROR: Can't update the database xbmc_video from version 51 to 54
15:33:13 T:5276 M:1455407104 ERROR: Unable to open database xbmc_video
