132686 2006-05-08 08:03 0000 Version-Bump : media-sound/listen-0.4.3 2006-06-01 17:15:24 0000 1 1 1 Unclassified Gentoo Linux Ebuilds unspecified All Linux RESOLVED FIXED http://listengnome.free.fr/ P2 enhancement --- 1 orgoz2@gmail.com bass@gentoo.org ed@catmur.co.uk gentoo@amielke.de gianluca.dallatorre@tiscali.it orgoz2@gmail.com 2006-05-08 08:03:23 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) 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? 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. evilfuzzy1@yahoo.com 2006-05-27 20:33:53 0000 Created an attachment (id=87702) diff for sqlite dependency bass@gentoo.org 2006-05-29 13:29:18 0000 *** Bug 134024 has been marked as a duplicate of this bug. *** bass@gentoo.org 2006-05-30 03:53:03 0000 Commited :) you need to re-emerge pysqlite ed@catmur.co.uk 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. ed@catmur.co.uk 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 87702 2006-05-27 20:33 0000 diff for sqlite dependency listen-0.4.3.diff text/plain LS0tIGxpc3Rlbi0wLjQuMi1yMi5lYnVpbGQJMjAwNi0wNS0yNyAxNzoyMToxMS4wMDAwMDAwMDAg LTA1MDAKKysrIGxpc3Rlbi0wLjQuMy5lYnVpbGQJMjAwNi0wNS0yNyAxNzoxOTo0MC4wMDAwMDAw MDAgLTA1MDAKQEAgLTMyLDYgKzMyLDcgQEAKIERFUEVORD0iJHtSREVQRU5EfQogCT49eDExLWxp YnMvZ3RrKy0yLjgKIAk+PXN5cy1hcHBzL2RidXMtMC41MAorCT49ZGV2LWRiL3NxbGl0ZS0zLjIu NwogCT49ZGV2LWxhbmcvcHl0aG9uLTIuMwogCT49ZGV2LXB5dGhvbi9weWd0ay0yLjYKIAk+PWRl di1weXRob24vZ3N0LXB5dGhvbi0wLjEwCg==