Login at Kodi Home

lowfi · 2011-12-18, 18:58

I use a mysql DB and imdb scraper. When i run the script (1.1.5) i get the following error:

Code:
55:14 T:2908736368 WARNING: CreateLoader - Unsupported protocol(addons) in addons://more/executable.tbn

55:17 T:2815298416  NOTICE: -->Python Interpreter Initialized<--

55:17 T:2815298416  NOTICE: [Rating Update] - Starting Rating Update v1.1.5

55:17 T:2815298416  NOTICE: -->Python Interpreter Initialized<--

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

55:17 T:6125328   ERROR: GetArbitraryQuery failed

55:25 T:2815298416  NOTICE: [Rating Update] - The video library is empty or the IMDb id doesn't exist!

55:37 T:2873092976 WARNING: CreateLoader - Unsupported protocol(addons) in addons://more/executable.tbn

56:47 T:6125328  NOTICE: Samba is idle. Closing the remaining connections

This didnt happen with 1.1.0.

m4x1m · 2011-12-18, 20:54

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?

Mizaki · 2011-12-18, 21:20

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.

m4x1m · 2011-12-18, 21:55

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!

lowfi · 2011-12-20, 18:38

m4x1m Wrote:Version of mysql server?

MySQL version 5.1.41

m4x1m · 2011-12-21, 13:06

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.

lowfi · 2011-12-24, 17:30

Hmm how do i do this?

m4x1m · 2011-12-24, 18:52

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.

Ben91 · 2011-12-29, 16:47

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.

**gabbott** · 2011-12-29, 19:09

So anyone use this with openelec? Wondering if it's possible being that the script needs an install of php5-cgi

theowiesengrund · 2011-12-31, 00:47

Anyone got this working on a mac?

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

ezechiel1917 · (This post was last modified: 2011-12-31, 03:06 by ezechiel1917.)

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.

sirsmooth · 2012-01-01, 19:49

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

m4x1m · (This post was last modified: 2012-01-01, 20:44 by m4x1m.)

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"}

m4x1m · 2012-01-01, 21:13

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