Opening Database from 2010

I am trying to recover my wife’s family tree. The last time she opened it was 2010. I currently have Gramps 5.2.3 installed on Ubuntu 24.04.

When I try to open the tree, I get a popup reading:

Low level database corruption detected
Gramps has detected a problem…
‘str’ object has no attribute ‘decode’

What do you suggest? Should I reinstall an antique version of Gramps to fix the database and then reinstall 5.2.3?

It looks like you possibly need the fix merged in pull request #1758.

This will be included in v5.2.4 which should be released shortly.

1 Like

If you are eager to get started and do not want to wait for 5.2.4 to be released, then “Yes” you can try a 3.2.6 version (covering the 3.0.x to 3.2.x versions of Gramps from that era). It still used the Schema 14. So you can sidestep the issue updating schema 14 to 16.

With any approach, the first step is to make a copy of the database folder for Gramps. Because every time the database is touched, the database backends update the file with an update to the connection history. Each experimental touch means a chance of corruption.

Once you backup and install version 3.2.6, set the database location (here is the Database Preferences docs for the 3.2 family), load the tree and export to the GRAMPS XML database format. Gramps 5.2.3 will be able to import that into a new tree in the modern SQLite database schema.

Link to the stable release archive on SourceForge:

1 Like

I’ll wait for 5.2.4. Thank you.

– Art Z.

1 Like

Note that “possibly” in the 5.2.4 suggestion. The highest confidence is with version from the same 2010 era.

However, the 5.2.4 will be the highest convenience… assuming there are no more problems than that schema conversion.

Version 5.2.4 didn’t help.

The dates on the files are from 2010. I built an Ubuntu 14.04 VM and installed Gramps 4.0.3-1 from the Ubuntu repo (apt install gramps). I get an error when trying to open the database and it suggests repairing it. When I try to repair it, I get this error:

76636: ERROR: grampsapp.py: line 114: Unhandled exception
Traceback (most recent call last):
  File "/usr/lib/python2.7/bsddb/dbshelve.py", line 237, in _shelf_callback
    return realCallback(priKey, data)
  File "/usr/lib/python2.7/dist-packages/gramps/gen/db/read.py", line 111, in find_byte_surname
    surn = __index_surname(data[3][5])
  File "/usr/lib/python2.7/dist-packages/gramps/gen/db/read.py", line 138, in __index_surname
    surn = " ".join([x[0] for x in surn_list if not (x[3][0] in [
IndexError: string index out of range

Any suggestions?

Version 4 is later (and for a different database schema) than the version suggested in my post above. You said 2010 and that means an earlier version.

The link provided was to the 3.2.6 version files in the official repository on SourceForge. This included MacOS .dmg files, Windows .exe files, Debian .deb files, and build-from-source .tar.gz archive. As an Ubuntu user, you will use the Debian package file.

Success. Gramps 3.2.6 won’t install on Ubuntu 14.04 because python-central is no longer available. But installing Ubuntu 10.04 (boy does that ring the nostalgia bells!) and then Gramps 3.2.6 allowed me to open the tree. I exported it and imported it into Gramps 5.2.4 and I have a smiling wife.

Thank you!

5 Likes

Now, be certain to set up the “Backup on exit” or Autobackup in the Preferences! (Automated backups use the “Exclude” Media option for the scheduled backups.)

And periodically make manual backups with “Include” option:

The automated backup is smart enough to NOT trigger where there have not been changes.

LOL so true. Backups are good! I’ve got a NAS for that. Backups were never the problem. Neglect was the problem.

1 Like