XSQL: Run on a schedule

[jitterjames]

It appears to be this query:

select distinct idSong,strTitle,strArtists from songview where strArtists!=""

I can run it on the synology box, it has 25k records

I'm assuming that the queries are running sequentially:

xbmcArtists
xbmcAlbums
xbmcSongs
xbmcGenres
XbmcSongsByArtist

I see results after the error message for the first 4 tablles but not the 5th

That makes sense.  I think that is probably the most demanding query.  Yes, they should run from top to bottom, one after the other.

[macrho]

that worked though I did notice that I don't have a TV database, strangely in the XBMC wiki, it doesn't mention it. Digging around I found that you can add it to your advancedsettings.xml:

    <tvdatabase>
       <type>mysql</type>
       <host>x.x.x.x</host>
       <port>3306</port>
       <user>xbmc</user>
       <pass>xbmc</pass>
       <name>xbmc_tv</name>
    </tvdatabase>

You can do the same with EPG

But I haven't the foggiest idea on how you populate the tvdatabase - any ideas?

[jitterjames]

I have no idea.  I don't have any kind of PVR hardware.  You should be able to find what you need on the XBMC wki and or forum though if you are using PVR stuff.  Those extra queries were created with the help of Mace.

If you want to get rid of them, I think you need to edit your options.xml in the plugin folder.  Does not seem to be possible to delete rows at the moment in the plugin window. 

[macrho]

Unfortunately, the XBMC wiki didn't have any information on it.
I rebooted the XBMC box a couple of times and it finally populated the tv database
Changed the database name and now I'm rolling!

now to auto update the xMySQL - very cool stuff