Talk:Databases - Revision history

Ned Scott: Ned Scott moved page Talk:XBMC databases to Talk:Databases

2014-12-04T08:23:33Z

Ned Scott moved page Talk:XBMC databases to Talk:Databases

← Older revision		Revision as of 08:23, 4 December 2014
(No difference)

Ned Scott: /* What to do if views are missing? */

2013-05-29T23:16:48Z

What to do if views are missing?

← Older revision		Revision as of 23:16, 29 May 2013
Line 48:		Line 48:

	[[User:SkyLined\|SkyLined]] 05:28, 29 May 2013 (EDT)		[[User:SkyLined\|SkyLined]] 05:28, 29 May 2013 (EDT)

			::I believe it's a known bug in XBMC in regards to MySQL 5.6. Until it's fixed, we've advised users to just use MySQL 5.5. -- [[User:Ned Scott\|Ned Scott]] 19:16, 29 May 2013 (EDT)

>SkyLined: /* What to do if views are missing? */ add note about moview/tv shows working just fine.

2013-05-29T09:29:41Z

What to do if views are missing?: add note about moview/tv shows working just fine.

← Older revision		Revision as of 09:29, 29 May 2013
Line 28:		Line 28:
	== What to do if views are missing? ==		== What to do if views are missing? ==

	I've added my music files and scanned them using content scrapers. I'm using MySQL 5.6 to synchronize my libraries, and I've checked that the database does contain the information I would expect after scraping from my files. However, XBMC does not display my music library, only my files. Looking at the log, I see these error that could explain this problem:		I've added my music files and scanned them using content scrapers. I'm using MySQL 5.6 to synchronize my libraries, and I've checked that the database does contain the information I would expect after scraping from my files. However, XBMC does not display my music library, only my files. The movie and TV show libraries work absolutely fine. Looking at the log, I see these error that could explain this problem:

	<pre>		<pre>

>SkyLined: /* What to do if views are missing? */ new section

2013-05-29T09:28:53Z

What to do if views are missing?: new section

← Older revision		Revision as of 09:28, 29 May 2013
Line 25:		Line 25:
	update files set playcount = '1', lastplayed = '2013-03-30 17:55:55' where idFile in (select idFile From movieview where playcount is null and strPath like '%A_alreadyViewed%')		update files set playcount = '1', lastplayed = '2013-03-30 17:55:55' where idFile in (select idFile From movieview where playcount is null and strPath like '%A_alreadyViewed%')
	</syntaxhighlight>		</syntaxhighlight>

			== What to do if views are missing? ==

			I've added my music files and scanned them using content scrapers. I'm using MySQL 5.6 to synchronize my libraries, and I've checked that the database does contain the information I would expect after scraping from my files. However, XBMC does not display my music library, only my files. Looking at the log, I see these error that could explain this problem:

			<pre>
			02:44:00 T:3132 ERROR: SQL: The table does not exist
			Query: SELECT albumview.* FROM albumview WHERE albumview.strAlbum <> ''
			02:44:00 T:3132 ERROR: CMusicDatabase::GetAlbumsByWhere () failed
			02:44:00 T:3132 ERROR: SQL: The table does not exist
			Query: SELECT artistview.* FROM artistview WHERE (artistview.idArtist IN (SELECT song_artist.idArtist FROM song_artist) OR artistview.idArtist IN (SELECT album_artist.idArtist FROM album_artist)) and artistview.strArtist != '' and artistview.idArtist <> 1
			02:44:00 T:3132 ERROR: CMusicDatabase::GetArtistsByWhere failed
			02:44:00 T:3132 ERROR: SQL: The table does not exist
			Query: SELECT songview.* FROM songview WHERE ((CAST(songview.iTimesPlayed as DECIMAL(5,1)) < 1))
			02:44:00 T:3132 ERROR: CMusicDatabase::GetSongsByWhere() failed
			</pre>
			Looking at the database, it shows that there are no views at all in the mymusic32 database. It seems XBMC has failed to create them. The myvideos75 database does have views.

			Should I expect XBMC to notice these views are missing and try to create them on startup? If so, what errors might I look for in my log to explain why this fails - I can't see anything that might be related? If not, is there a way to force it to do so, so I can try to interpret the errors in the log?

			If all else fails, can I create these views from a command line manually? What sql commands would do the trick?

			[[User:SkyLined\|SkyLined]] 05:28, 29 May 2013 (EDT)

>TiloWiki: /* Example for update on Watched */

2013-04-01T05:02:55Z

Example for update on Watched

← Older revision		Revision as of 05:02, 1 April 2013
Line 15:		Line 15:
	==Example for update on Watched==		==Example for update on Watched==
	* [[User:TiloWiki\|TiloWiki]] 20:25, 31 March 2013 (EDT)		* [[User:TiloWiki\|TiloWiki]] 20:25, 31 March 2013 (EDT)
	* Here a simple example to update the watched flag based on a folder		* Here a simple example to update the watched flag based on a folder path of the movie/TV show
			** I couldn’t update with the movieview (DB view) therefore I used the "where .. in (Select ..."
			* With slight modification you can use this to set watched for movies added before date X.
	<syntaxhighlight lang="SQL">		<syntaxhighlight lang="SQL">
	--Check with this SQL		--Check with this SQL

>TiloWiki at 00:25, 1 April 2013

2013-04-01T00:25:53Z

← Older revision		Revision as of 00:25, 1 April 2013
Line 13:		Line 13:
	MyVideos75		MyVideos75
	* tvshowlinkepisode - This table links TV shows (series) to episodes.		* tvshowlinkepisode - This table links TV shows (series) to episodes.
			==Example for update on Watched==
			* [[User:TiloWiki\|TiloWiki]] 20:25, 31 March 2013 (EDT)
			* Here a simple example to update the watched flag based on a folder
			<syntaxhighlight lang="SQL">
			--Check with this SQL
			select * from files where idFile in (select idFile From movieview where playcount is null and strPath like '%A_alreadyViewed%')

			--Update with this SQL
			update files set playcount = '1', lastplayed = '2013-03-30 17:55:55' where idFile in (select idFile From movieview where playcount is null and strPath like '%A_alreadyViewed%')
			</syntaxhighlight>

>Mshorts at 13:57, 23 March 2013

2013-03-23T13:57:35Z

← Older revision		Revision as of 13:57, 23 March 2013
Line 4:		Line 4:

	These don't exist in MyMusic32 or MyVideos75, but will need confirmation as to whether or not they will be in the future:		These don't exist in MyMusic32 or MyVideos75, but will need confirmation as to whether or not they will be in the future:
			MyMusic32:
	* exartistablum - Links artists to albums		* exartistablum - Links artists to albums
	* exartistsong - Links artists to songs		* exartistsong - Links artists to songs
	* exgenrealbum - Links genres to albums		* exgenrealbum - Links genres to albums
	* exgenresong - Links genres to songs		* exgenresong - Links genres to songs
			* thumb

			MyVideos75
			* tvshowlinkepisode - This table links TV shows (series) to episodes.

>Mshorts: /* TO-DO (what needs to be added to this database article) */

2013-03-23T13:52:07Z

TO-DO (what needs to be added to this database article)

← Older revision		Revision as of 13:52, 23 March 2013
Line 2:		Line 2:
	* The layout, etc. will be explained in more detail here later.		* The layout, etc. will be explained in more detail here later.
	* Need to add music database information		* Need to add music database information

			These don't exist in MyMusic32 or MyVideos75, but will need confirmation as to whether or not they will be in the future:
			* exartistablum - Links artists to albums
			* exartistsong - Links artists to songs
			* exgenrealbum - Links genres to albums
			* exgenresong - Links genres to songs

Ned Scott: from main page

2011-12-06T19:30:25Z

from main page

New page

== TO-DO (what needs to be added to this database article) ==
* The layout, etc. will be explained in more detail here later.
* Need to add music database information