[RELEASE] - Rating Update v1.3.7

  Thread Rating:
  • 4 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
m4x1m Offline
Fan
Posts: 307
Joined: Mar 2011
Reputation: 22
Location: Italy
Post: #136
krish_2k4 Wrote:haha, don't rattle your brain too much! this will do for now Cool

I love to rattle my brain!Wink

@clock2113
Big Grin

New Version:
script.ratingupdate-1.2.3.zip

Code:
v 1.2.3:
- Added positions with leading zeros and year of the movies to the exported file.

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
find quote
cosmicr Offline
Senior Member
Posts: 154
Joined: Oct 2010
Reputation: 1
Location: Australia
Post: #137
Eisi2005 Wrote:@m4x1m

is there any chance that you build a version without needing php ? Unhappily has my openelec distribution no php. Openelec is a closed system so i could not install any php versions.

Greets
Eisi
My script works in python. It doesn't have as many features though.
https://github.com/cosmicr/IMDB-Ratings-for-Movies
find quote
krish_2k4 Offline
Fan
Posts: 619
Joined: Aug 2010
Reputation: 9
Post: #138
m4x1m Wrote:I love to rattle my brain!Wink

@clock2113
Big Grin

New Version:
script.ratingupdate-1.2.3.zip

Code:
v 1.2.3:
- Added positions with leading zeros and year of the movies to the exported file.

You are awesome and a quick updater!

Addon works a treat and a nice list produced! Big Grin

No other real feedback to give besides it doing the job it intended to and more! Cheers!
(This post was last modified: 2012-02-27 22:34 by krish_2k4.)
find quote
Scidd0w Offline
Junior Member
Posts: 25
Joined: Dec 2010
Reputation: 0
Post: #139
m4x1m;
Great addon. Thank you very much!
I have a minor problem since I installed the latest version last week though. I'm using the transparency! skin, don't know if it's relevant.
Before updating when I went in the movie library to the movie information screen and selected extras, update rating. The movie rating was updated of that specific movie. Now when I do the same I see the new add-on menu underneath the movie information screen. It won't update the specific movie anymore.
find quote
m4x1m Offline
Fan
Posts: 307
Joined: Mar 2011
Reputation: 22
Location: Italy
Post: #140
Scidd0w Wrote:m4x1m;
Great addon. Thank you very much!
I have a minor problem since I installed the latest version last week though. I'm using the transparency! skin, don't know if it's relevant.
Before updating when I went in the movie library to the movie information screen and selected extras, update rating. The movie rating was updated of that specific movie. Now when I do the same I see the new add-on menu underneath the movie information screen. It won't update the specific movie anymore.

I also added the update rating for the single tvshow and then some changes have been made ​​for the skinners, upgrade T! to the latest svn version and the problem will go away.

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
find quote
Scidd0w Offline
Junior Member
Posts: 25
Joined: Dec 2010
Reputation: 0
Post: #141
Ok thank you for the quick reply.
I'd rather wait for the stable version of T! to be updated but I now know it will get fixed eventually. Smile
find quote
debunn Offline
Junior Member
Posts: 2
Joined: Mar 2012
Reputation: 0
Post: #142
Help please!

I've installed the v1.2.3 of Rating Update on XBMC Eden v11 (final), running on Win 7 x64. I also have installed PHP v5.3.10 to "c:\PHP".

When I run the script to update my existing movie set, it completes with 0 / 360 movies updated. With debugging turned on, my log shows:

http://pastebin.com/YrLT72nD

I should also add that running the script through the DOS command line (listed earlier in this thread) does return data from IMDB.

I would appreciate any help you can provide - please let me know if more details would help.

Thanks, Dave.
(This post was last modified: 2012-03-31 02:37 by debunn.)
find quote
debunn Offline
Junior Member
Posts: 2
Joined: Mar 2012
Reputation: 0
Post: #143
Just as a follow up for anyone else who may be experiencing this issue, I was able to get the scripts to run by performing two changes (all made to the "resources\lib\ratings_all.py" script):

1) Modifying all of the PHP script locations (at the top of the script) to be surrounded in double quotes (my Windows user directory contains a space)
2) Changing the os.popen commands to run a batch file instead of the included commands. For some reason, the direct calls to the php-cgi.exe were failing when made directly - having a batch file perform the commands instead seems to have resolved the issue. I'm guessing this has something to do with operating system compatibility (possibly with forward / back slash issues), but found this to be an easier solution than trying to figure out why the Python script was failing on Windows 7 x64.
find quote
m4x1m Offline
Fan
Posts: 307
Joined: Mar 2011
Reputation: 22
Location: Italy
Post: #144
(2012-04-11 14:58)debunn Wrote:  Just as a follow up for anyone else who may be experiencing this issue, I was able to get the scripts to run by performing two changes (all made to the "resources\lib\ratings_all.py" script):

1) Modifying all of the PHP script locations (at the top of the script) to be surrounded in double quotes (my Windows user directory contains a space)
2) Changing the os.popen commands to run a batch file instead of the included commands. For some reason, the direct calls to the php-cgi.exe were failing when made directly - having a batch file perform the commands instead seems to have resolved the issue. I'm guessing this has something to do with operating system compatibility (possibly with forward / back slash issues), but found this to be an easier solution than trying to figure out why the Python script was failing on Windows 7 x64.

Code:
v 1.1.9:
- Solved issue related for double quote in path for the Windows users. This is a temporary hack because if there are whitespaces in the path the script will not work.

The problem are the doublequote in the parameters line! I added in the first post Known Bugs voice with your post linked! Thanks!

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
(This post was last modified: 2012-04-17 11:35 by m4x1m.)
find quote
adsi Offline
Member
Posts: 81
Joined: Oct 2011
Reputation: 0
Post: #145
How does IMDB scarper work in rating? I always think it's automatically link to IMDB Web,,=,=
find quote
MCipher Offline
Junior Member
Posts: 9
Joined: Jan 2012
Reputation: 0
Post: #146
The scrapers are just used once - while adding a movie to the library. There are no further automatic updates to metadata afterwards (that's what this script is made for).
find quote
Josefin Offline
Junior Member
Posts: 47
Joined: Feb 2009
Reputation: 0
Location: Stockholm
Post: #147
(2012-04-11 14:58)debunn Wrote:  Just as a follow up for anyone else who may be experiencing this issue, I was able to get the scripts to run by performing two changes (all made to the "resources\lib\ratings_all.py" script):

1) Modifying all of the PHP script locations (at the top of the script) to be surrounded in double quotes (my Windows user directory contains a space)
2) Changing the os.popen commands to run a batch file instead of the included commands. For some reason, the direct calls to the php-cgi.exe were failing when made directly - having a batch file perform the commands instead seems to have resolved the issue. I'm guessing this has something to do with operating system compatibility (possibly with forward / back slash issues), but found this to be an easier solution than trying to figure out why the Python script was failing on Windows 7 x64.

Hello

I am having a little difficulties to follow you.

In 1, if the path is c:\PHP, in other words no spaces, can I ignore this change?
In 2, can you explain more about the BAT file? What should I change in ratings_all.py and how should the BAT file look like?


ps. I did some changes in the %appdata%\XBMC\userdata\addon_data\script.ratingupdate/settings.xml file: I changed the path to be C:/php/ (the other splash instead of the windows default splash). But I assume I must still do that BAT file thing.
(This post was last modified: 2012-05-31 20:59 by Josefin.)
find quote
papampi Offline
Senior Member
Posts: 164
Joined: Feb 2005
Reputation: 0
Post: #148
I get errors with mysql libraries !
I get this error :
Code:
17:41:04 T:2586831680   DEBUG: Python thread: start processing
17:41:04 T:2586831680  NOTICE: -->Python Interpreter Initialized<--
17:41:04 T:2586831680   DEBUG: Process - The source file to load is /home/payam/.xbmc/addons/script.ratingupdate/resources/lib/ratings_all.py
17:41:04 T:2586831680   DEBUG: Process - Setting the Python path to /home/payam/.xbmc/addons/script.ratingupdate/resources/lib:/home/payam/.xbmc/addons/script.module.xbmcswift/lib:/home/payam/.xbmc/addons/script.module.simplejson/lib:/home/payam/.xbmc/addons/script.module.myconnpy/lib:/home/payam/.xbmc/addons/script.module.beautifulsoup/lib:/usr/share/xbmc/addons/script.module.pil/lib:/home/payam/.xbmc/addons/script.common.plugin.cache/lib:/home/payam/.xbmc/addons/script.module.simple.downloader/lib:/home/payam/.xbmc/addons/script.module.parsedom/lib:/home/payam/.xbmc/addons/script.module.elementtree/lib:/usr/share/xbmc/addons/script.module.pysqlite/lib:/usr/lib/python2.7:/usr/lib/python2.7/plat-linux2:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload:/usr/local/lib/python2.7/dist-packages:/usr/lib/python2.7/dist-packages:/usr/lib/python2.7/dist-packages/PIL:/usr/lib/python2.7/dist-packages/gst-0.10:/usr/lib/python2.7/dist-packages/gtk-2.0:/usr/lib/pymodules/python2.7:/usr/lib/python2.7/dist-packages/ubuntu-sso-client:/usr/lib/python2.7/dist-packages/ubuntuone-client:/usr/lib/python2.7/dist-packages/ubuntuone-control-panel:/usr/lib/python2.7/dist-packages/ubuntuone-couch:/usr/lib/python2.7/dist-packages/ubuntuone-installer:/usr/lib/python2.7/dist-packages/ubuntuone-storage-protocol:/usr/lib/python2.7/dist-packages/wx-2.8-gtk2-unicode:
17:41:04 T:2586831680   DEBUG: Process - Entering source directory /home/payam/.xbmc/addons/script.ratingupdate/resources/lib
17:41:04 T:3014674176   DEBUG: ------ Window Init (/home/payam/.xbmc/addons/script.ratingupdate/resources/skins/Default/720p/script_rating_update-main.xml) ------
17:41:04 T:3014674176    INFO: Loading skin file: /home/payam/.xbmc/addons/script.ratingupdate/resources/skins/Default/720p/script_rating_update-main.xml
17:41:05 T:3014674176   DEBUG: SDLKeyboard: scancode: 6f, sym: 0111, unicode: 0000, modifier: 1000
17:41:05 T:3014674176   DEBUG: OnKey: up (f080) pressed, action is Up
17:41:06 T:3014674176   DEBUG: SDLKeyboard: scancode: 6f, sym: 0111, unicode: 0000, modifier: 1000
17:41:06 T:3014674176   DEBUG: OnKey: up (f080) pressed, action is Up
17:41:06 T:3014674176   DEBUG: SDLKeyboard: scancode: 6f, sym: 0111, unicode: 0000, modifier: 1000
17:41:06 T:3014674176   DEBUG: OnKey: up (f080) pressed, action is Up
17:41:06 T:3014674176   DEBUG: SDLKeyboard: scancode: 24, sym: 000d, unicode: 000d, modifier: 1000
17:41:06 T:3014674176   DEBUG: OnKey: return (f00d) pressed, action is Select
17:41:06 T:3014674176   DEBUG: ------ Window Deinit (/home/payam/.xbmc/addons/script.ratingupdate/resources/skins/Default/720p/script_rating_update-main.xml) ------
17:41:07 T:2586831680    INFO: Loading skin file: DialogYesNo.xml
17:41:07 T:3014674176   DEBUG: ------ Window Init (DialogYesNo.xml) ------
17:41:08 T:3014674176   DEBUG: SDLKeyboard: scancode: 71, sym: 0114, unicode: 0000, modifier: 1000
17:41:08 T:3014674176   DEBUG: OnKey: left (f082) pressed, action is Left
17:41:08 T:3014674176   DEBUG: SDLKeyboard: scancode: 24, sym: 000d, unicode: 000d, modifier: 1000
17:41:08 T:3014674176   DEBUG: OnKey: return (f00d) pressed, action is Select
17:41:08 T:3014674176   DEBUG: ------ Window Deinit (DialogYesNo.xml) ------
17:41:08 T:2586831680   ERROR: Exception in python script callback execution
17:41:08 T:2586831680   ERROR: Traceback (most recent call last):
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/gui.py", line 73, in onClick
17:41:08 T:2586831680   ERROR: Movies()
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/ratings_all.py", line 271, in __init__
17:41:08 T:2586831680   ERROR: self.Movies = self.listing()
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/ratings_all.py", line 298, in listing
17:41:08 T:2586831680   ERROR: match = RawXbmcDb.query( 'SELECT idMovie FROM movie' )
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/dbutils.py", line 16, in query
17:41:08 T:2586831680   ERROR: if RawXbmcDb_Connect is None: RawXbmcDb_Connect = findXbmcDb()
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/dbutils.py", line 67, in findXbmcDb
17:41:08 T:2586831680   ERROR: return mysql.connector.Connect( host = host, port = port, database = name, user = user, password = pswd )
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/__init__.py", line 45, in Connect
17:41:08 T:2586831680   ERROR: return MySQLConnection(*args, **kwargs)
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 366, in __init__
17:41:08 T:2586831680   ERROR: self.connect(*args, **kwargs)
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 411, in connect
17:41:08 T:2586831680   ERROR: ssl=(ssl_ca, ssl_cert, ssl_key))
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 441, in _open_connection
17:41:08 T:2586831680   ERROR: self.protocol.do_handshake()
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/protocol.py", line 326, in do_handshake
17:41:08 T:2586831680   ERROR: self.conn.open_connection()
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 327, in open_connection
17:41:08 T:2586831680   ERROR: raise errors.InterfaceError('%s' % e)
17:41:08 T:2586831680   ERROR: mysql.connector.errors
17:41:08 T:2586831680   ERROR: .
17:41:08 T:2586831680   ERROR: InterfaceError
17:41:08 T:2586831680   ERROR: :
17:41:08 T:2586831680   ERROR: an integer is required

then I changed /home/payam/.xbmc/addons/script.ratingupdate/resources/lib/dbutils.py and add this to it :
Code:
def findXbmcDb():
    type = mysql
    host = payam-ubuntu
    port = 3306
    name = None
    user = xbmc
    pswd = xbmc

and now I get this error :
Code:
17:47:34 T:3014674176   DEBUG: ------ Window Deinit (DialogYesNo.xml) ------
17:47:34 T:2758785856   ERROR: Exception in python script callback execution
17:47:34 T:2758785856   ERROR: Traceback (most recent call last):
17:47:34 T:2758785856   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/gui.py", line 73, in onClick
17:47:34 T:2758785856   ERROR: Movies()
17:47:34 T:2758785856   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/ratings_all.py", line 271, in __init__
17:47:34 T:2758785856   ERROR: self.Movies = self.listing()
17:47:34 T:2758785856   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/ratings_all.py", line 298, in listing
17:47:34 T:2758785856   ERROR: match = RawXbmcDb.query( 'SELECT idMovie FROM movie' )
17:47:34 T:2758785856   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/dbutils.py", line 16, in query
17:47:34 T:2758785856   ERROR: if RawXbmcDb_Connect is None: RawXbmcDb_Connect = findXbmcDb()
17:47:34 T:2758785856   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/dbutils.py", line 31, in findXbmcDb
17:47:34 T:2758785856   ERROR: type = mysql
17:47:34 T:2758785856   ERROR: UnboundLocalError
17:47:34 T:2758785856   ERROR: :
17:47:34 T:2758785856   ERROR: local variable 'mysql' referenced before assignment
any idea where is the problem ?

XBMC on :
Tronsmart S89 Quad Core - Finless Rom (waiting for Linux)
Atv1 + Crystall HD - Crystalbuntu
Raspberry Pi - Openelec overclocked
Xios DS - Linux Gotham the-hydra
xbox1, Atv2, iPad, Ubuntu, Ouya, Galaxy Note 10.1
find quote
m4x1m Offline
Fan
Posts: 307
Joined: Mar 2011
Reputation: 22
Location: Italy
Post: #149
(2012-07-20 15:21)papampi Wrote:  I get errors with mysql libraries !
I get this error :
Code:
17:41:04 T:2586831680   DEBUG: Python thread: start processing
17:41:04 T:2586831680  NOTICE: -->Python Interpreter Initialized<--
17:41:04 T:2586831680   DEBUG: Process - The source file to load is /home/payam/.xbmc/addons/script.ratingupdate/resources/lib/ratings_all.py
17:41:04 T:2586831680   DEBUG: Process - Setting the Python path to /home/payam/.xbmc/addons/script.ratingupdate/resources/lib:/home/payam/.xbmc/addons/script.module.xbmcswift/lib:/home/payam/.xbmc/addons/script.module.simplejson/lib:/home/payam/.xbmc/addons/script.module.myconnpy/lib:/home/payam/.xbmc/addons/script.module.beautifulsoup/lib:/usr/share/xbmc/addons/script.module.pil/lib:/home/payam/.xbmc/addons/script.common.plugin.cache/lib:/home/payam/.xbmc/addons/script.module.simple.downloader/lib:/home/payam/.xbmc/addons/script.module.parsedom/lib:/home/payam/.xbmc/addons/script.module.elementtree/lib:/usr/share/xbmc/addons/script.module.pysqlite/lib:/usr/lib/python2.7:/usr/lib/python2.7/plat-linux2:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload:/usr/local/lib/python2.7/dist-packages:/usr/lib/python2.7/dist-packages:/usr/lib/python2.7/dist-packages/PIL:/usr/lib/python2.7/dist-packages/gst-0.10:/usr/lib/python2.7/dist-packages/gtk-2.0:/usr/lib/pymodules/python2.7:/usr/lib/python2.7/dist-packages/ubuntu-sso-client:/usr/lib/python2.7/dist-packages/ubuntuone-client:/usr/lib/python2.7/dist-packages/ubuntuone-control-panel:/usr/lib/python2.7/dist-packages/ubuntuone-couch:/usr/lib/python2.7/dist-packages/ubuntuone-installer:/usr/lib/python2.7/dist-packages/ubuntuone-storage-protocol:/usr/lib/python2.7/dist-packages/wx-2.8-gtk2-unicode:
17:41:04 T:2586831680   DEBUG: Process - Entering source directory /home/payam/.xbmc/addons/script.ratingupdate/resources/lib
17:41:04 T:3014674176   DEBUG: ------ Window Init (/home/payam/.xbmc/addons/script.ratingupdate/resources/skins/Default/720p/script_rating_update-main.xml) ------
17:41:04 T:3014674176    INFO: Loading skin file: /home/payam/.xbmc/addons/script.ratingupdate/resources/skins/Default/720p/script_rating_update-main.xml
17:41:05 T:3014674176   DEBUG: SDLKeyboard: scancode: 6f, sym: 0111, unicode: 0000, modifier: 1000
17:41:05 T:3014674176   DEBUG: OnKey: up (f080) pressed, action is Up
17:41:06 T:3014674176   DEBUG: SDLKeyboard: scancode: 6f, sym: 0111, unicode: 0000, modifier: 1000
17:41:06 T:3014674176   DEBUG: OnKey: up (f080) pressed, action is Up
17:41:06 T:3014674176   DEBUG: SDLKeyboard: scancode: 6f, sym: 0111, unicode: 0000, modifier: 1000
17:41:06 T:3014674176   DEBUG: OnKey: up (f080) pressed, action is Up
17:41:06 T:3014674176   DEBUG: SDLKeyboard: scancode: 24, sym: 000d, unicode: 000d, modifier: 1000
17:41:06 T:3014674176   DEBUG: OnKey: return (f00d) pressed, action is Select
17:41:06 T:3014674176   DEBUG: ------ Window Deinit (/home/payam/.xbmc/addons/script.ratingupdate/resources/skins/Default/720p/script_rating_update-main.xml) ------
17:41:07 T:2586831680    INFO: Loading skin file: DialogYesNo.xml
17:41:07 T:3014674176   DEBUG: ------ Window Init (DialogYesNo.xml) ------
17:41:08 T:3014674176   DEBUG: SDLKeyboard: scancode: 71, sym: 0114, unicode: 0000, modifier: 1000
17:41:08 T:3014674176   DEBUG: OnKey: left (f082) pressed, action is Left
17:41:08 T:3014674176   DEBUG: SDLKeyboard: scancode: 24, sym: 000d, unicode: 000d, modifier: 1000
17:41:08 T:3014674176   DEBUG: OnKey: return (f00d) pressed, action is Select
17:41:08 T:3014674176   DEBUG: ------ Window Deinit (DialogYesNo.xml) ------
17:41:08 T:2586831680   ERROR: Exception in python script callback execution
17:41:08 T:2586831680   ERROR: Traceback (most recent call last):
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/gui.py", line 73, in onClick
17:41:08 T:2586831680   ERROR: Movies()
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/ratings_all.py", line 271, in __init__
17:41:08 T:2586831680   ERROR: self.Movies = self.listing()
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/ratings_all.py", line 298, in listing
17:41:08 T:2586831680   ERROR: match = RawXbmcDb.query( 'SELECT idMovie FROM movie' )
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/dbutils.py", line 16, in query
17:41:08 T:2586831680   ERROR: if RawXbmcDb_Connect is None: RawXbmcDb_Connect = findXbmcDb()
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/dbutils.py", line 67, in findXbmcDb
17:41:08 T:2586831680   ERROR: return mysql.connector.Connect( host = host, port = port, database = name, user = user, password = pswd )
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/__init__.py", line 45, in Connect
17:41:08 T:2586831680   ERROR: return MySQLConnection(*args, **kwargs)
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 366, in __init__
17:41:08 T:2586831680   ERROR: self.connect(*args, **kwargs)
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 411, in connect
17:41:08 T:2586831680   ERROR: ssl=(ssl_ca, ssl_cert, ssl_key))
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 441, in _open_connection
17:41:08 T:2586831680   ERROR: self.protocol.do_handshake()
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/protocol.py", line 326, in do_handshake
17:41:08 T:2586831680   ERROR: self.conn.open_connection()
17:41:08 T:2586831680   ERROR:   File "/home/payam/.xbmc/addons/script.module.myconnpy/lib/mysql/connector/connection.py", line 327, in open_connection
17:41:08 T:2586831680   ERROR: raise errors.InterfaceError('%s' % e)
17:41:08 T:2586831680   ERROR: mysql.connector.errors
17:41:08 T:2586831680   ERROR: .
17:41:08 T:2586831680   ERROR: InterfaceError
17:41:08 T:2586831680   ERROR: :
17:41:08 T:2586831680   ERROR: an integer is required

then I changed /home/payam/.xbmc/addons/script.ratingupdate/resources/lib/dbutils.py and add this to it :
Code:
def findXbmcDb():
    type = mysql
    host = payam-ubuntu
    port = 3306
    name = None
    user = xbmc
    pswd = xbmc

and now I get this error :
Code:
17:47:34 T:3014674176   DEBUG: ------ Window Deinit (DialogYesNo.xml) ------
17:47:34 T:2758785856   ERROR: Exception in python script callback execution
17:47:34 T:2758785856   ERROR: Traceback (most recent call last):
17:47:34 T:2758785856   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/gui.py", line 73, in onClick
17:47:34 T:2758785856   ERROR: Movies()
17:47:34 T:2758785856   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/ratings_all.py", line 271, in __init__
17:47:34 T:2758785856   ERROR: self.Movies = self.listing()
17:47:34 T:2758785856   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/ratings_all.py", line 298, in listing
17:47:34 T:2758785856   ERROR: match = RawXbmcDb.query( 'SELECT idMovie FROM movie' )
17:47:34 T:2758785856   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/dbutils.py", line 16, in query
17:47:34 T:2758785856   ERROR: if RawXbmcDb_Connect is None: RawXbmcDb_Connect = findXbmcDb()
17:47:34 T:2758785856   ERROR:   File "/home/payam/.xbmc/addons/script.ratingupdate/resources/lib/dbutils.py", line 31, in findXbmcDb
17:47:34 T:2758785856   ERROR: type = mysql
17:47:34 T:2758785856   ERROR: UnboundLocalError
17:47:34 T:2758785856   ERROR: :
17:47:34 T:2758785856   ERROR: local variable 'mysql' referenced before assignment
any idea where is the problem ?

Can you post your advancedsettings.xml content?

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
find quote
papampi Offline
Senior Member
Posts: 164
Joined: Feb 2005
Reputation: 0
Post: #150
(2012-07-21 15:52)m4x1m Wrote:  Can you post your advancedsettings.xml content?

here is my advancedsettings.xml

Code:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<advancedsettings>
<splash>false</splash>
<videoscanner>
<ignoreerrors>true</ignoreerrors> <!-- Set to true to silently ignore errors while scanning videos-->
</videoscanner>
   <videodatabase>
        <type>mysql</type>
        <host>192.168.1.14</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        <name>MyVideos</name>
    </videodatabase>
    <musicdatabase>
        <type>mysql</type>
        <host>192.168.1.14</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        <name>MyMusic</name>
    </musicdatabase>
<pathsubstitution>
    <substitute>
        <from>special://masterprofile/Thumbnails</from>
        <to>smb://user:pass@PAYAM-UBUNTU/XBMCThumbnails</to>
    </substitute>
</pathsubstitution>
</advancedsettings>

XBMC on :
Tronsmart S89 Quad Core - Finless Rom (waiting for Linux)
Atv1 + Crystall HD - Crystalbuntu
Raspberry Pi - Openelec overclocked
Xios DS - Linux Gotham the-hydra
xbox1, Atv2, iPad, Ubuntu, Ouya, Galaxy Note 10.1
(This post was last modified: 2012-07-21 17:05 by papampi.)
find quote
Post Reply