•   
  • 1
  • 4
  • 5
  • 6(current)
  • 7
  • 8
  • 40
  •   
[RELEASE] - Rating Update v1.4.3
#76
I use a mysql DB and imdb scraper. When i run the script (1.1.5) i get the following error:

Code:
17:55:14 T:2908736368 WARNING: CreateLoader - Unsupported protocol(addons) in addons://more/executable.tbn
17:55:17 T:2815298416  NOTICE: -->Python Interpreter Initialized<--
17:55:17 T:2815298416  NOTICE: [Rating Update] - Starting Rating Update v1.1.5
17:55:17 T:2815298416  NOTICE: -->Python Interpreter Initialized<--
17:55:17 T:6125328   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: SELECT c00, c09, c04, c05 FROM movie WHERE c09!="" ORDER BY c00 ASC LIMIT 0,-1
17:55:17 T:6125328   ERROR: GetArbitraryQuery failed
17:55:25 T:2815298416  NOTICE: [Rating Update] - The video library is empty or the IMDb id doesn't exist!
17:55:37 T:2873092976 WARNING: CreateLoader - Unsupported protocol(addons) in addons://more/executable.tbn
17:56:47 T:6125328  NOTICE: Samba is idle. Closing the remaining connections

This didnt happen with 1.1.0.
Reply
#77
lowfi Wrote:I use a mysql DB and imdb scraper. When i run the script (1.1.5) i get the following error:

Code:
17:55:14 T:2908736368 WARNING: CreateLoader - Unsupported protocol(addons) in addons://more/executable.tbn
17:55:17 T:2815298416  NOTICE: -->Python Interpreter Initialized<--
17:55:17 T:2815298416  NOTICE: [Rating Update] - Starting Rating Update v1.1.5
17:55:17 T:2815298416  NOTICE: -->Python Interpreter Initialized<--
17:55:17 T:6125328   ERROR: SQL: Undefined MySQL error: Code (1064)
                                            Query: SELECT c00, c09, c04, c05 FROM movie WHERE c09!="" ORDER BY c00 ASC LIMIT 0,-1
17:55:17 T:6125328   ERROR: GetArbitraryQuery failed
17:55:25 T:2815298416  NOTICE: [Rating Update] - The video library is empty or the IMDb id doesn't exist!
17:55:37 T:2873092976 WARNING: CreateLoader - Unsupported protocol(addons) in addons://more/executable.tbn
17:56:47 T:6125328  NOTICE: Samba is idle. Closing the remaining connections

This didnt happen with 1.1.0.

Version of mysql server?
LG M227WD - ASUS S1-AT5NM10E - LOGITECH HARMONY 300i - MINI KEYBOARD USB
Running Ubuntu Precise 12.04.04 - FRODO 12.03 - Transparency!
Movies: 996 - TV Show: 98 - Albums: 1161

My Script: Rating Update - Thumbnails Cleaner
Reply
#78
Thanks for this. I just installed 1.1.5 but had to manually make ".xbmc/userdata/addon_data/script.ratingupdate/" dir. This is on linux and I skipped the top 250 and said yes to movies.
Image
AWXi - Ajax web interface. Wiki
Reply
#79
Mizaki Wrote:Thanks for this. I just installed 1.1.5 but had to manually make ".xbmc/userdata/addon_data/script.ratingupdate/" dir. This is on linux and I skipped the top 250 and said yes to movies.

Thanks, this is a bug I'll fix to next release!
LG M227WD - ASUS S1-AT5NM10E - LOGITECH HARMONY 300i - MINI KEYBOARD USB
Running Ubuntu Precise 12.04.04 - FRODO 12.03 - Transparency!
Movies: 996 - TV Show: 98 - Albums: 1161

My Script: Rating Update - Thumbnails Cleaner
Reply
#80
m4x1m Wrote:Version of mysql server?

MySQL version 5.1.41
Reply
#81
lowfi Wrote:MySQL version 5.1.41

I'm searching in google and I found that perhaps is a bug of mysql but I'm not sure.

Anyway I'll try a workaround, in meantime could you try to substitute LIMIT 0,-1 with LIMIT 0,1000000

The problem is "-1" you can replace it wherever you find it in the query with 1000000 (I don't think you have more 1000000 of movies Big Grin).

In this way we will be sure the problem is that I have no way to test.
LG M227WD - ASUS S1-AT5NM10E - LOGITECH HARMONY 300i - MINI KEYBOARD USB
Running Ubuntu Precise 12.04.04 - FRODO 12.03 - Transparency!
Movies: 996 - TV Show: 98 - Albums: 1161

My Script: Rating Update - Thumbnails Cleaner
Reply
#82
Hmm how do i do this?
Reply
#83
lowfi Wrote:Hmm how do i do this?

No matter, try this ...

New Version:
script.ratingupdate-1.1.6.zip

Code:
v 1.1.6:
- Fixed profile folder that doesn't exist on the first launch of the script.
- Fixed error for mysql database that made the script fail.
LG M227WD - ASUS S1-AT5NM10E - LOGITECH HARMONY 300i - MINI KEYBOARD USB
Running Ubuntu Precise 12.04.04 - FRODO 12.03 - Transparency!
Movies: 996 - TV Show: 98 - Albums: 1161

My Script: Rating Update - Thumbnails Cleaner
Reply
#84
Any chance to get this feature in XBMC : http://forum.xbmc.org/showthread.php?tid=117414 Huh

Please...

I would love personnal ratings showed in XBMC.

It should be simple to do with your script ?

Anyway, thank you for the consideration.

Cheers.
Reply
#85
So anyone use this with openelec? Wondering if it's possible being that the script needs an install of php5-cgi
Reply
#86
Anyone got this working on a mac?

I have linked to the php-cgi binary, but still not working...
Reply
#87
reinstalled system and updating IMDb top250 now freezes xbmc. single movie and all movies scraping works ok.

No clue from log:
There is always around 40-50 queries (in 1s) for various movies from top250 list
Code:
1:50 T:3012499264   DEBUG: HttpApi Start command: QueryVideoDatabase  paras: QueryVideoDatabase; SELECT c00, c13 FROM movie WHERE c09="tt0103064"

but nothing more which could point out what's wrong

db is sqlite

EDIT: Updated to newer xbmc version, and so far it works.
Kodibuntu 14.0 | Kodi 16.1 | VDR + VNSI @ Technotrend CT-3650 CI | Transparency! skin | trakt.tv
Reply
#88
I have just tested 1.1.6 on the eden beta and I get this error when it scrapes movies. (top 250 is fine but it comes back with 'no top250 information available' so I guess I have no movies from the top250!)

Code:
17:35:38 T:2576   ERROR: Error Type: <type 'exceptions.ValueError'>
17:35:38 T:2576   ERROR: Error Contents: No JSON object could be decoded
17:35:38 T:2576   ERROR: Traceback (most recent call last):
                                              File "C:\Documents and Settings\Gazza\Application Data\XBMC\addons\script.ratingupdate\resources\rating_scraper.py", line 521, in <module>
                                                if __movies__ == "true": Movies()
                                              File "C:\Documents and Settings\Gazza\Application Data\XBMC\addons\script.ratingupdate\resources\rating_scraper.py", line 247, in __init__
                                                complete = self.scan()
                                              File "C:\Documents and Settings\Gazza\Application Data\XBMC\addons\script.ratingupdate\resources\rating_scraper.py", line 328, in scan
                                                else: self.updating()
                                              File "C:\Documents and Settings\Gazza\Application Data\XBMC\addons\script.ratingupdate\resources\rating_scraper.py", line 288, in updating
                                                decode = json.loads( get_data )
                                              File "C:\Program Files\XBMC\system\python\Lib\json\__init__.py", line 307, in loads
                                                return _default_decoder.decode(s)
                                              File "C:\Program Files\XBMC\system\python\Lib\json\decoder.py", line 319, in decode
                                                obj, end = self.raw_decode(s, idx=_w(s, 0).end())
                                              File "C:\Program Files\XBMC\system\python\Lib\json\decoder.py", line 338, in raw_decode
                                                raise ValueError("No JSON object could be decoded")
                                            ValueError: No JSON object could be decoded

Cheers sirsmooth
Reply
#89
sirsmooth Wrote:I have just tested 1.1.6 on the eden beta and I get this error when it scrapes movies. (top 250 is fine but it comes back with 'no top250 information available' so I guess I have no movies from the top250!)

Code:
17:35:38 T:2576   ERROR: Error Type: <type 'exceptions.ValueError'>
17:35:38 T:2576   ERROR: Error Contents: No JSON object could be decoded
17:35:38 T:2576   ERROR: Traceback (most recent call last):
                                              File "C:\Documents and Settings\Gazza\Application Data\XBMC\addons\script.ratingupdate\resources\rating_scraper.py", line 521, in <module>
                                                if __movies__ == "true": Movies()
                                              File "C:\Documents and Settings\Gazza\Application Data\XBMC\addons\script.ratingupdate\resources\rating_scraper.py", line 247, in __init__
                                                complete = self.scan()
                                              File "C:\Documents and Settings\Gazza\Application Data\XBMC\addons\script.ratingupdate\resources\rating_scraper.py", line 328, in scan
                                                else: self.updating()
                                              File "C:\Documents and Settings\Gazza\Application Data\XBMC\addons\script.ratingupdate\resources\rating_scraper.py", line 288, in updating
                                                decode = json.loads( get_data )
                                              File "C:\Program Files\XBMC\system\python\Lib\json\__init__.py", line 307, in loads
                                                return _default_decoder.decode(s)
                                              File "C:\Program Files\XBMC\system\python\Lib\json\decoder.py", line 319, in decode
                                                obj, end = self.raw_decode(s, idx=_w(s, 0).end())
                                              File "C:\Program Files\XBMC\system\python\Lib\json\decoder.py", line 338, in raw_decode
                                                raise ValueError("No JSON object could be decoded")
                                            ValueError: No JSON object could be decoded

Cheers sirsmooth

No Data. Have you installed php-cgi?
have you scraped your movies with IMDB?
Open cmd prompt and type this:

C:\PATHWHEREUNZIPPED\php-cgi5.exe -q "C:\Documents and Settings\Gazza\Application Data\XBMC\addons\script.ratingupdate\resources\ratings.php" -d mid=tt0133093

the result should look like this:
{"Rating":"8.7","Votes":"498,417","Response":"True"}
LG M227WD - ASUS S1-AT5NM10E - LOGITECH HARMONY 300i - MINI KEYBOARD USB
Running Ubuntu Precise 12.04.04 - FRODO 12.03 - Transparency!
Movies: 996 - TV Show: 98 - Albums: 1161

My Script: Rating Update - Thumbnails Cleaner
Reply
#90
theowiesengrund Wrote:Anyone got this working on a mac?

I have linked to the php-cgi binary, but still not working...

Fixed in next release. I forgot Mac OS Blush
LG M227WD - ASUS S1-AT5NM10E - LOGITECH HARMONY 300i - MINI KEYBOARD USB
Running Ubuntu Precise 12.04.04 - FRODO 12.03 - Transparency!
Movies: 996 - TV Show: 98 - Albums: 1161

My Script: Rating Update - Thumbnails Cleaner
Reply
  •   
  • 1
  • 4
  • 5
  • 6(current)
  • 7
  • 8
  • 40
  •   
 
Thread Rating:
  • 7 Vote(s) - 5 Average



Logout Mark Read Team Forum Stats Members Help
[RELEASE] - Rating Update v1.4.357