script.recentlyadded failed
#16
Please help the ignorant here.... How do I update in xbmc?
Reply
#17
My XBMC seems to auto-update addons, Though it has not updated the recentlyadded script yet.

othervise,
1. use the addon browser, where you will find it depends on your skin.
2. download one of the nightly builds
3. Manually update addon
Reply
#18
Does it work for you?

I get the following errors:

Code:
11:44:16 T:3077752704 M:1502826496   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: select * from movieview where playCount isnull order by idMovie desc limit 8
11:44:16 T:3077752704 M:1502826496   ERROR: GetArbitraryQuery failed
11:44:16 T:3077752704 M:1502826496   DEBUG: HttpApi Start command: QueryVideoDatabase  paras: QueryVideoDatabase; select * from episodeview where playCount isnull order by idepisode desc limit 8
11:44:16 T:3077752704 M:1502826496   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: select * from episodeview where playCount isnull order by idepisode desc limit 8
11:44:16 T:3077752704 M:1502826496   ERROR: GetArbitraryQuery failed
11:44:16 T:3077752704 M:1502826496   DEBUG: HttpApi Start command: QueryMusicDatabase  paras: QueryMusicDatabase; select idAlbum from albumview order by idAlbum desc limit 8
11:44:17 T:3077752704 M:1502826496   DEBUG: HttpApi Start command: QueryMusicDatabase  paras: QueryMusicDatabase; select songview.* from songview where (idAlbum = 205 and lastplayed isnull) limit 1
11:44:17 T:3077752704 M:1502826496   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: select songview.* from songview where (idAlbum = 205 and lastplayed isnull) limit 1
11:44:17 T:3077752704 M:1502826496   ERROR: GetArbitraryQuery(select songview.* from songview where (idAlbum = 205 and lastplayed isnull) limit 1) failed
11:44:17 T:3077752704 M:1502826496   DEBUG: HttpApi Start command: QueryMusicDatabase  paras: QueryMusicDatabase; select songview.* from songview where (idAlbum = 204 and lastplayed isnull) limit 1
11:44:17 T:3077752704 M:1502826496   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: select songview.* from songview where (idAlbum = 204 and lastplayed isnull) limit 1
11:44:17 T:3077752704 M:1502826496   ERROR: GetArbitraryQuery(select songview.* from songview where (idAlbum = 204 and lastplayed isnull) limit 1) failed
11:44:17 T:3077752704 M:1502826496   DEBUG: HttpApi Start command: QueryMusicDatabase  paras: QueryMusicDatabase; select songview.* from songview where (idAlbum = 203 and lastplayed isnull) limit 1
11:44:17 T:3077752704 M:1502826496   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: select songview.* from songview where (idAlbum = 203 and lastplayed isnull) limit 1
11:44:17 T:3077752704 M:1502826496   ERROR: GetArbitraryQuery(select songview.* from songview where (idAlbum = 203 and lastplayed isnull) limit 1) failed
11:44:17 T:3077752704 M:1502826496   DEBUG: HttpApi Start command: QueryMusicDatabase  paras: QueryMusicDatabase; select songview.* from songview where (idAlbum = 202 and lastplayed isnull) limit 1
11:44:18 T:3077752704 M:1502826496   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: select songview.* from songview where (idAlbum = 202 and lastplayed isnull) limit 1
11:44:18 T:3077752704 M:1502826496   ERROR: GetArbitraryQuery(select songview.* from songview where (idAlbum = 202 and lastplayed isnull) limit 1) failed
11:44:18 T:3077752704 M:1502826496   DEBUG: HttpApi Start command: QueryMusicDatabase  paras: QueryMusicDatabase; select songview.* from songview where (idAlbum = 200 and lastplayed isnull) limit 1
11:44:18 T:3077752704 M:1502826496   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: select songview.* from songview where (idAlbum = 200 and lastplayed isnull) limit 1
11:44:18 T:3077752704 M:1502826496   ERROR: GetArbitraryQuery(select songview.* from songview where (idAlbum = 200 and lastplayed isnull) limit 1) failed
11:44:18 T:3077752704 M:1502826496   DEBUG: HttpApi Start command: QueryMusicDatabase  paras: QueryMusicDatabase; select songview.* from songview where (idAlbum = 199 and lastplayed isnull) limit 1
11:44:18 T:3077752704 M:1502826496   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: select songview.* from songview where (idAlbum = 199 and lastplayed isnull) limit 1
11:44:18 T:3077752704 M:1502826496   ERROR: GetArbitraryQuery(select songview.* from songview where (idAlbum = 199 and lastplayed isnull) limit 1) failed
11:44:18 T:3077752704 M:1502826496   DEBUG: HttpApi Start command: QueryMusicDatabase  paras: QueryMusicDatabase; select songview.* from songview where (idAlbum = 198 and lastplayed isnull) limit 1
11:44:18 T:3077752704 M:1502838784   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: select songview.* from songview where (idAlbum = 198 and lastplayed isnull) limit 1
11:44:18 T:3077752704 M:1502838784   ERROR: GetArbitraryQuery(select songview.* from songview where (idAlbum = 198 and lastplayed isnull) limit 1) failed
11:44:18 T:3077752704 M:1502838784   DEBUG: HttpApi Start command: QueryMusicDatabase  paras: QueryMusicDatabase; select songview.* from songview where (idAlbum = 197 and lastplayed isnull) limit 1
11:44:19 T:3077752704 M:1502838784   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: select songview.* from songview where (idAlbum = 197 and lastplayed isnull) limit 1
11:44:19 T:3077752704 M:1502838784   ERROR: GetArbitraryQuery(select songview.* from songview where (idAlbum = 197 and lastplayed isnull) limit 1) failed
11:44:19 T:2849348464 M:1502838784    INFO: Scriptresult: Success

As a result it doesn't load the recently added movies/tvshows/music and creates a big slow down. (5 seconds that makes the system very slow)

I'm using Aeon and a Nightly version but not the last one. (will this make the difference? a newer nightly?)
Reply
#19
jackthegroove Wrote:Does it work for you?

Don't know yet, still using the test script from Amet. Will try it later
Reply
#20
Well I updated, and it now gives the Library totals/watched for both movies and tvs, but I still get the blank images/listings for both movies and tv shows....
Reply
#21
I am still getting the script.recentlyadded failed message when opening XBMC (latest dharma beta 1 and the latest version of aeon) or going back to the main menu. Does the 1.0.8 version of the recentlyadded script fix this problem? I am using a MySQL DB.
Reply
#22
Hey all - im having the same issue, MYSQL, blank recently added with AEON. Noticed there hasn't been any posts here for a while - was a fix found?
Reply
#23
I'm still getting this error too. Any update?

Edit:

Check for an updated recentlyadded.py file here
http://forum.xbmc.org/showpost.php?p=506...stcount=36
Reply

Logout Mark Read Team Forum Stats Members Help
script.recentlyadded failed0