http://bugzilla.novell.com/show_bug.cgi?id=543747 Summary: Banshee missing codec search CGI error Classification: openSUSE Product: openSUSE 11.2 Version: Milestone 8 Platform: i686 OS/Version: Other Status: NEW Severity: Normal Priority: P5 - None Component: Banshee AssignedTo: abockover@novell.com ReportedBy: novellbmw@lsmod.de QAContact: abockover@novell.com Found By: --- User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.1.22) Gecko/20090605 SUSE/1.1.17-1.3 SeaMonkey/1.1.17 the opensuse Banshee/gstreamer-multimedia codec search CGI returns a SQL error message Reproducible: Always Steps to Reproduce: 1. in gnome open nautilus 2. open audio file with unknown codec (e.g. wav with ADPCM) 3. click OK when asked to search codec Actual Results: firefox opens with http://software.opensuse.org/codecs?client_version=10.3.1&lang=de_DE.UTF-8&os_release=openSUSE%2011.2%20Milestone%208%20%28i586%29&kernel=2.6.31-10-default&gstreamer=gstreamer-utils-0.10.24-2.7.i586&plugin0=gstreamer|0.10|Banshee|DVI%20ADPCM-Decoder|decoder-audio%2fx-adpcm%2c%20layout%3d%28string%29dvi showing Error Server said: Mysql::Error: Unknown column 'fourcc' in 'where clause': SELECT * FROM `visitors` WHERE (created_at > '2009-10-02 08:36:49' AND ip_address = '87.159.202.44' AND fourcc IN ('decoder-audio/x-adpcm, layout=(string)dvi')) LIMIT 1 Expected Results: should show missing codec for installation (best with OneClickInstall) -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.