[RELEASE] Trakt Utilities (addon for Trakt.tv usage)

  Thread Rating:
  • 7 Votes - 4.29 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
« Next Oldest | Next Newest»
cf125 Offline
Member
 Posts: 78
Joined: May 2011
Reputation: 0
2012-04-08 19:17 Post: #1151
is there a way i can manual refresh without having to turn xbmc off and back on, im running atv2 latest eden build??
find quote
touser Offline
Senior Member
 Posts: 146
Joined: Feb 2008
Reputation: 1
2012-04-08 21:34 Post: #1152
(2012-04-08 19:17)cf125 Wrote:  is there a way i can manual refresh without having to turn xbmc off and back on, im running atv2 latest eden build??

This is big for me as well, my XBMC instance only gets restarted if it crashes or there is an update.
find quote
othrayte Offline
Fan
 Posts: 452
Joined: Apr 2011
Reputation: 3
Location: Melbourne, Australia
2012-04-09 04:12 Post: #1153
(2012-04-08 18:04)Nightah Wrote:  So I recently moved to a centralized MySQL database for my XBMC setup and it seems updating collections on startup no longer is working:

Code:
01:48:08 T:9412  NOTICE: Trakt Utilities: trakt json url: /show/episode/unlibrary/48dfcb4813134da82152984e8c4f329bc8b8b46a
01:48:09 T:9412  NOTICE: Trakt Utilities: successfully updated collection: 31 episodes removed from your library
01:48:09 T:9412  NOTICE: Trakt Utilities: autostart sync seen movies
01:48:10 T:9412  NOTICE: Trakt Utilities: trakt json url: /user/library/movies/all.json/48dfcb4813134da82152984e8c4f329bc8b8b46a/nightah
01:48:12 T:9412  NOTICE: Trakt Utilities: searching local...
01:48:12 T:9412  NOTICE: Trakt Utilities: 60
01:48:12 T:9412  NOTICE: Trakt Utilities: [RawXbmcDb] Found mysqldb: 10.10.10.3:3306, myvideo60
01:48:12 T:9412   ERROR: Error Type: <class 'mysql.connector.errors.ProgrammingError'>
01:48:12 T:9412   ERROR: Error Contents: 1049: Unknown database 'myvideo60'
01:48:12 T:9412   ERROR: Traceback (most recent call last):
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\service.py", line 67, in <module>
                                                autostart()
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\service.py", line 50, in autostart
                                                syncSeenMovies(True)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\sync_update.py", line 690, in syncSeenMovies
                                                setXBMCMoviePlaycount(movies_seen[i]['imdb_id'], movies_seen[i]['plays']) # set playcount on xbmc
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\utilities.py", line 407, in setXBMCMoviePlaycount
                                                " WHERE movie.c09='%(imdb_id)s'" % {'imdb_id':xcp(imdb_id)})
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\raw_xbmc_database.py", line 15, in query
                                                _RawXbmcDb__conn = _findXbmcDb()
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\raw_xbmc_database.py", line 92, in _findXbmcDb
                                                return mysql.connector.Connect(host = host, port = int(port), database = database, user = user, password = passwd)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\__init__.py", line 45, in Connect
                                                return MySQLConnection(*args, **kwargs)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\connection.py", line 366, in __init__
                                                self.connect(*args, **kwargs)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\connection.py", line 411, in connect
                                                ssl=(ssl_ca, ssl_cert, ssl_key))
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\connection.py", line 449, in _open_connection
                                                self._charset)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\protocol.py", line 347, in do_auth
                                                buf = self.conn.recv()
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\connection.py", line 179, in recv_plain
                                                errors.raise_error(buf)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\errors.py", line 82, in raise_error
                                                raise get_mysql_exception(errno,errmsg)
                                            ProgrammingError: 1049: Unknown database 'myvideo60'
01:48:12 T:9376  NOTICE: Trakt Utilities: Notification service stopping
01:48:16 T:1392  NOTICE: Trakt Utilities: Scrobbler stopping

Just above all that I can see that TU is able to get information back from the database, it just seems to fall over at that sudden point.
Please let me know if there's anything else I can provide to help Smile.

@mswiege recently fixed some issues related to MySql and db names, this has just been committed to the master branch. If you wish you wish to try that out the zip file is here.
(2012-04-08 19:17)cf125 Wrote:  is there a way i can manual refresh without having to turn xbmc off and back on, im running atv2 latest eden build??

(2012-04-08 21:34)touser Wrote:  
(2012-04-08 19:17)cf125 Wrote:  is there a way i can manual refresh without having to turn xbmc off and back on, im running atv2 latest eden build??

This is big for me as well, my XBMC instance only gets restarted if it crashes or there is an update.

Manual syncing can be initiated in individual parts from TUs menu, Videos -> Video Addons -> Trakt Utilities -> Sync / Update / Clean
[Image: widget.jpg]
Developer working on Trakt Utilties for XBMC (Download)
Please read Getting Support before asking for support.
(This post was last modified: 2012-04-09 04:14 by othrayte.)
find quote
Nightah Offline
Junior Member
 Posts: 5
Joined: Feb 2012
Reputation: 0
2012-04-09 05:05 Post: #1154
(2012-04-09 04:12)othrayte Wrote:  
(2012-04-08 18:04)Nightah Wrote:  So I recently moved to a centralized MySQL database for my XBMC setup and it seems updating collections on startup no longer is working:

Code:
01:48:08 T:9412  NOTICE: Trakt Utilities: trakt json url: /show/episode/unlibrary/48dfcb4813134da82152984e8c4f329bc8b8b46a
01:48:09 T:9412  NOTICE: Trakt Utilities: successfully updated collection: 31 episodes removed from your library
01:48:09 T:9412  NOTICE: Trakt Utilities: autostart sync seen movies
01:48:10 T:9412  NOTICE: Trakt Utilities: trakt json url: /user/library/movies/all.json/48dfcb4813134da82152984e8c4f329bc8b8b46a/nightah
01:48:12 T:9412  NOTICE: Trakt Utilities: searching local...
01:48:12 T:9412  NOTICE: Trakt Utilities: 60
01:48:12 T:9412  NOTICE: Trakt Utilities: [RawXbmcDb] Found mysqldb: 10.10.10.3:3306, myvideo60
01:48:12 T:9412   ERROR: Error Type: <class 'mysql.connector.errors.ProgrammingError'>
01:48:12 T:9412   ERROR: Error Contents: 1049: Unknown database 'myvideo60'
01:48:12 T:9412   ERROR: Traceback (most recent call last):
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\service.py", line 67, in <module>
                                                autostart()
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\service.py", line 50, in autostart
                                                syncSeenMovies(True)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\sync_update.py", line 690, in syncSeenMovies
                                                setXBMCMoviePlaycount(movies_seen[i]['imdb_id'], movies_seen[i]['plays']) # set playcount on xbmc
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\utilities.py", line 407, in setXBMCMoviePlaycount
                                                " WHERE movie.c09='%(imdb_id)s'" % {'imdb_id':xcp(imdb_id)})
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\raw_xbmc_database.py", line 15, in query
                                                _RawXbmcDb__conn = _findXbmcDb()
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.TraktUtilities-0.6.5\raw_xbmc_database.py", line 92, in _findXbmcDb
                                                return mysql.connector.Connect(host = host, port = int(port), database = database, user = user, password = passwd)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\__init__.py", line 45, in Connect
                                                return MySQLConnection(*args, **kwargs)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\connection.py", line 366, in __init__
                                                self.connect(*args, **kwargs)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\connection.py", line 411, in connect
                                                ssl=(ssl_ca, ssl_cert, ssl_key))
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\connection.py", line 449, in _open_connection
                                                self._charset)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\protocol.py", line 347, in do_auth
                                                buf = self.conn.recv()
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\connection.py", line 179, in recv_plain
                                                errors.raise_error(buf)
                                              File "C:\Users\NightRider\AppData\Roaming\XBMC\addons\script.module.myconnpy\lib\mysql​\connector\errors.py", line 82, in raise_error
                                                raise get_mysql_exception(errno,errmsg)
                                            ProgrammingError: 1049: Unknown database 'myvideo60'
01:48:12 T:9376  NOTICE: Trakt Utilities: Notification service stopping
01:48:16 T:1392  NOTICE: Trakt Utilities: Scrobbler stopping

Just above all that I can see that TU is able to get information back from the database, it just seems to fall over at that sudden point.
Please let me know if there's anything else I can provide to help Smile.

@mswiege recently fixed some issues related to MySql and db names, this has just been committed to the master branch. If you wish you wish to try that out the zip file is

Looks like this is the ticket, everything worked fine after the latest commit thanks again guys Smile.
(This post was last modified: 2012-04-09 05:05 by Nightah.)
find quote
lordfiSh Offline
Junior Member
 Posts: 13
Joined: Sep 2011
Reputation: 0
2012-04-09 10:34 Post: #1155
(2011-04-05 12:12)Manromen Wrote:  **ATTENTION:**
This Add-on needs library mode. All Movies / TV Shows, that are not in library mode will be ignored.

The Utilities for TV Shows only work, if your scraper is TVDB (http://thetvdb.com/).

Same for the Movies! Every Movie that is scanned with the moviemaze.de scraper wont sync with takt!
https://getsatisfaction.com/trakt/topics...ames-4ud3b
find quote
othrayte Offline
Fan
 Posts: 452
Joined: Apr 2011
Reputation: 3
Location: Melbourne, Australia
2012-04-09 12:56 Post: #1156
(2012-04-09 10:34)lordfiSh Wrote:  
(2011-04-05 12:12)Manromen Wrote:  **ATTENTION:**
This Add-on needs library mode. All Movies / TV Shows, that are not in library mode will be ignored.

The Utilities for TV Shows only work, if your scraper is TVDB (http://thetvdb.com/).

Same for the Movies! Every Movie that is scanned with the moviemaze.de scraper wont sync with takt!
https://getsatisfaction.com/trakt/topics...ames-4ud3b

TU supports IMDB and TMDB ids for movies. Some other scrappers use these ids and they are generally supported.
[Image: widget.jpg]
Developer working on Trakt Utilties for XBMC (Download)
Please read Getting Support before asking for support.
find quote
Rumik Offline
Fan
 Posts: 301
Joined: Nov 2010
Reputation: 0
2012-04-10 10:22 Post: #1157
(2012-04-06 02:32)othrayte Wrote:  No, I haven't found a solution yet, and I haven't been able to reproduce the problem either.

Could you please ensure that you are running TU v0.6.5 or later and the stable version of Eden.

If the problem persists after that then we might need to talk to the XBMC devs encase they have any ideas. Also I will, when needed create a version of TU with almost everything stripped out to identify the issue.

I want to solve this too, it is almost as annoying to me as it must be to you.

Your support with this is appreciated, as always dude.

Yep, using 0.6.5 with Eden final.

Really hoping to get this sorted soon now, as it's been a problem for months Sad
[Image: watched-fanart.jpg]
find quote
Mochaka Offline
Junior Member
 Posts: 11
Joined: Apr 2012
Reputation: 0
2012-04-10 12:09 Post: #1158
I liked the feature where it sets Movies/TV to 'Watched' on XBMC if it is set as Seen on Trakt, but it doesn't seem to do that on my XBMC?
find quote
othrayte Offline
Fan
 Posts: 452
Joined: Apr 2011
Reputation: 3
Location: Melbourne, Australia
2012-04-10 12:36 Post: #1159
(2012-04-10 12:09)Mochaka Wrote:  I liked the feature where it sets Movies/TV to 'Watched' on XBMC if it is set as Seen on Trakt, but it doesn't seem to do that on my XBMC?

It should do that as long as you have syncing enabled in TUs settings, check that you have that enabled.
If you did have it enabled then:
  1. Enable debugging inside TU
  2. Mark a movie or show as watched on trakt.tv
  3. Use the manual sync to force TU to attempt to sync whichever you used (movies/tv shows)
  4. Post a copy of XMBCs log somewhere we can get at it
  5. Reply to this post with a link to the log


I'll then have a look over it and should be able to provide further help or possibly a solution.
[Image: widget.jpg]
Developer working on Trakt Utilties for XBMC (Download)
Please read Getting Support before asking for support.
find quote
Mochaka Offline
Junior Member
 Posts: 11
Joined: Apr 2012
Reputation: 0
2012-04-10 13:26 Post: #1160
(2012-04-10 12:36)othrayte Wrote:  
(2012-04-10 12:09)Mochaka Wrote:  I liked the feature where it sets Movies/TV to 'Watched' on XBMC if it is set as Seen on Trakt, but it doesn't seem to do that on my XBMC?

It should do that as long as you have syncing enabled in TUs settings, check that you have that enabled.
If you did have it enabled then:
  1. Enable debugging inside TU
  2. Mark a movie or show as watched on trakt.tv
  3. Use the manual sync to force TU to attempt to sync whichever you used (movies/tv shows)
  4. Post a copy of XMBCs log somewhere we can get at it
  5. Reply to this post with a link to the log


I'll then have a look over it and should be able to provide further help or possibly a solution.


Ah, turned debug on, it seems like its stuck loading info for a series.

21:07:21 T:3744 NOTICE: Trakt Utilities: getSeasonsFromXBMC: {u'tvshowid': 106, u'title': u'MythBusters', u'label': u'MythBusters', u'imdbnumber': u'73388', u'year': 2003, u'playcount': 0}
21:07:24 T:3744 NOTICE: Trakt Utilities: getSeasonsFromXBMC: {u'tvshowid': 78, u'title': u'New Girl', u'label': u'New Girl', u'imdbnumber': u'248682', u'year': 2011, u'playcount': 0}
21:07:24 T:3744 NOTICE: Trakt Utilities: getSeasonsFromXBMC: {u'tvshowid': 74, u'title': u'Parks and Recreation', u'label': u'Parks and Recreation', u'imdbnumber': u'84912', u'year': 2009, u'playcount': 0}
21:07:26 T:3744 NOTICE: Trakt Utilities: getSeasonsFromXBMC: {u'tvshowid': 129, u'title': u'Pawn Stars', u'label': u'Pawn Stars', u'imdbnumber': u'111051', u'year': 2009, u'playcount': 0}
21:07:42 T:3744 NOTICE: Trakt Utilities: getSeasonsFromXBMC: {u'tvshowid': 156, u'title': u'Perfect Couples', u'label': u'Perfect Couples', u'imdbnumber': u'171251', u'year': 2010, u'playcount': 0}
21:07:45 T:3744 NOTICE: Trakt Utilities: getSeasonsFromXBMC: {u'tvshowid': 56, u'title': u'Person of Interest', u'label': u'Person of Interest', u'imdbnumber': u'248742', u'year': 2011, u'playcount': 0}
21:07:47 T:3744 NOTICE: Trakt Utilities: getSeasonsFromXBMC: {u'tvshowid': 90, u'title': u'Pretty Little Liars', u'label': u'Pretty Little Liars', u'imdbnumber': u'146711', u'year': 2010, u'playcount': 0}
21:07:58 T:3744 NOTICE: Trakt Utilities: getSeasonsFromXBMC: {u'tvshowid': 159, u'title': u'Prisoner: Cell Block H', u'label': u'Prisoner: Cell Block H', u'imdbnumber': u'76724', u'year': 1979, u'playcount': 0}
21:09:26 T:6236 NOTICE: Trakt Utilities: [Notification Service] message: {"jsonrpc":"2.0","method":"GUI.OnScreensaverActivated","params":{"data":null,"sender":"xbmc"}}
21:09:48 T:6236 NOTICE: Trakt Utilities: [Notification Service] message: {"jsonrpc":"2.0","method":"GUI.OnScreensaverDeactivated","params":{"data":null,"sender":"xbmc"}}
21:13:14 T:6236 NOTICE: Trakt Utilities: [Notification Service] message: {"jsonrpc":"2.0","method":"GUI.OnScreensaverActivated","params":{"data":null,"sender":"xbmc"}}

It's now 21:26 Confused
find quote
Post Reply
Contact Us | XBMC Home | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication