Bug 132686 - Version-Bump : media-sound/listen-0.4.3
Bug#: 132686 Product:  Gentoo Linux Version: unspecified Platform: All
OS/Version: Linux Status: RESOLVED Severity: enhancement Priority: P2
Resolution: FIXED Assigned To: bass@gentoo.org Reported By: orgoz2@gmail.com
Component: Ebuilds
URL:  http://listengnome.free.fr/
Summary: Version-Bump : media-sound/listen-0.4.3
Keywords:  
Status Whiteboard: 
Opened: 2006-05-08 08:03 0000
Description:   Opened: 2006-05-08 08:03 0000
* Many bugs fixed see changelog for more detail (Many thanks to Ed Catmur for
his patch)
* New Cover search Dialog
* Improve usability (like right clic + treeview multiple selection)

------- Comment #1 From evilfuzzy1@yahoo.com 2006-05-27 19:21:40 0000 -------
It compiles if you change the ebuild name.  However when launching listen, it
crashes:
  File "/usr/lib/listen/db_manager.py", line 520, in __init__
    self.cur.execute( requete_albums_view )
pysqlite2.dbapi2.OperationalError: near "as": syntax error

Commenting out that line and it crashes due to the next line:
  File "/usr/lib/listen/db_manager.py", line 521, in __init__
    self.cur.execute( requete_artists_view )
pysqlite2.dbapi2.OperationalError: near "DISTINCT": syntax error

Commenting both and it has no fatal errors.  I don't know sqlite so I'm not
sure where it's going wrong.  Anyone with similar problems and/or a solution?

------- Comment #2 From evilfuzzy1@yahoo.com 2006-05-27 20:32:53 0000 -------
I'll take that comment back. It just occured to me to check sqlite versions. 
Listen only properly works versions of sqlite in portage at 3.2.7-r1 or
greater.    Adding a diff to add the dependency.

Works fine now.

------- Comment #3 From evilfuzzy1@yahoo.com 2006-05-27 20:33:53 0000 -------
Created an attachment (id=87702) [details]
diff for sqlite dependency

------- Comment #4 From José Alberto Suárez López 2006-05-29 13:29:18 0000 -------
*** Bug 134024 has been marked as a duplicate of this bug. ***

------- Comment #5 From José Alberto Suárez López 2006-05-30 03:53:03 0000 -------
Commited :)
you need to re-emerge pysqlite

------- Comment #6 From Ed Catmur 2006-06-01 17:04:42 0000 -------
Uh, wtf? 

Listen works fine here with sqlite 3.3.5-r1.

Also, the DEPEND strings are totally bogus; the gst plugins should be in
RDEPEND and not in DEPEND, while gtk etc. should be in both DEPDEND and
RDEPEND.

------- Comment #7 From Ed Catmur 2006-06-01 17:15:24 0000 -------
Can't be bothered to save a diff, but it's on my server:

http://catmur.co.uk/cgi-bin/viewcvs/viewcvs.cgi/svn/gentoo/tree/media-sound/listen/listen-0.4.3.ebuild?r1=476&r2=477&diff_format=h