Bug#624502: iceweasel: URL bar not working anymore

[Onkar Shinde]

On Sun, Aug 7, 2011 at 9:28 AM, Onkar Shinde <onkarshinde at ubuntu.com> wrote:
> On Sat, Aug 6, 2011 at 2:30 PM, Mike Hommey <mh at 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 <mh at 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 at 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: search.sqlite
Type: application/octet-stream
Size: 2048 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-mozilla-maintainers/attachments/20110807/aa6b8f67/attachment.obj>