Updated griffith from 0.9 to 0.12 now it won't load

[Headz]

I used griffith 0.9 32bit on windows vista 32 bit without any problems for a while.
I backuped my movies and installed the 0.12 version , but this version won't start.
There open's a small box which says GRIFFITH "upgrading database" really fast
and then nothing.

Any help Please, i installed over 500 movies , thank you

Here's a post from the debug start option:

2010-10-14T17:37:27: DEBUG: Griffith(gconsole:85): Starting Griffith 0.12
2010-10-14T17:37:27: DEBUG: Griffith(gconsole:86): Platform: Windows-Vista-6.0.6002-SP2 (nt)
2010-10-14T17:37:27: DEBUG: Griffith(gconsole:87): Dependencies:
gtk :: 2.16.0
gtk.glade :: 2.16.0
sqlalchemy :: 0.6.3
sqlite3 :: 2.4.1
reportlab :: 2.4
PIL :: True
psycopg2 :: 2.2.1 (dt dec ext pq3)
MySQLdb :: 1.2.2.final.0
chardet :: 2.0.1
sqlite :: False
2010-10-14T17:37:27: DEBUG: Griffith(griffith:1451): config file used: C:\Users\Michel\AppData\Roaming\griffith\griffith.cfg
2010-10-14T17:37:27: INFO: Griffith(initialize:102): Using Griffith directory: C:\Users\Michel\AppData\Roaming\griffith
2010-10-14T17:37:27: INFO: Griffith(dbupgrade:135): Upgrading database to version 3...
Traceback (most recent call last):
  File "griffith", line 1466, in <module>
  File "griffith", line 113, in __init__
  File "C:\Program Files\Griffith\lib\sql.py", line 138, in __init__
    if not upgrade_database(self, v, config):
  File "C:\Program Files\Griffith\lib\gutils.py", line 315, in wrapped_f
    res = f(*args, **kwargs)
  File "C:\Program Files\Griffith\lib\dbupgrade.py", line 141, in upgrade_database
    db.tables.ratios.insert(bind=b).execute(name=u'16:9')
  File "sqlalchemy\sql\expression.pyo", line 1217, in execute
  File "sqlalchemy\engine\base.pyo", line 1722, in _execute_clauseelement
  File "sqlalchemy\engine\base.pyo", line 1237, in _execute_clauseelement
  File "sqlalchemy\engine\base.pyo", line 1268, in __execute_context
  File "sqlalchemy\engine\base.pyo", line 1367, in _cursor_execute
  File "sqlalchemy\engine\base.pyo", line 1360, in _cursor_execute
  File "sqlalchemy\engine\default.pyo", line 288, in do_execute
sqlalchemy.exc.IntegrityError: (IntegrityError) column name is not unique u'INSERT INTO ratios (name) VALUES (?)' (u'16:9',)

[mike]

Can you send me your backup via email? There is something broken in your database. Griffith can't upgrade your database to
version 0.12. It needs to be fixed manually.

[Headz]

Mailed the zip file backup to your email let me know if that's what you needed

[Drinko]

I too have been getting the exact same error after upgrading from 0.9 to 0.12
Could you perhaps post what exactly we should fix in our database as I imagine more people will have this?

[mike]

I found the bug. Current released version 0.12 can't successfully upgrade the database from pre-0.11 installations.
There are the following ways to solve it:
- upgrade to 0.11 first (installation and application start) after that change to 0.12
or
- install the version 0.12, don't start it, replace the file "dbupgrade.py" of the installation with the new one from the source code repository: http://svn.berlios.de/svnroot/repos/griffith/trunk/lib/dbupgrade.py
after that start griffith

[Drinko]

I've tried both ways and it still won't start but now the log-file contains the following error:

C:\Program Files\Griffith\griffith.exe:153: GtkWarning: gtk_widget_size_allocate(): attempt to allocate widget with width 453 and height -3
C:\Program Files\Griffith\griffith.exe:153: GtkWarning: gtk_widget_size_allocate(): attempt to allocate widget with width 449 and height -3

Both 0.11 and 0.12 give this error

[mike]

My fix works only for backups which should be restored or for databases which are not updated yet.
The problem is that the upgrade procedure breaks between two version and giffith can't recover it.

I need a debug log for more details. Please start griffith with the option "--debug" and post the output here.

[Drinko]

The debug-log is actually still exactly the same as the one Headz posted. The same goes for the debug-log for 0.11:

2010-10-17T23:42:29: DEBUG: Griffith(gconsole:85): Starting Griffith 0.12
2010-10-17T23:42:29: DEBUG: Griffith(gconsole:86): Platform: Windows-Vista-6.0.6002-SP2 (nt)
2010-10-17T23:42:29: DEBUG: Griffith(gconsole:87): Dependencies:
gtk :: 2.16.0
gtk.glade :: 2.16.0
sqlalchemy :: 0.6.3
sqlite3 :: 2.4.1
reportlab :: 2.4
PIL :: True
psycopg2 :: 2.2.1 (dt dec ext pq3)
MySQLdb :: 1.2.2.final.0
chardet :: 2.0.1
sqlite :: False
2010-10-17T23:42:29: DEBUG: Griffith(griffith:1451): config file used: C:\Users\Mike\AppData\Roaming\griffith\griffith.cfg
2010-10-17T23:42:29: INFO: Griffith(initialize:102): Using Griffith directory: C:\Users\Mike\AppData\Roaming\griffith
2010-10-17T23:42:29: INFO: Griffith(dbupgrade:135): Upgrading database to version 3...
Traceback (most recent call last):
  File "griffith", line 1466, in <module>
  File "griffith", line 113, in __init__
  File "C:\Program Files\Griffith\lib\sql.py", line 138, in __init__
    if not upgrade_database(self, v, config):
  File "C:\Program Files\Griffith\lib\gutils.py", line 315, in wrapped_f
    res = f(*args, **kwargs)
  File "C:\Program Files\Griffith\lib\dbupgrade.py", line 141, in upgrade_database
    db.tables.ratios.insert(bind=b).execute(name=u'16:9')
  File "sqlalchemy\sql\expression.pyo", line 1217, in execute
  File "sqlalchemy\engine\base.pyo", line 1722, in _execute_clauseelement
  File "sqlalchemy\engine\base.pyo", line 1237, in _execute_clauseelement
  File "sqlalchemy\engine\base.pyo", line 1268, in __execute_context
  File "sqlalchemy\engine\base.pyo", line 1367, in _cursor_execute
  File "sqlalchemy\engine\base.pyo", line 1360, in _cursor_execute
  File "sqlalchemy\engine\default.pyo", line 288, in do_execute
sqlalchemy.exc.IntegrityError: (IntegrityError) column name is not unique u'INSERT INTO ratios (name) VALUES (?)' (u'16:9',)

In griffith.exe.log the following line is added each time:
C:\Program Files\Griffith\lib\db\tables.py:32: SADeprecationWarning: The Binary type has been renamed to LargeBinary.

This happens both for when I first install 0.11, run it and then install 0.12 and when I just install 0.12 and use the dbupgrade.py you provided.

I however did not first revert to 0.9, should I do that first?

[mike]

Please try the new version 0.12.1.

[Drinko]

0.12.1 works for me, thanks

[neil_down]

Hi - 0.12.1 worked for me also. I upgraded from a version 0.9 database with approx 600 entries onto a 64-bit Windows 7 (clean install). Database upgrade took 3-4 minutes, all working fine. Many thanks.

[mike]

Nice to hear it.