Restore backup not working on Windows 7

[Pepe Vazquez]

In version 0.13, when I try to restore a backup, it does nothing. That same copy restored to the previous version (0.12.1) works perfectly.

[Piotr Ożarowski (piotr)]

fixed in SVN already¹. Just replace backup.py file or wait for 0.13.1

[¹] http://svn.berlios.de/wsvn/griffith/trunk/lib/backup.py?op=diff&rev=1610&peg=1610

[Wolfgang Allinger (all2001)]

I have exactly the same problem under win7enterprise and v0.13
v0.12.? works
However I would like some progress (bar) information while restoring.
I have a database with 2000 films and that takes about 5min without any information, if restore is
working :(
However, thanks for your great griffith!

[Guillermo Sánchez (sanchezdecicco)]

Hello,
I have the same problem under Windows8, but the link you posted seems to be broken.
Does anyone have a new link to download "backup.py" file?

Thanx!

[Michael (mikej06)]

Please try this one:

http://bazaar.launchpad.net/~piotr/griffith/trunk/view/head:/lib/backup.py

[Guillermo Sánchez (sanchezdecicco)]

Thank you for updating the file, but it still doesn´t work.
It looks like is restoring the database, but when it finish there is nothing.

Does anyone knows what can I do?

Thanx!

[Michael (mikej06)]

Please start griffith in debug mode (that's a separat link in the start menu).
After that try to restore your backup.
In the debug window there should be some entries now. Please post them here.

[Guillermo Sánchez (sanchezdecicco)]

Sorry for the delay.
That´s what it said, (copy & paste):

2014-11-13T12:36:31: DEBUG: Griffith(gconsole:82): Starting Griffith 0.13
2014-11-13T12:36:31: DEBUG: Griffith(gconsole:83): Platform: Windows-post2008Server-6.2.9200 (nt)
2014-11-13T12:36:31: DEBUG: Griffith(gconsole:84): Dependencies:
gtk :: 2.22.0
gtk.glade :: 2.22.0
sqlalchemy :: 0.7.1
sqlite3 :: 2.6.0 (sqlite-lib 3.6.21)
reportlab :: 2.5
PIL :: True
psycopg2 :: 2.3.1 (dt dec pq3 ext)
MySQLdb :: 1.2.3.final.0
chardet :: 2.0.1
sqlite :: False
lxml :: True
2014-11-13T12:36:31: DEBUG: Griffith(griffith:1469): config file used: C:\Users\William\AppData\Roaming\griffith\griffith.cfg
2014-11-13T12:36:31: INFO: Griffith(initialize:101): Using Griffith directory: C:\Users\William\AppData\Roaming\griffith
C:\Program Files (x86)\Griffith\lib\initialize.py:140: GtkWarning: GtkSpinButton: setting an adjustment with non-zero page size is deprecated
2014-11-13T12:36:32: DEBUG: Griffith(sql:279): SELECT movies.number, movies.o_title, movies.title, movies.director, movies.poster_md5, movies.genre, movies.seen, movies.year, movies.runtime, movies.rating, movies.created, movies.updated
FROM movies ORDER BY movies.number ASC
2014-11-13T12:36:32: INFO: Griffith(initialize:873): Spellchecker is not available
C:\Users\William\Desktop\griffith_backup_2014-09-08\griffith.db
2014-11-13T12:37:05: INFO: Griffith(dbupgrade:42): Creating new database...
2014-11-13T12:37:06: DEBUG: Griffith(backup:127): replacing old database with new one
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing collections table
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing volumes table
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing tags table
2014-11-13T12:37:07: DEBUG: Griffith(backup:142): inserting new data...
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing subformats table
2014-11-13T12:37:07: DEBUG: Griffith(backup:142): inserting new data...
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing ratios table
2014-11-13T12:37:07: DEBUG: Griffith(backup:142): inserting new data...
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing acodecs table
2014-11-13T12:37:07: DEBUG: Griffith(backup:142): inserting new data...
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing configuration table
2014-11-13T12:37:07: DEBUG: Griffith(backup:142): inserting new data...
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing languages table
2014-11-13T12:37:07: DEBUG: Griffith(backup:142): inserting new data...
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing media table
2014-11-13T12:37:07: DEBUG: Griffith(backup:142): inserting new data...
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing filters table
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing people table
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing vcodecs table
2014-11-13T12:37:07: DEBUG: Griffith(backup:142): inserting new data...
2014-11-13T12:37:07: DEBUG: Griffith(backup:138): ... processing achannels table
2014-11-13T12:37:07: DEBUG: Griffith(backup:142): inserting new data...
2014-11-13T12:37:0...

[Michael (mikej06)]

I can't find any error in the debug output.
The only way would be that you send me your backup. So I can test the restoring process.

[Guillermo Sánchez (sanchezdecicco)]

Here you are: https://www.wetransfer.com/downloads/a5548264f538d95e1d363602d909745020141121192522/4e33ab0aba00f09fbb99397780de676020141121192522/081f38

Thanx!

[Michael (mikej06)]

I'm not sure what's wrong with the restoring process in your particular case but you have another option:

1. exit from griffith
2. Please copy the files griffith.db and griffith.cfg from you backup archive to the following directory:
%APPDATA%\griffith
3. start griffith

The %APPDATA% is a place holder which is automatically replaced by windows.

[Guillermo Sánchez (sanchezdecicco)]

Yes!
It finally seems to work!
Thank you soooo much!
I really appreciate your help!

[Guillermo Sánchez (sanchezdecicco)]

Ok, now that I have my database restored, the imdb or filmaffinity plugin doesn´t work when I try to add a new movie or modify an existing one.
is there anything I can do to solve it?

thanx in advance!

[Guillermo Sánchez (sanchezdecicco)]

I red this post: https://bugs.launchpad.net/griffith/+bug/1084608 and it's already fixed.
Thank you!!