Search returns incorrect results

[Tony McKenzie]

Binary package hint: banshee

wishlist, Search utility should mimic Rhythmbox, including the "find as you type" feature unless an "advanced search" box is checked under preferences. Searching is to complex to be a basic feature imo. After following the "help" on searching I still can't get it to search properly.

1.2.1 hardy

[Andrew Conkling (andrewski)]

Can you provide an example of what you mean? What are you hoping to search for and what's coming up as a result?

[Tony McKenzie (mckenzie-tony)]

If i search for "Sublime" it will get to "b" before it has no results left even though i have 274 songs by them some with their name in the track. Adding an "artist:" tag to it doesn't help and this can be duplicated on almost any of my music.

[Tony McKenzie (mckenzie-tony)]

Another wishlist for search utility would be after typing a search, if you backspace to a blank it should return you to the last artist/album that you clicked on or atleast the current playing track artist/album/track.

[bvc310 (bvc310)]

I have this same problem. I attempt to search for an artist that I have many songs and albums by in the search box and it never returns the correct results, most often returning no songs found. I don't recall having this problem in ubuntu 8.04 but I have recently moved to 8.10 and noticed this happening and it is really frustrating. If there is a fix, I would love to know what it is and how to implement it.

[Chow Loong Jin (hyperair)]

On Thu, 2008-11-13 at 04:30 +0000, bvc310 wrote:
> I have this same problem. I attempt to search for an artist that I have
> many songs and albums by in the search box and it never returns the
> correct results, most often returning no songs found. I don't recall
> having this problem in ubuntu 8.04 but I have recently moved to 8.10 and
> noticed this happening and it is really frustrating. If there is a fix,
> I would love to know what it is and how to implement it.
>
A screenshot please? Or an example of what kind of results you get for
what terms? Perhaps your ~/.config/banshee-1/banshee.db file is
corrupted. Try deleting that file, then reimporting your music.
--
Chow Loong Jin

[bvc310 (bvc310)]

Heres Banshee prior to search as well as after attempting to begin searching for Muse. As you can see, after the first two letters it returns no results. I tried deleting my .db file and reimporting my music and the same result happens.

[bvc310 (bvc310)]

Sorry, here is the screenshot after the search is begun

[bvc310 (bvc310)]

Update: I seem to have corrected the issue by closing banshee and deleting both the ~/.config/banshee-1/banshee.db and the ~/.config/banshee/banshee.db files. It appears that one of those databases became corrupted and would not yield correct search results.

[Chow Loong Jin (hyperair)]

On Fri, 2008-11-14 at 00:21 +0000, bvc310 wrote:
> Update: I seem to have corrected the issue by closing banshee and
> deleting both the ~/.config/banshee-1/banshee.db and the
> ~/.config/banshee/banshee.db files. It appears that one of those
> databases became corrupted and would not yield correct search results.
>

Marking this invalid, since the issue seems to come from a corrupted
database.

  status invalid
--
Chow Loong Jin

[Andrew Conkling (andrewski)]

On Tue, Nov 18, 2008 at 1:08 PM, hyperair <email address hidden> wrote:

> Marking this invalid, since the issue seems to come from a corrupted
> database.

But how did the database become corrupted? I wonder if Banshee could
possibly have done something incorrect to cause this?

[Chow Loong Jin (hyperair)]

On Tue, 2008-11-18 at 19:55 +0000, Andrew Conkling wrote:
> On Tue, Nov 18, 2008 at 1:08 PM, hyperair <email address hidden> wrote:
>
> > Marking this invalid, since the issue seems to come from a corrupted
> > database.
>
>
> But how did the database become corrupted? I wonder if Banshee could
> possibly have done something incorrect to cause this?
>
I don't know, there are many factors that can cause the database to be
corrupted. Perhaps a previous crash, or maybe a power loss or something.
I don't claim to be an expert of sqlite, but I believe it might have
been some issue with the indexes.
--
Chow Loong Jin

[Chow Loong Jin (hyperair)]

On Tue, 2008-11-18 at 19:55 +0000, Andrew Conkling wrote:
> On Tue, Nov 18, 2008 at 1:08 PM, hyperair <email address hidden> wrote:
>
> > Marking this invalid, since the issue seems to come from a corrupted
> > database.
>
>
> But how did the database become corrupted? I wonder if Banshee could
> possibly have done something incorrect to cause this?

Recently a new bug (Bug 299969) was filed regarding this issue. Could
the database corruption be caused by faulty database migration code from
0.13.x?
--
Chow Loong Jin

[elsaturnino (elsaturnino-gmail)]

Looks like deleting banshee.db from ~/.config/banshee(-1) fixed the problem for me. Something must be wrong with the upgrade from 0.13.x although I thought we would have heard more reports about it from people upgrading from ubuntu 8.04 to 8.10.