Griffith - media collection manager
February 06, 2012, 08:40:38 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: New mailing lists,
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: Griffith sqlalchemy  (Read 1406 times)
rabit
Newbie
*
Offline Offline

Posts: 1


View Profile
« on: July 04, 2010, 08:55:24 AM »

I am having trouble with a fresh install of griffith. I am running v0.11. Whenever I try to use the filter nothing happens. I ran griffith --debug in a console and this is what it returned.

** Message: pygobject_register_sinkfunc is deprecated (GtkWindow)
** Message: pygobject_register_sinkfunc is deprecated (GtkInvisible)
** Message: pygobject_register_sinkfunc is deprecated (GtkObject)
/usr/share/griffith/lib/db/tables.py:31: SADeprecationWarning: The Binary type has been renamed to LargeBinary.
  Column('data', Binary(1048576), nullable=False))
2010-07-03T23:41:49: DEBUG: Griffith(gconsole:86): Starting Griffith 0.11
2010-07-03T23:41:49: DEBUG: Griffith(gconsole:87): Platform: Linux-2.6.34-ARCH-x86_64-Intel-R-_Core-TM-2_Quad_CPU_Q6600_@_2.40GHz-with-glibc2.2.5 (posix)
2010-07-03T23:41:49: DEBUG: Griffith(gconsole:88): Dependencies:
gtk :: 2.17.0
gtk.glade :: 2.17.0
sqlalchemy :: 0.6.1
sqlite3 :: 2.4.1
reportlab :: 2.4
PIL :: True
psycopg2 :: False
MySQLdb :: False
chardet :: False
sqlite :: False
2010-07-03T23:41:49: DEBUG: Griffith(griffith:1467): config file used: /home/rabit/.griffith/griffith.cfg
2010-07-03T23:41:49: INFO: Griffith(initialize:102): Using Griffith directory: /home/rabit/.griffith
/usr/share/griffith/lib/initialize.py:140: GtkWarning: GtkSpinButton: setting an adjustment with non-zero page size is deprecated
  define_widgets(self, gtk.glade.XML(gf))
/usr/share/griffith/lib/widgets.py:364: DeprecationWarning: Use the new widget gtk.Tooltip
  self.widgets['tooltips'] = gtk.Tooltips()
/usr/share/griffith/lib/widgets.py:365: DeprecationWarning: Use the new widget gtk.Tooltip
  self.widgets['tooltips'].set_tip(self.widgets['preferences']['epdf_reader'], _('Define here the PDF reader you want to use within Griffith. Popular choices are xpdf, gpdf, evince or kpdf. Make sure you have this program installed and working first.'))
/usr/share/griffith/lib/widgets.py:366: DeprecationWarning: Use the new widget gtk.Tooltip
  self.widgets['tooltips'].set_tip(self.widgets['preferences']['spell_lang'], _("Here you can define the desired language to use while spell checking some fields. Use you locale setting. For example, to use european portuguese spell checking enter 'pt'"))
/usr/share/griffith/lib/widgets.py:367: DeprecationWarning: Use the new widget gtk.Tooltip
  self.widgets['tooltips'].set_tip(self.widgets['preferences']['mail_smtp_server'], _("Use this entry to define the SMTP server you want to use to send e-mails. On *nix systems, 'localhost' should work. Alternatively, you can use your Internet Service Provider's SMTP server address."))
/usr/share/griffith/lib/widgets.py:368: DeprecationWarning: Use the new widget gtk.Tooltip
  self.widgets['tooltips'].set_tip(self.widgets['preferences']['mail_email'], _("This is the from e-mail address that should be used to all outgoing e-mail. You want to include your own e-mail address here probably."))
/usr/share/griffith/lib/widgets.py:369: DeprecationWarning: Use the new widget gtk.Tooltip
  self.widgets['tooltips'].set_tip(self.widgets['preferences']['mail_smtp_port'], _("Here you can define the smtp server port to use. If you want to use your gmail account service to send e-mails, try to enter '587' here. Default (and the most common one) is '25'"))
/usr/share/griffith/lib/widgets.py:370: DeprecationWarning: Use the new widget gtk.Tooltip
  self.widgets['tooltips'].set_tip(self.widgets['preferences']['mail_use_tls'], _("If you need TLS support, please check this checkbox. This is needed, for example, when using gmail service to send your reminder e-mails."))
/usr/share/griffith/lib/plugins/extensions/__init__.py:70: DeprecationWarning: object.__new__() takes no parameters
  obj = object.__new__(class_, *args, **kwargs)
/usr/share/griffith/lib/initialize.py:537: DeprecationWarning:
  ext.toolbar_icon_widget = toolbar.insert_stock(module.toolbar_icon, module.description, None, ext._on_toolbar_icon_clicked, None, -1)
/usr/share/griffith/lib/main_treeview.py:152: DeprecationWarning: Use the new widget gtk.Tooltip
  self.widgets['tooltips'].set_tip(w['region'], self._regions[0]) # N/A
2010-07-03T23:41:50: DEBUG: Griffith(sql:262): SELECT movies.number, movies.o_title, movies.title, movies.director, movies.poster_md5, movies.genre, movies.seen, movies.year, movies.runtime, movies.rating
FROM movies ORDER BY movies.title ASC
2010-07-03T23:41:50: WARNING: Griffith(gutils:668): poster not available: 90aa97d6309c2d7d2f54b4b8912baf1d
2010-07-03T23:41:50: WARNING: Griffith(gutils:737): Can't create image file /home/rabit/.griffith/posters/90aa97d6309c2d7d2f54b4b8912baf1d_s.jpg for md5sum 90aa97d6309c2d7d2f54b4b8912baf1d
2010-07-03T23:41:50: INFO: Griffith(initialize:828): Spellchecker is not available
Traceback (most recent call last):
  File "/usr/bin/griffith", line 1129, in filter_txt
    quick_filter.change_filter(self)
  File "/usr/share/griffith/lib/quick_filter.py", line 46, in change_filter
    self.populate_treeview(statement)
  File "/usr/bin/griffith", line 976, in populate_treeview
    main_treeview.populate(self, statement, where)
  File "/usr/share/griffith/lib/main_treeview.py", line 374, in populate
    if qf and not movies or isinstance(movies, Select): # if ".execute().fetchall()" not invoked on movies yet
  File "/usr/lib/python2.6/site-packages/sqlalchemy/sql/expression.py", line 1296, in __nonzero__
    raise TypeError("Boolean value of this clause is not defined")
TypeError: Boolean value of this clause is not defined


The error seems to be spawning from sqlalchemy thought I am running the latest version. I found that running an olderversion of sqalchemy solves the problem but also rolls back griffith. Does anyone have any advice?
Logged
POX
Administrator
Hero Member
*****
Offline Offline

Posts: 512



View Profile WWW
« Reply #1 on: July 04, 2010, 10:39:51 PM »

try version from trunk (I really have to find some time to fix few things and release new version, maybe next weekend...)
Logged

Please, feel free to correct my English.
mike
Global Moderator
Hero Member
*****
Offline Offline

Posts: 989


View Profile WWW
« Reply #2 on: July 18, 2010, 08:52:43 PM »

I tried the current trunk of griffith with sqlalchemy 0.6.3. Works like a charm.
But I didn't check every function.
Logged
mike
Global Moderator
Hero Member
*****
Offline Offline

Posts: 989


View Profile WWW
« Reply #3 on: July 21, 2010, 08:21:59 PM »

I have to correct myself. I found an incompatibility.
Try to replace the following files of your installation with the new one from the repository:
http://svn.berlios.de/svnroot/repos/griffith/trunk/lib/advfilter.py
http://svn.berlios.de/svnroot/repos/griffith/trunk/lib/main_treeview.py
Logged
Nikos
Newbie
*
Offline Offline

Posts: 3


View Profile
« Reply #4 on: July 23, 2010, 09:17:09 PM »

Thank you,

I had found the reason for the problem on the sqlalchemy site, but since I have no clue of python I am very thankful for this fix!
Logged
colo
Newbie
*
Offline Offline

Posts: 37


View Profile
« Reply #5 on: September 03, 2010, 06:36:08 PM »

I have to correct myself. I found an incompatibility.
Try to replace the following files of your installation with the new one from the repository:
http://svn.berlios.de/svnroot/repos/griffith/trunk/lib/advfilter.py
http://svn.berlios.de/svnroot/repos/griffith/trunk/lib/main_treeview.py

Didn't work for me. Search on the main page still does not work. But thanks.
Logged
XYZ
Newbie
*
Offline Offline

Posts: 2


View Profile
« Reply #6 on: October 15, 2010, 02:41:16 PM »

Didn't work for me. Search on the main page still does not work. But thanks.
Didn't work for me too.
Griffith 0.12. under WinXPprof V2002 SP3
Still have the message: in griffith.exe.log:

C:\Programme\Griffith\lib\db\tables.py:32: SADeprecationWarning: The Binary type has been renamed to LargeBinary.

google shows some entries. The

http://code.google.com/p/formalchemy/issues/detail?id=144

as I understand (knowing nothing about formalchemy, sqlalchemy, python etc.)

it seems a change (needed) in the database of/for MYSQL... But I don't know, what to do Sad

However, Griffith is a great tool. Thanks, I have about 1300 movies in it.

Saludos from Paraguay
Wolfgang
« Last Edit: October 15, 2010, 02:46:31 PM by XYZ » Logged
mike
Global Moderator
Hero Member
*****
Offline Offline

Posts: 989


View Profile WWW
« Reply #7 on: October 17, 2010, 08:39:50 PM »

The message
Quote
C:\Programme\Griffith\lib\db\tables.py:32: SADeprecationWarning: The Binary type has been renamed to LargeBinary.
is only a warning/information not an error.

At the moment I think we speak from two different things. I speak from the search function which you can open with the
button in the toolbar which has a magnifying glass icon.
Logged
mike
Global Moderator
Hero Member
*****
Offline Offline

Posts: 989


View Profile WWW
« Reply #8 on: October 27, 2010, 09:40:17 PM »

Please try the new version 0.12.1.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.16 | SMF © 2006-2007, Simple Machines Valid XHTML 1.0! Valid CSS!