MySQL keeps updating movies
#1
I'm going to uninstall this add-on as it apparently doing something out of settings.
I have set to run autoupdate on Friday at 2:30 but it started to updating ratings at 21:16:
html:

2023-02-06 21:16:53.074 T:3760     info <general>: UpdateDetailsForMovie: Starting updates for movie 2810
2023-02-06 21:16:53.093 T:3760     info <general>: UpdateDetailsForMovie: Finished updates for movie 2810
2023-02-06 21:16:57.432 T:3770     info <general>: UpdateDetailsForMovie: Starting updates for movie 2612
2023-02-06 21:16:57.446 T:3770     info <general>: UpdateDetailsForMovie: Finished updates for movie 2612
2023-02-06 21:17:02.032 T:3778     info <general>: UpdateDetailsForMovie: Starting updates for movie 2810
2023-02-06 21:17:02.048 T:3778     info <general>: UpdateDetailsForMovie: Finished updates for movie 2810
2023-02-06 21:17:03.638 T:3760     info <general>: UpdateDetailsForMovie: Starting updates for movie 2653
2023-02-06 21:17:03.663 T:3760     info <general>: UpdateDetailsForMovie: Finished updates for movie 2653
2023-02-06 21:17:13.055 T:3778     info <general>: UpdateDetailsForMovie: Starting updates for movie 2653
2023-02-06 21:17:13.065 T:3778     info <general>: UpdateDetailsForMovie: Finished updates for movie 2653
2023-02-06 21:17:13.781 T:3691     info <general>: UpdateDetailsForMovie: Starting updates for movie 2810

and ran for around 30 minutes finally causing Kodi complete freeze. Not possible to ssh and winscp.
I left my device at this stage for a night and today morning it was the same: complete freeze.
Reply
#2
I don't want to start any discussion...with such a rudeness, I will just ignore the two previous posts.

Cheers,

Alex
Light IMDb Ratings Update - Keep updated the IMDb ratings for your movies and TV shows.
In case you found useful my work, feel free to offer me a cappuccino!
Reply
#3
@rafikW

Wow, that is a bit of an extreme response.

I just checked my Kodi log that's been running for 4 days and there is no sign of any activity from LightIMDB.

There is nothing in that log snippet you posted that states LightIMDB is causing that.

Maybe if you provide the whole Debug Log it can be checked to see what is causing it, rather than yelling that no-one should use this addon.
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki)  ||  Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#4
As reported in my second post which you deleted (you have a good censors skills)
Light IMDb Ratings Update 5.1.1 addon installed
scheduling disabled
right-click on one episode and imdb rating is retrieved
left Kodi to do nothing
few minutes later addon is start doing for no reason what I pasted:
xml:

2023-02-07 21:28:01.541 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2811
2023-02-07 21:28:01.549 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2811
2023-02-07 21:28:05.949 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2841
2023-02-07 21:28:05.956 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2841
2023-02-07 21:28:10.384 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2798
2023-02-07 21:28:10.395 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2798
2023-02-07 21:28:27.941 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2853
2023-02-07 21:28:27.948 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2853
2023-02-07 21:28:49.871 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 1560
2023-02-07 21:28:49.900 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 1560
2023-02-07 21:28:54.340 T:14405    info <general>: UpdateDetailsForMovie: Starting updates for movie 2312
2023-02-07 21:28:54.346 T:14405    info <general>: UpdateDetailsForMovie: Finished updates for movie 2312
[..........]
2023-02-07 21:53:49.704 T:20565    info <general>: UpdateDetailsForMovie: Starting updates for movie 1724
2023-02-07 21:53:49.715 T:20565    info <general>: UpdateDetailsForMovie: Finished updates for movie 1724
2023-02-07 21:53:51.829 T:20571    info <general>: UpdateDetailsForMovie: Starting updates for movie 1724
2023-02-07 21:53:51.842 T:20571    info <general>: UpdateDetailsForMovie: Finished updates for movie 1724
2023-02-07 21:53:54.756 T:20602    info <general>: UpdateDetailsForMovie: Starting updates for movie 2614
2023-02-07 21:53:54.803 T:20602    info <general>: UpdateDetailsForMovie: Finished updates for movie 2614
2023-02-07 21:54:03.655 T:19996    info <general>: UpdateDetailsForMovie: Starting updates for movie 2474
2023-02-07 21:54:03.670 T:19996    info <general>: UpdateDetailsForMovie: Finished updates for movie 2474
2023-02-07 21:54:15.338 T:20565    info <general>: UpdateDetailsForMovie: Starting updates for movie 2247
2023-02-07 21:54:15.357 T:20565    info <general>: UpdateDetailsForMovie: Finished updates for movie 2247
2023-02-07 21:54:18.541 T:20571    info <general>: UpdateDetailsForMovie: Starting updates for movie 2247
2023-02-07 21:54:18.550 T:20571    info <general>: UpdateDetailsForMovie: Finished updates for movie 2247
2023-02-07 21:54:21.611 T:19996    info <general>: UpdateDetailsForMovie: Starting updates for movie 1410
2023-02-07 21:54:21.628 T:19996    info <general>: UpdateDetailsForMovie: Finished updates for movie 1410
2023-02-07 21:54:24.356 T:20565    info <general>: UpdateDetailsForMovie: Starting updates for movie 1894
2023-02-07 21:54:24.367 T:20565    info <general>: UpdateDetailsForMovie: Finished updates for movie 1894
2023-02-07 21:54:27.439 T:20571    info <general>: UpdateDetailsForMovie: Starting updates for movie 1894
2023-02-07 21:54:27.458 T:20571    info <general>: UpdateDetailsForMovie: Finished updates for movie 1894
2023-02-07 21:54:30.611 T:19996    info <general>: UpdateDetailsForMovie: Starting updates for movie 1824
2023-02-07 21:54:30.628 T:19996    info <general>: UpdateDetailsForMovie: Finished updates for movie 1824
2023-02-07 21:54:32.578 T:20602    info <general>: UpdateDetailsForMovie: Starting updates for movie 1724
2023-02-07 21:54:32.591 T:20602    info <general>: UpdateDetailsForMovie: Finished updates for movie 1724
2023-02-07 21:54:39.568 T:19996    info <general>: UpdateDetailsForMovie: Starting updates for movie 2214
2023-02-07 21:54:39.578 T:19996    info <general>: UpdateDetailsForMovie: Finished updates for movie 2214
2023-02-07 21:54:48.562 T:19996    info <general>: UpdateDetailsForMovie: Starting updates for movie 2516
2023-02-07 21:54:48.574 T:19996    info <general>: UpdateDetailsForMovie: Finished updates for movie 2516
2023-02-07 21:55:01.089 T:20602    info <general>: UpdateDetailsForMovie: Starting updates for movie 2247
2023-02-07 21:55:01.101 T:20602    info <general>: UpdateDetailsForMovie: Finished updates for movie 2247
2023-02-07 21:55:10.489 T:20602    info <general>: UpdateDetailsForMovie: Starting updates for movie 1894
2023-02-07 21:55:10.499 T:20602    info <general>: UpdateDetailsForMovie: Finished updates for movie 1894
2023-02-07 21:55:25.995 T:20565    info <general>: UpdateDetailsForMovie: Starting updates for movie 2692
2023-02-07 21:55:26.007 T:20565    info <general>: UpdateDetailsForMovie: Finished updates for movie 2692
2023-02-07 21:55:28.492 T:20571    info <general>: UpdateDetailsForMovie: Starting updates for movie 2692
2023-02-07 21:55:28.507 T:20571    info <general>: UpdateDetailsForMovie: Finished updates for movie 2692
2023-02-07 21:55:35.017 T:20565    info <general>: UpdateDetailsForMovie: Starting updates for movie 2517
2023-02-07 21:55:35.034 T:20565    info <general>: UpdateDetailsForMovie: Finished updates for movie 2517
2023-02-07 21:55:37.291 T:20571    info <general>: UpdateDetailsForMovie: Starting updates for movie 2517
2023-02-07 21:55:37.305 T:20571    info <general>: UpdateDetailsForMovie: Finished updates for movie 2517
2023-02-07 21:55:52.507 T:20565    info <general>: UpdateDetailsForMovie: Starting updates for movie 1725

after around 30 minutes not possible to ssh, winscp, Kodi frozen.
Hard reboot.
Last line in kodi.old.log is:
xml:

2023-02-07 21:58:50.546 T:20602    info <general>: UpdateDetailsForMovie: Finished updates for movie 2516


When Light IMDb Ratings Update 5.1.1 is uninstalled nothing like this is happening so I don't understand why you are claiming that the line like this:
xml:

2023-02-07 21:58:50.546 T:20602    info <general>: UpdateDetailsForMovie: Finished updates for movie 2516
is not caused by this addon.
Reply
#5
@rafikW

Provide the full log, not snippets.
Ensure debug is enabled in both Kodi and LightIMDB addon settings.
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/Banned add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create Music Library (wiki) | HOW-TO:Create_Video_Library (wiki)  ||  Artwork (wiki) | Basic controls (wiki) | Import-export library (wiki) | Movie sets (wiki) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#6
Will be able to provide the full log later today in around 8-9 hours.
Reply
#7
(2023-02-08, 10:04)rafikW Wrote: Will be able to provide the full log later today in around 8-9 hours.
Please provide also the full update log of the add-on by enabling it in the settings (see the first post for reference). At the moment, according to what you reported, I don't see any link to this add-on.

Cheers,

Alex
Light IMDb Ratings Update - Keep updated the IMDb ratings for your movies and TV shows.
In case you found useful my work, feel free to offer me a cappuccino!
Reply
#8
(2023-02-07, 09:10)rafikW Wrote: I'm going to uninstall this add-on as it apparently doing something out of settings.

Why do you keep writing since you've uninstalled the add-on anyway? You're of no use anymore to others who visit this thread. *PLONK*
Reply
#9
(2023-02-08, 10:40)HeresJohnny Wrote:
(2023-02-07, 09:10)rafikW Wrote: I'm going to uninstall this add-on as it apparently doing something out of settings.

Why do you keep writing since you've uninstalled the add-on anyway? You're of no use anymore to others who visit this thread. *PLONK*
If my second post would not be deleted then you would understand what I did and would not ask first question. In short: I have installed it again and started digging into the possible root cause.
Reply
#10
======= right click on "Your.Honor.S02E04" and selected Update IMDB rating:
xml:
2023-02-08 17:51:33.527 T:3566    debug <general>: CPlayerCoreFactory::GetPlayers(nfs://192.168.1.119/volume1/MyNAS/3_SERIALE/Your Honor US (2020)/sezon2/Your.Honor.S02E04.1080p.10bit.WEBRip.6CH.x265.HEVC-PSA.mkv)
2023-02-08 17:51:35.946 T:4243    debug <general>: CPythonInvoker(7, /storage/.kodi/addons/script.light.imdb.ratings.update/context.py): start processing
2023-02-08 17:51:37.247 T:4243    debug <general>: CPythonInvoker(7, /storage/.kodi/addons/script.light.imdb.ratings.update/context.py): the source file to load is "/storage/.kodi/addons/script.light.imdb.ratings.update/context.py"
======= update done:
xml:
2023-02-08 17:51:42.211 T:4243    debug <general>: Mysql execute: UPDATE rating SET rating = 7.800000, votes = 166 WHERE rating_id = 65253
2023-02-08 17:51:42.213 T:4243    debug <general>: Mysql execute: UPDATE uniqueid SET value = 'tt22167148', type = 'imdb' WHERE uniqueid_id = 70174
2023-02-08 17:51:42.215 T:4243    debug <general>: Mysql execute: UPDATE uniqueid SET value = '9325400', type = 'tvdb' WHERE uniqueid_id = 70175
2023-02-08 17:51:42.216 T:4243    debug <general>: Mysql execute: DELETE FROM streamdetails WHERE idFile = 11434
2023-02-08 17:51:42.217 T:4243    debug <general>: Mysql execute: INSERT INTO streamdetails (idFile, iStreamType, strVideoCodec, fVideoAspect, iVideoWidth, iVideoHeight, iVideoDuration, strStereoMode, strVideoLanguage,  strHdrType)VALUES (11434,0,'hevc',2.242990,1920,856,3165,'','eng','')
2023-02-08 17:51:42.217 T:4243    debug <general>: Mysql execute: INSERT INTO streamdetails (idFile, iStreamType, strAudioCodec, iAudioChannels, strAudioLanguage) VALUES (11434,1,'eac3',6,'eng')
2023-02-08 17:51:42.218 T:4243    debug <general>: Mysql execute: INSERT INTO streamdetails (idFile, iStreamType, strSubtitleLanguage) VALUES (11434,2,'pol')
2023-02-08 17:51:42.219 T:4243    debug <general>: Mysql execute: update movie set c11=3165 where idFile=11434 and c11=''
2023-02-08 17:51:42.220 T:4243    debug <general>: Mysql execute: update episode set c09=3165 where idFile=11434 and c09=''
2023-02-08 17:51:42.222 T:4243    debug <general>: Mysql execute: update musicvideo set c04=3165 where idFile=11434 and c04=''
2023-02-08 17:51:42.227 T:4243    debug <general>: Mysql execute: UPDATE episode SET c00='Part Fourteen',c01='Olivia’s plan to get Michael closer to the Baxters seems to be working when he gets invited to Jimmy Baxter’s 50th birthday party. There, he witnesses the return of legendary gangster Carmine Conti, the father of Gina. Eugene makes a selfless decision to repay Little Mo for his kindness, but his good deed threatens to expose massive corruption across the power structure of New Orleans.',c03='65253',c04='Darren Grant / Aalia Brown',c05='2023-02-05',c06='<thumb spoof=\"\" cache=\"\" aspect=\"thumb\" preview=\"\">https://artworks.thetvdb.com/banners/v4/episode/9325400/screencap/63dc96890a0ed.jpg</thumb>',c09='3165',c10='',c11='',c12='2',c13='4',c14='',c15='-1',c16='-1',c17='-1',c18='nfs://192.168.1.119/volume1/MyNAS/3_SERIALE/Your Honor US (2020)/sezon2/Your.Honor.S02E04.1080p.10bit.WEBRip.6CH.x265.HEVC-PSA.mkv',c19='3803',c20='70175', userrating = NULL, idSeason = 4485 where idEpisode=26154
2023-02-08 17:51:42.229 T:4243    debug <general>: Mysql commit transaction
======= action completed:
xml:
2023-02-08 17:51:45.181 T:4243    debug <general>: CPythonInvoker(7, /storage/.kodi/addons/script.light.imdb.ratings.update/context.py): script successfully run
2023-02-08 17:51:45.181 T:4243    debug <general>: onExecutionDone(7, /storage/.kodi/addons/script.light.imdb.ratings.update/context.py)
2023-02-08 17:51:45.222 T:4243    debug <general>: .
2023-02-08 17:51:45.297 T:4243    debug <general>: Python interpreter stopped
2023-02-08 17:51:45.297 T:4243    debug <general>: Thread LanguageInvoker 3339715264 terminating
======= but then few seconds later it is still updating next items but I have not clicked on anything !!!!!!!!!!!!:
xml:
2023-02-08 17:51:59.784 T:4217     info <general>: UpdateDetailsForMovie: Starting updates for movie 2612
2023-02-08 17:51:59.785 T:4217    debug <general>: Mysql Start transaction
2023-02-08 17:51:59.785 T:4217    debug <general>: Mysql execute: UPDATE movie SET c00='12 Angry Men',c01='The defense and the prosecution have rested and the jury is
2023-02-08 17:51:59.788 T:4217    debug <general>: Mysql commit transaction
2023-02-08 17:51:59.791 T:4217     info <general>: UpdateDetailsForMovie: Finished updates for movie 2612
2023-02-08 17:51:59.792 T:4217    debug <general>: connect replacing configured host 192.168.1.119 with resolved host 192.168.1.119
2023-02-08 17:52:00.315 T:3974    debug <general>: ffmpeg[0x49c7598]: [image2] Custom AVIOContext makes no sense and will be ignored with AVFMT_NOFILE format.
2023-02-08 17:52:03.739 T:4217    debug <general>: connect replacing configured host 192.168.1.119 with resolved host 192.168.1.119
2023-02-08 17:52:08.677 T:4217     info <general>: Skipped 5 duplicate messages..
2023-02-08 17:52:08.677 T:4217     info <general>: UpdateDetailsForMovie: Starting updates for movie 2810
2023-02-08 17:52:08.678 T:4217    debug <general>: Mysql Start transaction
2023-02-08 17:52:08.679 T:4217    debug <general>: Mysql execute: UPDATE movie SET c00='The Lord of the Rings: The Return of the King',c01='Aragorn is revealed as the
2023-02-08 17:52:08.682 T:4217    debug <general>: Mysql commit transaction
2023-02-08 17:52:08.685 T:4217     info <general>: UpdateDetailsForMovie: Finished updates for movie 2810
2023-02-08 17:52:08.686 T:4217    debug <general>: connect replacing configured host 192.168.1.119 with resolved host 192.168.1.119
2023-02-08 17:52:13.155 T:4217     info <general>: Skipped 4 duplicate messages..
2023-02-08 17:52:13.155 T:4217     info <general>: UpdateDetailsForMovie: Starting updates for movie 2653
2023-02-08 17:52:13.156 T:4217    debug <general>: Mysql Start transaction
2023-02-08 17:52:13.156 T:4217    debug <general>: Mysql execute: UPDATE movie SET c00='Pulp Fiction',c01='A burger-loving hit man, his philosophical partner, a drug-
2023-02-08 17:52:13.159 T:4217    debug <general>: Mysql commit transaction
2023-02-08 17:52:13.162 T:4217     info <general>: UpdateDetailsForMovie: Finished updates for movie 2653
2023-02-08 17:52:13.163 T:4217    debug <general>: connect replacing configured host 192.168.1.119 with resolved host 192.168.1.119
2023-02-08 17:52:17.623 T:4217     info <general>: Skipped 4 duplicate messages..
2023-02-08 17:52:17.623 T:4217     info <general>: UpdateDetailsForMovie: Starting updates for movie 2809
2023-02-08 17:52:17.624 T:4217    debug <general>: Mysql Start transaction
======= and is still doing this:
xml:
2023-02-08 18:06:04.746 T:4217    debug <general>: Mysql execute: UPDATE movie SET c00='Blade Runner',c01='In the smog-choked dystopian Los Angeles of 2019, blade
2023-02-08 18:06:04.750 T:4217    debug <general>: Mysql commit transaction
2023-02-08 18:06:04.753 T:4217     info <general>: UpdateDetailsForMovie: Finished updates for movie 2348
2023-02-08 18:06:04.771 T:4217    debug <general>: connect replacing configured host 192.168.1.119 with resolved host 192.168.1.119
2023-02-08 18:06:09.990 T:4217     info <general>: Skipped 4 duplicate messages..
2023-02-08 18:06:09.990 T:4217     info <general>: UpdateDetailsForMovie: Starting updates for movie 2615
2023-02-08 18:06:09.991 T:4217    debug <general>: Mysql Start transaction
2023-02-08 18:06:09.994 T:4217    debug <general>: Mysql execute: UPDATE movie SET c00='The Gold Rush',c01='A lone prospector ventures into Alaska looking for gold. He 2023-02-08 18:06:09.996 T:4217    debug <general>: Mysql commit transaction
2023-02-08 18:06:09.999 T:4217     info <general>: UpdateDetailsForMovie: Finished updates for movie 2615
2023-02-08 18:06:10.000 T:4217    debug <general>: connect replacing configured host 192.168.1.119 with resolved host 192.168.1.119
2023-02-08 18:06:14.093 T:5444    debug <general>: Thread JobWorker 3807367872 terminating (autodelete)
2023-02-08 18:06:14.336 T:4217    debug <general>: connect replacing configured host 192.168.1.119 with resolved host 192.168.1.119
2023-02-08 18:06:14.580 T:5487    debug <general>: Thread JobWorker start, auto delete: true
2023-02-08 18:06:14.593 T:5487    debug <general>: ffmpeg[0x5d1aa70]: [image2] Custom AVIOContext makes no sense and will be ignored with AVFMT_NOFILE format.
2023-02-08 18:06:14.602 T:5488    debug <general>: Thread JobWorker start, auto delete: true
2023-02-08 18:06:15.146 T:4217    debug <general>: connect replacing configured host 192.168.1.119 with resolved host 192.168.1.119

Would you like me to wait until it finally freeze Kodi or would you like me to upload whole log now?
Reply
#11
As requested, can you also share the update log of the add-on?

From which information are you guessing that such "movie updates" are related to the add-on? You called the rating update of a single TV show episode through the context menu...I'm really missing any rational link between the twos; even the commands are completely different. Are you sure you have not installed any other add-on that mess-up with the Kodi database? Is the database local or shared?

Thanks
Light IMDb Ratings Update - Keep updated the IMDb ratings for your movies and TV shows.
In case you found useful my work, feel free to offer me a cappuccino!
Reply
#12
(2023-02-08, 19:31)axlt2002 Wrote: As requested, can you also share the update log of the add-on?

From which information are you guessing that such "movie updates" are related to the add-on? You called the rating update of a single TV show episode through the context menu...I'm really missing any rational link between the twos; even the commands are completely different. Are you sure you have not installed any other add-on that mess-up with the Kodi database? Is the database local or shared?

Thanks
List of addons installed:
Backup
CoreELEC Configuration
Light IMDb Ratings Update
Network Tools
Skin Helper Service Skin Backup
Web-PDB

Kodi database is located on NAS.

I don't understand what else might do these "movie updates" while when I have Light IMDb Ratings Update add-on uninstalled I'm not facing this issue.

Whole kodi.log uploaded: https://paste.kodi.tv/uparebanil.kodi

PS. And while it is doing this "movie updates" I think it leads to memory exhausting:
18:12 - MEM: 1304024/1879536 KB
18:33 - MEM: 1194084/1879536 KB

finally causing Kodi freeze.
Reply
#13
Update.log in /storage/.kodi/userdata/addon_data/script.light.imdb.ratings.update:

--------------------------------------------------------
Starting Light IMDb Ratings Update (2023-02-08 17:50:35)
version 5.1.1
onMovies: false
onTVShows: true
IncludeEpisodes: true
UpdateMode: episode
IMDbDefault: true
NumberOfThreads: 8
ScheduleEnabled: false
--------------------------------------------------------

17:51:40 - Context ratings update

Your Honor (US) 2x04 (IMDb ID: tt22167148, TVDB ID: 9325400, TMDB ID: n/a)
Rating: 7.8, Votes: 166


Add-on settings:
xml:
<settings version="2">
    <setting id="Movies">false</setting>
    <setting id="TVShows">true</setting>
    <setting id="IncludeEpisodes">true</setting>
    <setting id="UpdateMode" default="true">0</setting>
    <setting id="IMDbRatingDefault">true</setting>
    <setting id="NumberOfThreads" default="true">0</setting>
    <setting id="ScheduleEnabled" default="true">false</setting>
    <setting id="WeekDay" default="true">0</setting>
    <setting id="DayTime">12:00</setting>
    <setting id="ScheduledWeekDay">2000-01-01</setting>
    <setting id="PerformingUpdate" default="true">false</setting>
    <setting id="ShowNotifications">false</setting>
    <setting id="NotificationsSound">true</setting>
    <setting id="ShowProgress">true</setting>
    <setting id="CompleteLog">true</setting>
    <setting id="ShowLogMessage">true</setting>
    <setting id="LogDialog" default="true">false</setting>
</settings>

Reply
#14
I'm sorry, but I can just tell that such SQL commands are not related to Light IMDb Ratings Update...it looks they are setting movie titles, plots, posters, etc., definitely something that my add-on does not. Just to know, do you already used in the past the add-on or is this the first time?
Light IMDb Ratings Update - Keep updated the IMDb ratings for your movies and TV shows.
In case you found useful my work, feel free to offer me a cappuccino!
Reply
#15
(2023-02-08, 19:52)rafikW Wrote: Update.log in /storage/.kodi/userdata/addon_data/script.light.imdb.ratings.update:

--------------------------------------------------------
Starting Light IMDb Ratings Update (2023-02-08 17:50:35)
version 5.1.1
onMovies: false
onTVShows: true
IncludeEpisodes: true
UpdateMode: episode
IMDbDefault: true
NumberOfThreads: 8
ScheduleEnabled: false
--------------------------------------------------------

17:51:40 - Context ratings update

Your Honor (US) 2x04 (IMDb ID: tt22167148, TVDB ID: 9325400, TMDB ID: n/a)
Rating: 7.8, Votes: 166


Add-on settings:
xml:
<settings version="2">
    <setting id="Movies">false</setting>
    <setting id="TVShows">true</setting>
    <setting id="IncludeEpisodes">true</setting>
    <setting id="UpdateMode" default="true">0</setting>
    <setting id="IMDbRatingDefault">true</setting>
    <setting id="NumberOfThreads" default="true">0</setting>
    <setting id="ScheduleEnabled" default="true">false</setting>
    <setting id="WeekDay" default="true">0</setting>
    <setting id="DayTime">12:00</setting>
    <setting id="ScheduledWeekDay">2000-01-01</setting>
    <setting id="PerformingUpdate" default="true">false</setting>
    <setting id="ShowNotifications">false</setting>
    <setting id="NotificationsSound">true</setting>
    <setting id="ShowProgress">true</setting>
    <setting id="CompleteLog">true</setting>
    <setting id="ShowLogMessage">true</setting>
    <setting id="LogDialog" default="true">false</setting>
</settings>

Ok, you have enabled the complete log option: this means that in the update log file all the rating updates (i.e. with or without errors) are reported; these are "translated" in the related commands towards the SQL database. As you can see, there is only one update (i.e. one command towards the database), the one of the TV show episode you have triggered through the context menu.
Light IMDb Ratings Update - Keep updated the IMDb ratings for your movies and TV shows.
In case you found useful my work, feel free to offer me a cappuccino!
Reply

Logout Mark Read Team Forum Stats Members Help
MySQL keeps updating movies0
This forum uses Lukasz Tkacz MyBB addons.