+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Help and Support (/forumdisplay.php?fid=33)
+--- Forum: Add-ons Help and Support (/forumdisplay.php?fid=27)
+---- Forum: Program Add-ons (/forumdisplay.php?fid=151)
+---- Thread: [RELEASE] - Rating Update (/showthread.php?tid=107331)
- 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
).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
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 - 2011-12-31 00:52
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 decodedCheers sirsmooth
- m4x1m - 2012-01-01 20:35
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
