Closed GoogleCodeExporter closed 9 years ago
This is not actually a problem with the tool.
Full support for Firefox history is there, and nothing has changed in the
SQLite schema that causes the tool not be able to parse those history files.
THE problem is that with each new version of Firefox they seem to update their
SQLite driver, and those updates change the actual structure of the SQLite
file, and the Perl driver is not updated as frequently to solve those issue.
You can download the latest version of sqlite3 to parse those history files for
you, but you need to compile them from source since no distro can keep up with
this pace.
So this is really an issue that has to be taken to the author of the SQLite
Perl driver,
http://search.cpan.org/~adamk/DBD-SQLite-1.35/lib/DBD/SQLite.pm
According to CPAN they are:
Matt Sergeant <matt@sergeant.org>
Francis J. Lacoste <flacoste@logreport.org>
Wolfgang Sourdeau <wolfgang@logreport.org>
Adam Kennedy <adamk@cpan.org>
Max Maischein <corion@cpan.org>
Laurent Dami <dami@cpan.org>
Kenichi Ishigaki <ishigaki@cpan.org>
If you read the changelog for the project you can see:
Changes for Perl extension DBD-SQLite
1.35 Tue 29 Nov 2011
- Updated to SQLite 3.7.9 (ISHIGAKI)
- One small potential break case if you are using FTS4 and ^
And if you look at the source code they are using SQLite 3.7.10
README.MOZILLA inside db/sqlite3:
This is sqlite 3.7.10
-- Ryan VanderMeulen <ryanvm@gmail.com>, 01/2012
This is the reason this doesn't work... I can send an e-mail to the Perl
module's authors, otherwise there is not much I can do except to bail Perl's
mechanism completely...
Original comment by ki...@kiddaland.net
on 27 Apr 2012 at 8:35
I sent an e-mail to DBD::SQlite authors to see if they have any answers/update
on when support for version 3.7.10 could be expected.
Original comment by ki...@kiddaland.net
on 14 May 2012 at 12:05
Got a response from the authors on how to upgrade the module, did so and tested
it.
So it works from my computer, and I'm submitting a patch to the DBD::SQlite
module so that it can be updated.
This issue should then be "done" when an update to the module gets through the
Debian distro (and my patch has been merged into the project).
Original comment by ki...@kiddaland.net
on 14 May 2012 at 12:25
forgot to update the status
Original comment by ki...@kiddaland.net
on 14 May 2012 at 12:25
awesome news, thanks!
Original comment by mtrei...@gmail.com
on 14 May 2012 at 12:54
Talked to the developers of DBD::SQLite, they've updated the version to the
latest one and released version 1.36_03, which can now be downloaded using CPAN.
That means that I just need to contact the author of the Debian package to
update his, so this can get into the Debian repository, and FF history should
work again ;)
Original comment by ki...@kiddaland.net
on 14 May 2012 at 3:58
This is fixed.
There is a fix on the way from the DBD::SQlite developers, it's going through
testing, the quick fix is to do this yourself:
That is download the tar.gz from CPAN (update version information), download
the SQLite driver from the sqlite site, and copy sqlite.c/h to the CPAN module,
compile that again and install.
The authors of the SQLite module will release the new version soon, so it
should make it's way up the chain, until then the quick solution can be applied.
I can throw together a more detailed instructions on how to update the module
until then if anyone is interested, otherwise I consider this to be fixed.
Original comment by ki...@kiddaland.net
on 24 May 2012 at 6:11
Original issue reported on code.google.com by
mtrei...@gmail.com
on 13 Apr 2012 at 2:34