Advertisement
Guest User

Untitled

a guest
Jul 25th, 2018
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.36 KB | None | 0 0
  1. 10:39:42.209 T:5004   ERROR: SQL: [MyMusic72] Undefined MySQL error: Code (1305)
  2.                                             Query: SELECT a1.*, album_artist.idArtist AS idArtist, artist.strArtist AS strArtist FROM (SELECT albumview.idAlbum, strAlbum, strReview, strGenres, strThemes, strMoods, strStyles, strType, strLabel, fRating, iYear, iTimesPlayed, art.url AS thumbnail FROM albumview LEFT JOIN art ON art.media_id = idAlbum AND art.media_type = 'album' AND art.TYPE = 'thumb' WHERE albumview.strReleaseType = 'album' ORDER BY RANDOM() LIMIT 20) AS a1 JOIN album_artist ON album_artist.idAlbum = a1.idAlbum JOIN artist ON artist.idArtist = album_artist.idArtist GROUP BY a1.idAlbum, album_artist.idArtist ORDER BY a1.idAlbum, album_artist.iOrder
  3. 10:39:42.210 T:5004   ERROR: CMusicDatabase::GetAlbumsByWhereJSON failed
  4. 10:39:42.369 T:5004   ERROR: SQL: [MyMusic72] Undefined MySQL error: Code (1305)
  5.                                             Query: SELECT a1.*, art.art_id AS idArt, art.TYPE AS artType, art.url AS artURL FROM (SELECT artist.idArtist, strArtist, strInstruments, strBiography, strGenres, strMoods, strStyles, strYearsActive, strBorn, strFormed, strDied, strDisbanded FROM artist  WHERE (EXISTS (SELECT 1 FROM album_artist WHERE album_artist.idArtist = artist.idArtist)) AND (artist.strArtist != '') ORDER BY RANDOM() LIMIT 20) AS a1 LEFT JOIN art ON art.media_id = a1.idArtist AND art.media_type = 'artist' GROUP BY a1.idArtist, art.art_id ORDER BY a1.idArtist, arttype
  6. 10:39:42.370 T:5004   ERROR: CMusicDatabase::GetArtistsByWhereJSON failed
  7. 10:39:44.241 T:5004   ERROR: SQL: [MyMusic72] Undefined MySQL error: Code (1305)
  8.                                             Query: SELECT sv.*, song_artist.idArtist AS idArtist, songartist.strArtist AS strArtist FROM (SELECT song.idSong, strTitle, song.iYear, iTimesPlayed, rating, CONCAT(path.strPath, strFilename) AS strPathFile, album.strAlbum AS strAlbum FROM song JOIN album ON album.idAlbum = song.idAlbum JOIN path ON path.idPath = song.idPath WHERE ((CAST(song.iTimesPlayed AS DECIMAL(5,1)) < 1)) ORDER BY RANDOM() LIMIT 20) AS sv JOIN song_artist ON song_artist.idSong = sv.idSong AND song_artist.idRole = 1 JOIN artist AS songartist ON songartist.idArtist = song_artist.idArtist GROUP BY sv.idSong, song_artist.idArtist ORDER BY sv.idSong, song_artist.iOrder
  9. 10:39:44.242 T:5004   ERROR: CMusicDatabase::GetSongsByWhereJSON failed
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement