Kodi Community Forum

Full Version: MySQL and party mode
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello everybody,

I have an issue I can't solve. I have tried to search various forums but I can't find an answer so I hope someone in here can point me in the right direction.

I'm using a Qnap TS-412 NAS-System with MySql to store the data and the database. Everything seems to works perfectly. The databases are created and data is populated to the databases. I have two raspberry pi's with raspbmc and one windows machine with xbmc connected and they work flawlessly.

Except for one thing which really annoys me since I used it quite often:

When I start party mode in the music section XBMC selects 10 random numbers and starts playing. So far so good, but when the first song ends and the next should be played XBMC throws an error

“Party mode aborted. Could not get songs from database.”

If I look in the Xbmc log file it says the following:

Code:
22:08:45 T:1600   ERROR: SQL: Undefined MySQL error: Code (1062)
Query: SELECT strArtists FROM albumview WHERE idAlbum=801 LIMIT 1
22:08:45 T:1600   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT strArtists FROM albumview WHERE idAlbum=801 LIMIT 1'
22:08:45 T:5196   ERROR: SQL: Undefined MySQL error: Code (126)
Query: select * from songview  WHERE songview.idSong not in (4845,10282,8524,4890,2351,391,7574,1557,2113,9691) ORDER BY RAND() LIMIT 1
22:08:45 T:5196   ERROR: CMusicDatabase::GetRandomSong(songview.idSong not in (4845,10282,8524,4890,2351,391,7574,1557,2113,9691)) failed
22:08:47 T:5196   ERROR: SQL: Undefined MySQL error: Code (126)
Query: select * from songview  WHERE songview.idSong not in (4845,10282,8524,4890,2351,391,7574,1557,2113,9691) ORDER BY RAND() LIMIT 1
22:08:47 T:5196   ERROR: CMusicDatabase::GetRandomSong(songview.idSong not in (4845,10282,8524,4890,2351,391,7574,1557,2113,9691)) failed
22:09:00 T:5196   ERROR: PARTY MODE MANAGER: Cannot get songs from database. Aborting.

I've rebuilt the database from scratch a couple of times but without succes so far. The only thing I noticed is that this error doesn't happen if there is not that many songs in the database. But as soon as the database has reached a certain size this is what happens. Now since I don't know very much about MySQL I'm totally out of ideas here.

Can anybody help me out here? Help would be really appreciated. Thanks in advance