2012-05-10, 23:23
I am having problems upgrading from xbmc_video61 to xbmc_video64 on the latest xbmc.
I compile the latest xbmc and then run it, there is a new database xbmc_video64 made with 1 table in it, just actorlinkepisode with all the rows that the xbmc_video61 database had and xbmc fails to load.
So i tried to find a fix, i had to drop the actorlinkepisode, actorlinktvshow and actorlinkmovie tables to get the database to upgrade, but then Xbmc loads and when i get into tvshows/movies, xbmc starts using all the cpu-power.
The xbmc_video61 layout for these tables is:
After that i made a mysqldump of all databases, dropped all xbmc_video databases from the mysql-server and restarted xbmc. Now xbmc works fine, no more 100% cpu usage.
I go to the dir that holds all my series, set content to 'Tvshows' -> 'TheTVDB' and afterwards i try to get into the dir with all the series and it wont let me, when i check the xbmc-log it says:
Something is going wrong with the latest version and mysql-support it seems.
I compile the latest xbmc and then run it, there is a new database xbmc_video64 made with 1 table in it, just actorlinkepisode with all the rows that the xbmc_video61 database had and xbmc fails to load.
So i tried to find a fix, i had to drop the actorlinkepisode, actorlinktvshow and actorlinkmovie tables to get the database to upgrade, but then Xbmc loads and when i get into tvshows/movies, xbmc starts using all the cpu-power.
The xbmc_video61 layout for these tables is:
Code:
mysql> select count(*) from actorlinkepisode;
+----------+
| count(*) |
+----------+
| 70110 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from actorlinktvshow;
+----------+
| count(*) |
+----------+
| 2335 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from actorlinkmovie;
+----------+
| count(*) |
+----------+
| 5466 |
+----------+
1 row in set (0.00 sec)
mysql> desc actorlinkepisode;
+-----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+-------+
| idActor | int(11) | YES | MUL | NULL | |
| idEpisode | int(11) | YES | MUL | NULL | |
| strRole | text | YES | | NULL | |
| iOrder | int(11) | YES | | NULL | |
+-----------+---------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> desc actorlinktvshow;
+---------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| idActor | int(11) | YES | MUL | NULL | |
| idShow | int(11) | YES | MUL | NULL | |
| strRole | text | YES | | NULL | |
| iOrder | int(11) | YES | | NULL | |
+---------+---------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> desc actorlinkmovie;
+---------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| idActor | int(11) | YES | MUL | NULL | |
| idMovie | int(11) | YES | MUL | NULL | |
| strRole | text | YES | | NULL | |
| iOrder | int(11) | YES | | NULL | |
+---------+---------+------+-----+---------+-------+
4 rows in set (0.00 sec)
After that i made a mysqldump of all databases, dropped all xbmc_video databases from the mysql-server and restarted xbmc. Now xbmc works fine, no more 100% cpu usage.
I go to the dir that holds all my series, set content to 'Tvshows' -> 'TheTVDB' and afterwards i try to get into the dir with all the series and it wont let me, when i check the xbmc-log it says:
Code:
23:14:19 T:3016521536 ERROR: SQL: The table does not exist
Query: select count(1) from episodeview where strPath = 'smb://nas/series/' limit 1
23:14:19 T:3016521536 ERROR: exception in CApplication::FrameMove()
23:14:24 T:3016521536 ERROR: SQL: The table does not exist
Query: select strPath,noUpdate from path where ( strContent = 'tvshows' or idPath in (select idPath from tvshowlinkpath)) and strPath NOT like 'multipath://%' order by strPath
23:14:24 T:3016521536 ERROR: GetPaths failed
Something is going wrong with the latest version and mysql-support it seems.