[ShadowTek]

I still get the error, Ive tried lots of different spaces, anyway thanks for the help, I'll keep working on it

EDIT: I think I got it running now, thanks!

EDIT:
Ok I think the space part is fixed but now I get this error:

Code:

16:39:28 T:2488  NOTICE: -->Python Interpreter Initialized<--
16:39:28 T:2488  NOTICE: [Rating Update] - Starting Rating Update v1.2.9
16:39:28 T:4376  NOTICE: Thread XBPyThread start, auto delete: false
16:39:28 T:4376  NOTICE: -->Python Interpreter Initialized<--
16:39:29 T:5080  NOTICE: Service: 69286 actors took 33.348000049591064
16:39:33 T:4376   ERROR: EXCEPTION Thrown (PythonToCppException) : -->Python callback/script returned the following error<--
                                             - NOTE: IGNORING THIS CAN LEAD TO MEMORY LEAKS!
                                            Error Type: <class 'sqlite3.OperationalError'>
                                            Error Contents: near "c12": syntax error
                                            Traceback (most recent call last):
                                              File "C:\Users\ShadowTek\AppData\Roaming\XBMC\addons\script.ratingupdate\resources\lib\gui.py", line 70, in onClick
                                                Movies()
                                              File "C:\Users\ShadowTek\AppData\Roaming\XBMC\addons\script.ratingupdate\resources\lib\ratings_all.py", line 260, in __init__
                                                complete = self.scan()
                                              File "C:\Users\ShadowTek\AppData\Roaming\XBMC\addons\script.ratingupdate\resources\lib\ratings_all.py", line 329, in scan
                                                else: self.updating()
                                              File "C:\Users\ShadowTek\AppData\Roaming\XBMC\addons\script.ratingupdate\resources\lib\ratings_all.py", line 306, in updating
                                                RawXbmcDb.execute( 'UPDATE movie SET c04="%s", c05="%s" c12="%s" WHERE c09="%s"' % (votes, rating, mpaa, self.movie[1] ) )
                                              File "C:\Users\ShadowTek\AppData\Roaming\XBMC\addons\script.ratingupdate\resources\lib\dbutils.py", line 30, in execute
                                                return RawXbmcDb.query( str )
                                              File "C:\Users\ShadowTek\AppData\Roaming\XBMC\addons\script.ratingupdate\resources\lib\dbutils.py", line 21, in query
                                                cursor.execute( str )
                                            OperationalError: near "c12": syntax error
                                            -->End of Python script error report<--

[Jandalf]

Code:

UPDATE movie SET c04="%s", c05="%s" c12="%s" WHERE c09="%s"' % (votes, rating, mpaa, self.movie[1] )

oh, a ',' before c12 should solve this...

[ShadowTek]

Code:

UPDATE movie SET c04="%s", c05="%s" c12="%s" WHERE c09="%s"' % (votes, rating, mpaa, self.movie[1] )

oh, a ',' before c12 should solve this...

That worked Thanks!!
Ok, I assume I run "Movies" correct? when I ran it.. it worked (no crash) but it didnt update the mpaa ratings.. Is there a way for it to simply update all mpaa for films (even if they dont need it) What I think is happening is normal scrapers do add mpaa, but they only add the "Rated R" or Rated PG" portion, I want to replace that with the full description.

For example the move "3:10 to Yuma (2007)" in my XBMC says "Rated R", but the full mpaa is "Rated R for violence and some language" So I think its seeing the Rated R and thinking its there so dont udate when it needs to replace it.

Thanks again for the help, other then that it seems to work

[Jandalf]

That worked Thanks!!
Ok, I assume I run "Movies" correct? when I ran it.. it worked (no crash) but it didnt update the mpaa ratings.. Is there a way for it to simply update all mpaa for films (even if they dont need it) What I think is happening is normal scrapers do add mpaa, but they only add the "Rated R" or Rated PG" portion, I want to replace that with the full description.

For example the move "3:10 to Yuma (2007)" in my XBMC says "Rated R", but the full mpaa is "Rated R for violence and some language" So I think its seeing the Rated R and thinking its there so dont udate when it needs to replace it.

Thanks again for the help, other then that it seems to work

Yes Movies is correct.

What exactly did you mean with "it didnt update the mpaa ratings".

I don't think that IMDB delivers this informations...

[ShadowTek]

Hi it does, Ember media manager for example scrapes this from IMDB. The XBMC just scraps the beginning of the mpaa though.

Well Im guessing that it is in fact updating, but only if the field is blank, which it never actually is, because the normal scraper puts the rating in there, so when this mod sees its not blank, it bypasses it. So if it replaces the mpaa rather then sees if its there I think it would work. I do have a idea though.. I could (after backing up the database) I can delete the mpaa tables then re-add them, this way they will be blank and thus the script will add them

Anyway thanks Jandalf for the help man. I can get it from here now

[Jandalf]

Hi it does, Ember media manager for example scrapes this from IMDB. The XBMC just scraps the beginning of the mpaa though.

Well Im guessing that it is in fact updating, but only if the field is blank, which it never actually is, because the normal scraper puts the rating in there, so when this mod sees its not blank, it bypasses it. So if it replaces the mpaa rather then sees if its there I think it would work. I do have a idea though.. I could (after backing up the database) I can delete the mpaa tables then re-add them, this way they will be blank and thus the script will add them

Anyway thanks Jandalf for the help man. I can get it from here now

Hm strange, of which country is this rating?

And normally Ratingupdate should update everything, where it finds a rating, cause you deleted the if clause...
Look into the xbmc log, there it should say that every movie was updated...

[ShadowTek]

Its United States, maybe I used the wrong initials?

EDIT Im running it again now

[Jandalf]

Its United States, maybe I used the wrong initials?

k now i get something:

try in ratings.php:
mpaa_reason() instead of mpaa() and without the country that give me with Avatar:
"MPAA":"Rated PG-13 for intense epic battle quences and warfare, sensuality, language and some smoking"

do you want that?

[ShadowTek]

YES!! That did it, works perfect (I alt tabbed out, its adding now) Works perfectly now man!! You are a genius!!!

[Jandalf]

YES!! That did it, works perfect (I alt tabbed out, its adding now) Works perfectly now man!! You are a genius!!!

No problem, I learned a lot with this story

[m4x1m]

Ok, you've convinced me.
I will add an option to recover the MPAA rating in the next release, only one thing ... be patient, now I'm busy, but I don't want abandon the project.

[ShadowTek]

Ok, you've convinced me.
I will add an option to recover the MPAA rating in the next release, only one thing ... be patient, now I'm busy, but I don't want abandon the project.

Sounds great I think allot of people will be thankful!

[boppyman]

HI m4x1m does this mod work with the UK ratings?

I ran it and it scanned the files but said 0 files were updated after.

[Jandalf]

HI m4x1m does this mod work with the UK ratings?

I ran it and it scanned the files but said 0 files were updated after.

do you mean the mpaa rating? this feature isn't implemented yet.

the star rating is country independent.

[boppyman]

OK thanks

I got a little confused i'm not after MPAA or UK ratings i just want to update the IMDB ratings.

So my question should have been, why are my files not updating