On Sun, Aug 7, 2011 at 9:28 AM, Onkar Shinde <onkarshi...@ubuntu.com> wrote: > On Sat, Aug 6, 2011 at 2:30 PM, Mike Hommey <m...@glandium.org> wrote: >> On Sun, May 08, 2011 at 08:02:28AM +0200, Mike Hommey wrote: >>> On Sun, May 08, 2011 at 08:37:29AM +0530, Onkar Shinde wrote: >>> > On 5/4/11, Mike Hommey <m...@glandium.org> wrote: >>> > <snip> >>> > > This may be related to bug #560329. >>> > > Can you try the instructions from >>> > > http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=560329#40 ? >>> > </snip> >>> > >>> > I haven't lost my bookmarks or history. So I am definitely not >>> > affected by bug 560329. >>> > Following is the output of commands mentioned in the comment 40 of that >>> > bug. >>> > sqlite> select count(*) from moz_historyvisits; >>> > 3976 >>> > sqlite> select count(*) from moz_bookmarks; >>> > 121 >>> > >>> > What I noticed is that when I created new profile everything is >>> > working fine. So something has gone wrong with my default profile. >>> >>> Can you try copying that sqlite file from your default profile into the >>> new profile and see if that still works? >>> >>> Also, does it work if you start in safe mode? >> >> Did the instructions above lead somewhere? > > I thought I had replied to this. But it seems it completely slipped my mind. > > Starting the troubling profile in safe mode does not make any > difference. Also I copied the sqlite file from old profile to new > profile. It works perfectly in new profile. > > I am attaching here a diff of files/directories between old profile > and new profile. Please see if it gives any hint as to the source of > the problem. >
I found what the issue is. I noticed that in the troubling profile, search toolbar had no entries. So I thought may be the file causing problem is search.sqlite. When I tried to open this file with sqlitebrowser I got following error. onkar@iBook:~/.mozilla/firefox$ sqlitebrowser xn5aqxhc.default/search.sqlite could not get list of tables: 1, unsupported file format could not get list of tables: 1, unsupported file format So I deleted the file and restarted with the same profile that was causing problem. Everything works fine. So this indeed seems an issue related to sqlite, but not related to places.sqlite. I am attaching here the search.sqlite file from the profile back so that you can do further analysis if needed. Cheers, Onkar -- Passion - Some people climb mountains - others write Free software. Don't ask why - the reason is the same.
search.sqlite
Description: Binary data