Program fails with message "Updating Database" version .011

[Gandolf89]

Having upgraded to version 0.11 from 0.9.10, when I attempted to restore the database, I get the message "Updating Database" for several hours with no progress. I have tried reinstalling several times with no result. I have made several backups of the database on my other pc which is running version 0.9.10 with no problems. But I cannot get the database to restore in version .11.
I have also tried extracting the backup zip file directly into the "application Data/griffith " folder again without success.
Anyone had similar problems with this upgrade and if so what was the solution to resolving this issue.
Any suggestions welcome.
 
I have also ran debug with following error messages


2010-04-11T17:51:05: INFO: Griffith(dbupgrade:135): Upgrading database to version 3...
2010-04-11T17:51:05: ERROR: Griffith(backup:274):
Traceback (most recent call last):
  File "C:\Program Files\Griffith\lib\backup.py", line 249, in restore
  File "C:\Program Files\Griffith\lib\sql.py", line 127, in __init__
  File "C:\Program Files\Griffith\lib\gutils.py", line 315, in wrapped_f
  File "C:\Program Files\Griffith\lib\dbupgrade.py", line 141, in upgrade_database
  File "sqlalchemy\sql\expression.pyo", line 1121, in execute
  File "sqlalchemy\engine\base.pyo", line 1209, in _execute_clauseelement
  File "sqlalchemy\engine\base.pyo", line 874, in _execute_clauseelement
  File "sqlalchemy\engine\base.pyo", line 896, in __execute_context
  File "sqlalchemy\engine\base.pyo", line 950, in _cursor_execute
  File "sqlalchemy\engine\base.pyo", line 931, in _handle_dbapi_exception
IntegrityError: (IntegrityError) column name is not unique u'INSERT INTO ratios (name) VALUES (?)' [u'16:9']
2010-04-11T17:51:05: DEBUG: Griffith(backup:277): temporary directory no logger needed, removing c:\docume~1\keith\locals~1\temp\tmp2dldd0
Traceback (most recent call last):
  File "griffith", line 997, in restore
  File "C:\Program Files\Griffith\lib\backup.py", line 278, in restore
    rmtree(tmp_dir)
  File "shutil.pyo", line 180, in rmtree
  File "shutil.pyo", line 178, in rmtree
WindowsError: [Error 32] The process cannot access the file because it is being used by another process: 'c:\\docume~1\\keith\\locals~1\\temp\\tmp2dldd0\\griffith.db'

[mike]

Did you ever try another version of griffith than 0.9.10 and 0.11 (0.10 or a beta version)?
The problem is that in your database file exists a table with entries which should be inserted with version 0.10.
That step fails.
If you would you can send me your backup via email I will fix your database, upgrading it to 0.11 and send it back
to you.

[Gandolf89]

Mike
I missed out on version 0.10 and could not locate a copy to try. I have e-mailed my database to you as requested. Thank you.

Regards  Gandolf89

[Gandolf89]

Hi Mike
Many thanks for returning my database so promptly. The upgraded database worked a treat and I am now uptodate with version 0.11.

Kind regards
Gandolf89

[io4943]

Could you write, what should be change in db? I have the same problem and 0.11 not work with 0.10 database.

[mike]

I made a "special" version of griffith which jumps over the failing instructions and continues with the rest of the upgrade procedure.
I'm not sure if I can build it inside the next official version.

[io4943]

can you send me this version? io4943(at)gmail.com

[mike]

It's not a real version. It is only a modified file which I don't want to send out to anyone.
If somebody tries that file without understanding what it does it can destroy more than it fixes. Sorry.