http://bugs.gpodder.org/show_bug.cgi?id=347
--- Comment #2 from Andrew Bennett <[email protected]> 2009-02-10 10:21:04 --- (In reply to comment #1) > Try the following: > > $ sqlite3 ~/.config/gpodder/database.sqlite > sqlite> update channels set foldername=null, auto_foldername=1 where 1; Done. I also did '.exit' from sqlite3 before doing the next. > Then, try to restart gPodder and tell me if this fixes your problem. gPodder still is having issues. Here's the verbose: abenn...@e6400:~/gpodder$ make test bin/gpodder --local --verbose [ 0.076] Detected encoding: UTF-8 [ 0.089] (gPodderLib) Creating gPodderLib() [ 0.115] (ConverterCollection) Could not find "oggdec", ".ogg" files cannot be converted. [ 0.116] (tagupdate) eyed3 not found -- tag update disabled [ 0.140] (gpodder.sync) Could not find pymtp. [ 0.141] (gpodder.sync) Could not find pymad [ 0.141] (gpodder.sync) Could not find eyeD3 [ 0.212] (GPodderStatusIcon) Creating tray icon [ 0.397] (podcastChannel) Updating foldername of http://feedproxy.google.com/money-guycom to "Brian Preston's _Money Guy_ Blog and Podcast". [ 0.410] (podcastChannel) Updating foldername of http://www.financialsavvy.com/radio/jorg.xml to "Jorgensen on Money". [ 0.414] (podcastChannel) Updating foldername of http://feeds.wsjonline.com/wsj/podcast_the_journal_report to "The Journal Report". [ 0.421] (podcastChannel) Updating foldername of http://feeds.marketwatch.com/marketwatch/podcasts/marketwatchmorningstocktalk to "MarketWatch Morning Stock Talk". [ 0.428] (podcastChannel) Updating foldername of http://feeds.marketwatch.com/marketwatch/podcasts/takeontech to "Marketwatch Take On Tech". [ 0.445] (podcastChannel) Updating foldername of http://feeds.pbs.org/pbs/nbr-audio to "Nightly Business Report - NBR Podcast _ PBS". [ 0.456] (podcastChannel) Updating foldername of http://rbymradio.libsyn.com/rss to "Rob Black and Your Money - Radio". [ 0.467] (podcastChannel) Updating foldername of http://feeds.wsjonline.com/wsj/podcast_wall_street_journal_tech_news_briefing to "Wall Street Journal Tech News Briefing". [ 0.474] (podcastChannel) Updating foldername of http://feeds.wsjonline.com/wsj/podcast_wall_street_journal_this_morning to "Wall Street Journal This Morning". [ 0.482] (podcastChannel) Updating foldername of http://feeds.wsjonline.com/wsj/podcast_wall_street_journal_weekend_edition to "The Wall Street Journal Weekend Edition". [ 0.489] (podcastChannel) Updating foldername of http://feeds.wsjonline.com/wsj/podcast_your_money_matters to "Wall Street Journal's Your Money Matters". [ 0.494] (podcastChannel) Updating foldername of http://feeds.feedburner.com/trillianmedia/JVWE to "WealthTrack for AppleTV ( and others)". [ 0.498] (podcastChannel) Updating foldername of http://wealthtrack.libsyn.com/rss to "WealthTrack's Podcast". [ 0.500] (podcastChannel) Updating foldername of http://feeds.marketwatch.com/marketwatch/podcasts/yourmoneywithchuckjaffe to "Your Money with Chuck Jaffe". [ 0.505] (podcastChannel) Updating foldername of http://feedproxy.google.com/marketwatch/podcasts/yourmoneywithchuckjaffe to "Your Money with Chuck Jaffe". Traceback (most recent call last): File "bin/gpodder", line 171, in <module> sys.exit( main()) File "bin/gpodder", line 167, in main gui.main() File "/home/abennett/gpodder/src/gpodder/gui.py", line 4554, in main gPodder().run() File "/home/abennett/gpodder/src/gpodder/gui.py", line 136, in __init__ SimpleGladeApp.SimpleGladeApp.__init__( self, path, root, domain, **kwargs) File "/home/abennett/gpodder/src/gpodder/SimpleGladeApp.py", line 110, in __init__ self.new() File "/home/abennett/gpodder/src/gpodder/gui.py", line 690, in new self.update_feed_cache(force_update=gl.config.update_on_startup) File "/home/abennett/gpodder/src/gpodder/gui.py", line 1853, in update_feed_cache self.updateComboBox() File "/home/abennett/gpodder/src/gpodder/gui.py", line 1546, in updateComboBox gl.config.podcast_list_icon_size) File "/home/abennett/gpodder/src/gpodder/libpodcasts.py", line 982, in channels_to_model color_dict, cover_cache, max_width, max_height, True) File "/home/abennett/gpodder/src/gpodder/libpodcasts.py", line 969, in update_channel_model_by_iter pixbuf = services.cover_downloader.get_cover(channel, avoid_downloading=True) File "/home/abennett/gpodder/src/gpodder/services.py", line 204, in get_cover (url, pixbuf) = self.__get_cover(channel, custom_url, False, avoid_downloading) File "/home/abennett/gpodder/src/gpodder/services.py", line 226, in __get_cover if not async and avoid_downloading and not os.path.exists(channel.cover_file): File "/home/abennett/gpodder/src/gpodder/libpodcasts.py", line 524, in get_cover_file return os.path.join( self.save_dir, 'cover') File "/home/abennett/gpodder/src/gpodder/libpodcasts.py", line 501, in get_save_dir self.save() File "/home/abennett/gpodder/src/gpodder/libpodcasts.py", line 224, in save db.save_channel(self) File "/home/abennett/gpodder/src/gpodder/dbsqlite.py", line 354, in save_channel cur.execute("UPDATE channels SET url = ?, title = ?, override_title = ?, link = ?, description = ?, image = ?, pubDate = ?, sync_to_devices = ?, device_playlist_name = ?, username = ?, password = ?, last_modified = ?, etag = ?, channel_is_locked = ?, foldername = ?, auto_foldername = ?, deleted = 0 WHERE id = ?", (c.url, c.title, c.override_title, c.link, c.description, c.image, self.__mktime__(c.pubDate), c.sync_to_devices, c.device_playlist_name, c.username, c.password, c.last_modified, c.etag, c.channel_is_locked, c.foldername, c.auto_foldername, c.id, )) sqlite3.IntegrityError: column foldername is not unique [ 3.384] start reader [ 3.490] (UserAppsReader) Player found: /usr/share/applications/rhythmbox.desktop [ 3.492] (UserAppsReader) Player found: /usr/share/applications/totem.desktop [ 3.584] end reader (benchmark: 0.2002 seconds) make: *** [test] Error 1 abenn...@e6400:~/gpodder$ > Do you have podcasts that have the same name? If it does not work, please send > me a copy of: > > Your ~/.config/gpodder folder and > your gpodder-downloads folder (you can replace the "big" files in there with > zero-size files of the same name for sending). I do have two podcasts that have the same name as you can see in my description of this issue. 'feeds.marketwatch.com' hosts one of the two, and the other is at 'feedproxy.google.com'. Both are called "Your Money with Chuck Jaffe" (see bug 250 with a possible gpodder issue for this podcast RSS - although no new issues have been posted since end of Nov 2008). I will attach my ~/config/gpodder folder, probably as a tar.gz file. My gpodder-downloads directory is quite large - 17 folders and about 210 files. What would you like me to do with it remotely without filling out 0 size files (which will take some time)? -- Configure bugmail: http://bugs.gpodder.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes. _______________________________________________ gPodder-Bugs mailing list [email protected] https://lists.berlios.de/mailman/listinfo/gpodder-bugs
