Bug List: (This bug is not in your last search results)   Show last search results      Search page      Enter new bug
Bug#: 132686
Alias:
Product:
Component:
Status: RESOLVED
Resolution: FIXED
Assigned To: José Alberto Suárez López <bass@gentoo.org>
Hardware:
OS:
Version:
Priority:
Severity:
Reporter: orgoz2@gmail.com
Add CC:
CC:
Remove selected CCs
URL:
Summary:
Status Whiteboard:
Keywords:

Filename Description Type Creator Created Size Actions
listen-0.4.3.diff diff for sqlite dependency text/plain evilfuzzy1@yahoo.com 2006-05-27 20:33 0000 310 bytes Details
Create a New Attachment (proposed patch, testcase, etc.) View All

Bug 132686 depends on: Show dependency tree
Bug 132686 blocks:
Votes: 0    Show votes for this bug    Vote for this bug

Additional Comments: (this is where you put emerge --info)


Not eligible to see or edit group visibility for this bug.






View Bug Activity   |   Format For Printing   |   XML   |   Clone This Bug

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
Bug List: (This bug is not in your last search results)   Show last search results      Search page      Enter new bug