won't open sqlite3 file due to libdbi

[Thomas Templin]

Problem:
Gnucash refuses to open a sqlite3 file (Fehlendes Dateimodul - missing file-module)

Solution:
downgrade to libdbi1 Version 0.8.4-6 from saucy

$ apt-cache policy gnucash
gnucash:
  Installiert: 1:2.6.0-1

$ apt-cache policy libdbi1
libdbi1:
  Installiert: 0.8.4-6
  Installationskandidat: 0.9.0-1

[Robie Basak (racb)]

Adding libdbi task to close duplicate bug. Does this make gnucash completely unusable? Does gnucash just need a rebuild against the latest libdbi?

[Thomas Templin (coastgnu)]

> Does this make gnucash completely unusable?
It affects all gnucash files stored as sqlite3.
I would asume that due to libdbi1 it might also affect gnucash files stored in mysql or pgsql

GNUCash xml files seem not to be affected. Tested opening of an existing gnucash xml, didn't test a new file

> Does gnucash just need a rebuild against the latest libdbi?
This or a rebuild of libdbi (if build options of libdbi have changed)

[Thomas Templin (coastgnu)]

Also affects gnucash 2.6.1-1

$ apt-cache policy gnucash
gnucash:
  Installiert: 1:2.6.1-1

[Thomas Templin (coastgnu)]

It seems that libdbi1 and libdbd-mysql have to be the same version!

There is a mail on the german gnucash list:
 http://lists.gnucash.org/pipermail/gnucash-de/2014-January/008932.html

Due to the poster the problem dissapeared after upgrading libdbd-mysql to version 0.9

So libdbi1 and libdbd-mysql have to be the same version

The versions in trusty are:
$ apt-cache policy libdbi1 libdbd-sqlite3
libdbi1:
  Installiert: 0.8.4-6
  Installationskandidat: 0.9.0-1
[...]

libdbd-sqlite3:
  Installiert: 0.8.3-1+s-5ubuntu1
  Installationskandidat: 0.8.3-1+s-5ubuntu1
[...]

Upgrading libdbd-mysql to 0.9 will solve the problem, hopefully....
At least it did so in Debian

[Robie Basak (racb)]

Was this bug fixed in src:libdbi-drivers 0.9.0-2ubuntu2?

[Thomas Templin (coastgnu)]

Am Mittwoch 19 Februar 2014, 08:58:55 schrieb Robie Basak:
> Was this bug fixed in src:libdbi-drivers 0.9.0-2ubuntu2?
Yes!

[Robie Basak (racb)]

Thank you for confirming.