Kodi Community Forum

Eden 3 here, when I shutdown 9/10 times XBMC hangs, I don't think it's syncing (haven't watched anything recently) is there a work around for this? 0.6.4 from the zip in this thread's the latest version I've tried. The same thing happens with the one from the repo.

quebert Wrote:Eden 3 here, when I shutdown 9/10 times XBMC hangs, I don't think it's syncing (haven't watched anything recently) is there a work around for this? 0.6.4 from the zip in this thread's the latest version I've tried. The same thing happens with the one from the repo.

No, we are solving that one for 0.7, it requires substantial changes.

othrayte Wrote:It could just be slow because it is a complex request, you could try running one of them on you mysql server directly, usually things link phpmyadmin will tell you how long it took.

naming issue for database is fixed. that works great.

however it doesnt seem like items are getting marked as watched? for example compare this log posting below to the one in my last post above (http://forum.xbmc.org/showpost.php?p=102...tcount=944)


note that it is trying to mark the same episodes was watched as it did before. i noticed it when last night i was testing and it said "need to mark 469 as watched" and i let it run for a bit before it quit and now this morning when im trying it it still says "need to mark 469 as watched."

i tried to reproduce the query in myphpadmin to see the runtime but i kept on getting query errors. also this is the first time ive mentioned it but its always been happening, when the syncing is on step "updating xbmc database" the box gives no percentage of progress like it does with the steps before it.

neilperrya Wrote:naming issue for database is fixed. that works great.

however it doesnt seem like items are getting marked as watched? for example compare this log posting below to the one in my last post above (http://forum.xbmc.org/showpost.php?p=102...tcount=944)

Code:

05:56:41 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] Found mysqldb: 192.168.1.111:3306, xbmc_video60
05:56:41 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] query: UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='3' )
05:56:43 T:7820   DEBUG: CWinEventsWin32::WndProcWindow is active
05:56:43 T:7820   DEBUG: CWinEventsWin32::WndProc: Focus switched to process C:\Users\Tim\AppData\Local\Google\Chrome\Application\chrome.exe
05:56:48 T:7820   DEBUG: ------ Window Deinit (Pointer.xml) ------
05:56:48 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] matches: []
05:56:49 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] query: UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='5' )
05:56:55 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] matches: []
05:56:55 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] query: UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='6' )
05:57:00 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] matches: []
05:57:00 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] query: UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='7' )
05:57:01 T:8240   DEBUG: Thread CRemoteControl 8240 terminating
05:57:06 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] matches: []
05:57:06 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] query: UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='8' )
05:57:11 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] matches: []
05:57:11 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] query: UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='9' )
05:57:20 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] matches: []
05:57:20 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] query: UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='10' )
05:57:24 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] matches: []
05:57:24 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] query: UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='11' )
05:57:29 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] matches: []
05:57:29 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] query: UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='12' )
05:57:34 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] matches: []
05:57:34 T:3768  NOTICE: Trakt Utilities: [RawXbmcDb] query: UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='13' )

note that it is trying to mark the same episodes was watched as it did before. i noticed it when last night i was testing and it said "need to mark 469 as watched" and i let it run for a bit before it quit and now this morning when im trying it it still says "need to mark 469 as watched."

i tried to reproduce the query in myphpadmin to see the runtime but i kept on getting query errors. also this is the first time ive mentioned it but its always been happening, when the syncing is on step "updating xbmc database" the box gives no percentage of progress like it does with the steps before it.

That query error could be the problem, could you please post it.

I have no idea the correct query to run so this is what I've tried after some googling. I stick this into phpmyadmin


and it says it runs successfully and spits out:


like i said, that query could be totally wrong cause i cant figure out the correct one

neilperrya Wrote:I have no idea the correct query to run so this is what I've tried after some googling. I stick this into phpmyadmin

Code:

use xbmc_video60; UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='3' )

and it says it runs successfully and spits out:

Code:

use xbmc_video60;# MySQL returned an empty result set (i.e. zero rows).
UPDATE files SET playcount=1 WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='3' )# MySQL returned an empty result set (i.e. zero rows).

like i said, that query could be totally wrong cause i cant figure out the correct one

phpMyAdmin allows you to run queries on the db by first selecting the db from the left and then choosing the query tab. You should then see a large text box where you can enter a query. Try these:

Hi.

Yesterday (on the 17. February 2012) I have seen movie Ponyo. But trakt.tv scrobbler sends bad date to trakt.tv server. The date is not good http://img576.imageshack.us/img576/5403/ponyor.jpg

I am using XBMC 11.0: Eden Beta 3. How to solve it?

Thanks.

hey guys I have been following this thread for a few days trying to see if this issue with the mysql db has been solved, and since every error I had was already posted I didnt chime in , but since this last update I have been getting an error nobody has had, when it made my MySQL tables it made them like this


as you can see mine are named different than video_database60

so i now i get this error when using this addon

Odar Wrote:Hi.

Yesterday (on the 17. February 2012) I have seen movie Ponyo. But trakt.tv scrobbler sends bad date to trakt.tv server. The date is not good http://img576.imageshack.us/img576/5403/ponyor.jpg

I am using XBMC 11.0: Eden Beta 3. How to solve it?

Thanks.

This might have been fixed for the upcoming release, if when that releases the problem does not go away please report this issue again.

As for fixing the date, you could unseen and then re seen it on the trakt website, but this will convert 'scrobble's to 'seen's and use the current date and time.

The underlying issue is with xbmc which passed TU a date (or something that become a date) which is not realistic, TU just passes it on to trakt. The reason TU is relying on the date is because the actual action that occurred was not a scrobble (which uses the current time/date) but a 'seen' operation which relies on the date stored by xbmc.

smblkpus Wrote:hey guys I have been following this thread for a few days trying to see if this issue with the mysql db has been solved, and since every error I had was already posted I didnt chime in , but since this last update I have been getting an error nobody has had, when it made my MySQL tables it made them like this

Code:

+--------------------+
| Database           |
+--------------------+
| MyMusic18          |
| MyVideos60         |
+--------------------+

as you can see mine are named different than video_database60

so i now i get this error when using this addon

Code:

07:40:20 T:2870504304  NOTICE: Trakt Utilities: [RawXbmcDb] Found mysqldb: 192.168.1.102:3306, video_database60
07:40:20 T:2870504304   ERROR: Error Type: <class 'mysql.connector.errors.ProgrammingError'>
07:40:20 T:2870504304   ERROR: Error Contents: 1049: Unknown database 'video_database60'
07:40:20 T:2870504304   ERROR: Traceback (most recent call last):
                                              File "/home/ryan/.xbmc/addons/othrayte-script.TraktUtilities-15e5e10/service.py", line 67, in <module>
                                                autostart()
                                              File "/home/ryan/.xbmc/addons/othrayte-script.TraktUtilities-15e5e10/service.py", line 56, in autostart
                                                syncSeenTVShows(True)
                                              File "/home/ryan/.xbmc/addons/othrayte-script.TraktUtilities-15e5e10/sync_update.py", line 956, in syncSeenTVShows
                                                setXBMCEpisodePlaycount(tvshow['tvdb_id'], episode[0], episode[1], 1)
                                              File "/home/ryan/.xbmc/addons/othrayte-script.TraktUtilities-15e5e10/utilities.py", line 437, in setXBMCEpisodePlaycount
                                                " )")
                                              File "/home/ryan/.xbmc/addons/othrayte-script.TraktUtilities-15e5e10/raw_xbmc_database.py", line 34, in execute
                                                return RawXbmcDb.query(str)
                                              File "/home/ryan/.xbmc/addons/othrayte-script.TraktUtilities-15e5e10/raw_xbmc_database.py", line 15, in query
                                                _RawXbmcDb__conn = _findXbmcDb()
                                              File "/home/ryan/.xbmc/addons/othrayte-script.TraktUtilities-15e5e10/raw_xbmc_database.py", line 92, in _findXbmcDb
                                                return mysql.connector.Connect(host = host, port = int(port), database = database, user = user, password = passwd)
                                              File "/home/ryan/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/__init__.py", line 45, in Connect
                                                return MySQLConnection(*args, **kwargs)
                                              File "/home/ryan/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 366, in __init__
                                                self.connect(*args, **kwargs)
                                              File "/home/ryan/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 411, in connect
                                                ssl=(ssl_ca, ssl_cert, ssl_key))
                                              File "/home/ryan/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 449, in _open_connection
                                                self._charset)
                                              File "/home/ryan/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/protocol.py", line 347, in do_auth
                                                buf = self.conn.recv()
                                              File "/home/ryan/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 179, in recv_plain
                                                errors.raise_error(buf)
                                              File "/home/ryan/.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 'video_database60'

What are the contents of your advancedsettings.xml file (you may want to remove passwords/usernames)?

othrayte Wrote:What are the contents of your advancedsettings.xml file (you may want to remove passwords/usernames)?

this is my advancedsettings.xml

smblkpus Wrote:this is my advancedsettings.xml

You cannot substitute single files. Only folders!

This will maybe be possible when Eden comes out but no promises on that

Martijn Wrote:You cannot substitute single files. Only folders!

This will maybe be possible when Eden comes out but no promises on that

thanks for that , just went back to the page I used and there is now a NOTICE on it

othrayte Wrote:phpMyAdmin allows you to run queries on the db by first selecting the db from the left and then choosing the query tab. You should then see a large text box where you can enter a query. Try these:

Code:

SELECT * FROM files WHERE idFile IN (  SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='3' )

Code:

SELECT idFile  FROM episode  INNER JOIN tvshowlinkepisode ON episode.idEpisode = tvshowlinkepisode.idEpisode   INNER JOIN tvshow ON tvshowlinkepisode.idShow = tvshow.idShow   WHERE tvshow.c12='76156'    AND episode.c12='9'    AND episode.c13='3'

Both of these 'work'. The first one seems to the be 'best' because it pulls the playCount and lastPlayed

Thank you very much for information.

I can try last stable release from *.ZIP file script.TraktUtilities-0.6.4.zip, but I thik, this is release, which is right now in XBMC Eden Beta 3.

othrayte Wrote:This might have been fixed for the upcoming release, if when that releases the problem does not go away please report this issue again.

As for fixing the date, you could unseen and then re seen it on the trakt website, but this will convert 'scrobble's to 'seen's and use the current date and time.

The underlying issue is with xbmc which passed TU a date (or something that become a date) which is not realistic, TU just passes it on to trakt. The reason TU is relying on the date is because the actual action that occurred was not a scrobble (which uses the current time/date) but a 'seen' operation which relies on the date stored by xbmc.