[mots]

Really? I only get script failed - recentlyadded.py in both alaska and fusion :O

[ppic]

Really? I only get script failed - recentlyadded.py in both alaska and fusion :O

what do you except us to do if you don't provide minimal informations like a debug log?

[buges]

Has anybody got a working sql query for recently added singles??

[ekim232]

I was wondering if it would be possible to add the ability to pull the tv show thumb for latest episodes?

[mfwilli]

Can anyone confirm this working for the latest AppleTV2 release? I have it enabled in settings in Confluence but it does not appear...

[blacklist]

Really? I only get script failed - recentlyadded.py in both alaska and fusion :O

Works just fine here with MySQL.

[ppic]

it's working on any db you have as it uses http api.

[pecinko]

Could Addons and Programs be added to script, if there's a way?

[XmemphistoX]

I just changed my database to mysql and i am also getting the script error in aeon.

[jayhawk785]

Here's what I'm getting, I'm not 100% sure what build I'm on--I loaded the xbmc unstable ppa and upgraded to get a fix I needed for DD.

Code:

18:56:12 T:3055757120 M:1809944576   DEBUG: HttpApi Start command: QueryVideoDatabase  paras: [not recorded]
18:56:12 T:2573454192 M:1816801280    INFO: -->Python script returned the following error<--
18:56:12 T:2573454192 M:1816801280   ERROR: Error Type: exceptions.ValueError
18:56:12 T:2573454192 M:1816801280   ERROR: Error Contents: invalid literal for int(): /Volumes/DroboBaggins/TV/Wipeout
/
18:56:12 T:2573454192 M:1816801280   ERROR: Traceback (most recent call last):
                                              File "/home/meh/.xbmc/addons/script.recentlyadded/RecentlyAdded.py", li
ne 350, in ?
                                                Main()
                                              File "/home/meh/.xbmc/addons/script.recentlyadded/RecentlyAdded.py", li
ne 106, in __init__
                                                self._fetch_totals()
                                              File "/home/meh/.xbmc/addons/script.recentlyadded/RecentlyAdded.py", li
ne 153, in _fetch_totals
                                                tvshows_totals[ 1 ] += int( fields[ 24 ] ) # number of episodes
                                            ValueError: invalid literal for int(): /Volumes/DroboBaggins/TV/Wipeout/
18:56:12 T:2573454192 M:1816801280    INFO: -->End of Python script error report<--

DB is MYSQL and it's rebuilt with latin1/collation fixes from the mysql thread. It was getting recently added errors before that as well.

Hope this info helps--let me know if I can provide anything else.

[amet]

Here's what I'm getting, I'm not 100% sure what build I'm on--I loaded the xbmc unstable ppa and upgraded to get a fix I needed for DD.

Code:

18:56:12 T:3055757120 M:1809944576   DEBUG: HttpApi Start command: QueryVideoDatabase  paras: [not recorded]
18:56:12 T:2573454192 M:1816801280    INFO: -->Python script returned the following error<--
18:56:12 T:2573454192 M:1816801280   ERROR: Error Type: exceptions.ValueError
18:56:12 T:2573454192 M:1816801280   ERROR: Error Contents: invalid literal for int(): /Volumes/DroboBaggins/TV/Wipeout
/
18:56:12 T:2573454192 M:1816801280   ERROR: Traceback (most recent call last):
                                              File "/home/meh/.xbmc/addons/script.recentlyadded/RecentlyAdded.py", li
ne 350, in ?
                                                Main()
                                              File "/home/meh/.xbmc/addons/script.recentlyadded/RecentlyAdded.py", li
ne 106, in __init__
                                                self._fetch_totals()
                                              File "/home/meh/.xbmc/addons/script.recentlyadded/RecentlyAdded.py", li
ne 153, in _fetch_totals
                                                tvshows_totals[ 1 ] += int( fields[ 24 ] ) # number of episodes
                                            ValueError: invalid literal for int(): /Volumes/DroboBaggins/TV/Wipeout/
18:56:12 T:2573454192 M:1816801280    INFO: -->End of Python script error report<--

DB is MYSQL and it's rebuilt with latin1/collation fixes from the mysql thread. It was getting recently added errors before that as well.

Hope this info helps--let me know if I can provide anything else.

if you paste the whole log we can see what build you are on, try this one and let me know

[ppic]

i've already seen that error, that was an error in db where season / episode don't have number .

[rg192]

I'm also having issues with recently added script.

Hope this info below help solve the problem, Thanks for the help

21:14:52 T:151793664 M:137138176 DEBUG: ADDON: cpluff: 'Plug-in script.recentlyadded has been installed.'
21:14:59 T:151793664 M:107327488 DEBUG: ExecuteXBMCAction : Translating XBMC.RunScript(script.recentlyadded,limit=10&totals=True&albums=True&unplayed=True)
21:14:59 T:151793664 M:107327488 DEBUG: ExecuteXBMCAction : To XBMC.RunScript(script.recentlyadded,limit=10&totals=True&albums=True&unplayed=True)
21:15:05 T:190476288 M: 97480704 DEBUG: Process - The source file to load is /Applications/XBMC.frappliance/XBMCData/XBMCHome/addons/script.recentlyadded/RecentlyAdded.py
21:15:05 T:190476288 M: 97480704 DEBUG: Process - Setting the Python path to /Applications/XBMC.frappliance/XBMCData/XBMCHome/addons/script.recentlyadded:/var/mobile/Library/Preferences/XBMC/addons/script.module.simplejson/lib:/var/mobile/Library/Preferences/XBMC/addons/script.module.beautifulsoup/lib:/Applications/XBMC.frappliance/XBMCData/XBMCHome/addons/script.module.pil/lib:/var/mobile/Library/Preferences/XBMC/addons/script.module.mechanize/lib:/Applications/XBMC.frappliance/XBMCData/XBMCHome/addons/script.module.pysqlite/lib:/Applications/XBMC.frappliance/Frameworks/usr:/Applications/XBMC.frappliance/Frameworks/usr/lib/python26.zip:/Applications/XBMC.frappliance/Frameworks/usr/lib/python2.6/:/Applications/XBMC.frappliance/Frameworks/usr/lib/python2.6/plat-darwin:/Applications/XBMC.frappliance/Frameworks/usr/lib/python2.6/plat-mac:/Applications/XBMC.frappliance/Frameworks/usr/lib/python2.6/plat-mac/lib-scriptpackages:/Applications/XBMC.frappliance/Frameworks/usr/lib/python2.6/lib-tk:/Applications/XBMC.frappliance/Frameworks/usr/lib/python2.6/lib-old:/Applications/XBMC.frappliance/Frameworks/usr/lib/python2.6/lib-dynload
21:15:05 T:190476288 M: 97480704 DEBUG: Process - Entering source directory /Applications/XBMC.frappliance/XBMCData/XBMCHome/addons/script.recentlyadded
21:15:20 T:190476288 M: 96972800 ERROR: Traceback (most recent call last):
File "/Applications/XBMC.frappliance/XBMCData/XBMCHome/addons/script.recentlyadded/RecentlyAdded.py", line 286, in <module>
File "/Applications/XBMC.frappliance/XBMCData/XBMCHome/addons/script.recentlyadded/RecentlyAdded.py", line 97, in __init__
File "/Applications/XBMC.frappliance/XBMCData/XBMCHome/addons/script.recentlyadded/RecentlyAdded.py", line 138, in _fetch_totals

[jayhawk785]

Hey Guys,

I ended up rolling back to 10.1 - it had the fix i needed with dd5.1

Bit of a pain rolling back 3 machines and then blowing out the db multiple times--but whatever. Unfortunately that was the only snippet of the log I had. I could reproduce it in multiple skins--and I had dropped/readded my db twice. I believe all my episodes had season/number but i could be wrong. I can check wipeout which was last reference in the log if you think there's something to the problem.

[pieh]

Here's what I'm getting, I'm not 100% sure what build I'm on--I loaded the xbmc unstable ppa and upgraded to get a fix I needed for DD.

Code:

18:56:12 T:3055757120 M:1809944576   DEBUG: HttpApi Start command: QueryVideoDatabase  paras: [not recorded]
18:56:12 T:2573454192 M:1816801280    INFO: -->Python script returned the following error<--
18:56:12 T:2573454192 M:1816801280   ERROR: Error Type: exceptions.ValueError
18:56:12 T:2573454192 M:1816801280   ERROR: Error Contents: invalid literal for int(): /Volumes/DroboBaggins/TV/Wipeout
/
18:56:12 T:2573454192 M:1816801280   ERROR: Traceback (most recent call last):
                                              File "/home/meh/.xbmc/addons/script.recentlyadded/RecentlyAdded.py", li
ne 350, in ?
                                                Main()
                                              File "/home/meh/.xbmc/addons/script.recentlyadded/RecentlyAdded.py", li
ne 106, in __init__
                                                self._fetch_totals()
                                              File "/home/meh/.xbmc/addons/script.recentlyadded/RecentlyAdded.py", li
ne 153, in _fetch_totals
                                                tvshows_totals[ 1 ] += int( fields[ 24 ] ) # number of episodes
                                            ValueError: invalid literal for int(): /Volumes/DroboBaggins/TV/Wipeout/
18:56:12 T:2573454192 M:1816801280    INFO: -->End of Python script error report<--

DB is MYSQL and it's rebuilt with latin1/collation fixes from the mysql thread. It was getting recently added errors before that as well.

Hope this info helps--let me know if I can provide anything else.

i had this problem using Latest git - I did quick fix:
changed

Code:

    tvshows_totals[ 1 ] += int( fields[ 24 ] ) # number of episodes
            tvshows_totals[ 2 ] += int( fields[ 25 ] ) # watched?
            tvshows_totals[ 3 ] += int( fields[ 26 ] ) # number of episodes watched

to

Code:

    tvshows_totals[ 1 ] += int( fields[ 25 ] ) # number of episodes
            tvshows_totals[ 2 ] += int( fields[ 26 ] ) # watched?
            tvshows_totals[ 3 ] += int( fields[ 27 ] ) # number of episodes watched

this is caused by this "SELECT tvshow.*, path.strPath" - I guess it could be changed to provide only values from specified columns instead of entire table - right?

PS. other things doesn't work in latest git too (paths and thumbs for latest movies/episodes f.e.) - some column was added to database ( https://github.com/xbmc/xbmc/commit/606f...tabase.cpp )