2014-06-11, 15:54
since i am still having issues that some playlist work and some freeze PTVL i tried to put a limit.
in the comedy playlist i put a 100 limit. (this is from the actual playlist PTVL created:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<smartplaylist type="movies">
<name>Comedy 1</name>
<match>one</match>
<rule field="genre" operator="is">
<value>קומדיה</value>
</rule>
<rule field="genre" operator="is">
<value>comedy</value>
</rule>
<limit>100</limit>
<order direction="descending">random</order>
</smartplaylist>
but when it populated it ignored the limit and got to 1054 where it froze.
in the log there is nothing on this:
16:48:57 T:140363071215360 NOTICE: script.pseudotv.live PseudoTV Live /storage/.xbmc/addons/script.pseudotv.live-master 0.4.3a
16:48:57 T:140363071215360 NOTICE: script.pseudotv.live-Globals: System Caching Enabled
16:48:57 T:140363071215360 NOTICE: metahandler: Initializing MetaHandlers version: 2.6.0
16:48:57 T:140363071215360 NOTICE: metahandler: Loading sqlite3 as DB engine version: 3.7.17
16:48:57 T:140363071215360 NOTICE: metahandler: Looking up TMDB config cache values
16:48:57 T:140363071215360 NOTICE: metahandler: Cache still valid, setting values
16:48:57 T:140363071215360 NOTICE: metahandler: No SQLite rows requiring update
16:48:58 T:140363071215360 NOTICE: script.pseudotv.live-ChannelList: Donor Import Failed, Disabling Donor FeaturesNo module named Donor
16:48:58 T:140363071215360 NOTICE: Previous line repeats 1 times.
16:48:58 T:140363071215360 NOTICE: Requesting
16:48:58 T:140363071215360 NOTICE: http://www.google-analytics.com/__utm.gi...1837865445
16:48:58 T:140363071215360 NOTICE: Pragma: no-cache
Expires: Wed, 19 Apr 2000 11:43:00 GMT
Last-Modified: Wed, 21 Jan 2004 19:51:30 GMT
X-Content-Type-Options: nosniff
Content-Type: image/gif
Date: Fri, 06 Jun 2014 15:20:16 GMT
Server: Golfe2
Content-Length: 35
Age: 426522
Cache-Control: private, no-cache, no-cache=Set-Cookie, proxy-revalidate
Alternate-Protocol: 80:quic
Connection: close
16:48:58 T:140363071215360 WARNING: Skin has invalid include: dialogeffect
16:48:58 T:140363071215360 ERROR: EXCEPTION: Non-Existent Control 120
16:49:53 T:140363071215360 NOTICE: getMovie Cache
16:53:13 T:140364094633728 ERROR: SQL: The table does not exist
Query: SELECT albumview.* FROM albumview WHERE albumview.strAlbum <> ''
16:53:13 T:140364094633728 ERROR: GetAlbumsByWhere () failed
16:53:13 T:140364094633728 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
16:53:13 T:140364094633728 ERROR: GetArtistsByWhere failed
16:53:13 T:140364094633728 ERROR: SQL: The table does not exist
Query: SELECT songview.* FROM songview WHERE ((CAST(songview.iTimesPlayed as DECIMAL(5,1)) < 1))
16:53:13 T:140364094633728 ERROR: GetSongsByWhere() failed
in the comedy playlist i put a 100 limit. (this is from the actual playlist PTVL created:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<smartplaylist type="movies">
<name>Comedy 1</name>
<match>one</match>
<rule field="genre" operator="is">
<value>קומדיה</value>
</rule>
<rule field="genre" operator="is">
<value>comedy</value>
</rule>
<limit>100</limit>
<order direction="descending">random</order>
</smartplaylist>
but when it populated it ignored the limit and got to 1054 where it froze.
in the log there is nothing on this:
16:48:57 T:140363071215360 NOTICE: script.pseudotv.live PseudoTV Live /storage/.xbmc/addons/script.pseudotv.live-master 0.4.3a
16:48:57 T:140363071215360 NOTICE: script.pseudotv.live-Globals: System Caching Enabled
16:48:57 T:140363071215360 NOTICE: metahandler: Initializing MetaHandlers version: 2.6.0
16:48:57 T:140363071215360 NOTICE: metahandler: Loading sqlite3 as DB engine version: 3.7.17
16:48:57 T:140363071215360 NOTICE: metahandler: Looking up TMDB config cache values
16:48:57 T:140363071215360 NOTICE: metahandler: Cache still valid, setting values
16:48:57 T:140363071215360 NOTICE: metahandler: No SQLite rows requiring update
16:48:58 T:140363071215360 NOTICE: script.pseudotv.live-ChannelList: Donor Import Failed, Disabling Donor FeaturesNo module named Donor
16:48:58 T:140363071215360 NOTICE: Previous line repeats 1 times.
16:48:58 T:140363071215360 NOTICE: Requesting
16:48:58 T:140363071215360 NOTICE: http://www.google-analytics.com/__utm.gi...1837865445
16:48:58 T:140363071215360 NOTICE: Pragma: no-cache
Expires: Wed, 19 Apr 2000 11:43:00 GMT
Last-Modified: Wed, 21 Jan 2004 19:51:30 GMT
X-Content-Type-Options: nosniff
Content-Type: image/gif
Date: Fri, 06 Jun 2014 15:20:16 GMT
Server: Golfe2
Content-Length: 35
Age: 426522
Cache-Control: private, no-cache, no-cache=Set-Cookie, proxy-revalidate
Alternate-Protocol: 80:quic
Connection: close
16:48:58 T:140363071215360 WARNING: Skin has invalid include: dialogeffect
16:48:58 T:140363071215360 ERROR: EXCEPTION: Non-Existent Control 120
16:49:53 T:140363071215360 NOTICE: getMovie Cache
16:53:13 T:140364094633728 ERROR: SQL: The table does not exist
Query: SELECT albumview.* FROM albumview WHERE albumview.strAlbum <> ''
16:53:13 T:140364094633728 ERROR: GetAlbumsByWhere () failed
16:53:13 T:140364094633728 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
16:53:13 T:140364094633728 ERROR: GetArtistsByWhere failed
16:53:13 T:140364094633728 ERROR: SQL: The table does not exist
Query: SELECT songview.* FROM songview WHERE ((CAST(songview.iTimesPlayed as DECIMAL(5,1)) < 1))
16:53:13 T:140364094633728 ERROR: GetSongsByWhere() failed