Version:           1.4.5 (using KDE KDE 3.5.6)
Installed from:    Gentoo Packages
Compiler:          gcc version 4.1.1 (Gentoo 4.1.1) CFLAGS="-Os -march=pentium-m -pipe -fomit-frame-pointer -ftracer -fweb -fvar-tracking -fvisibility-inlines-hidden"
OS:                Linux

Amarok keeps crashing when I try and search for a song. The words it especially crashes with are "linger" at the 'e' and "london" at the second 'o'. The full error message is below.

amarok: [CollectionDB] MYSQL QUERY FAILED: Unknown column 'statistics.name' in 'field list'
amarok: FAILED QUERY: SELECT DISTINCT BINARY statistics.name FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN statistics ON statistics.url=tags.url AND statistics.deviceid = tags.deviceid  WHERE 1 AND tags.sampler = 0 AND ( 0 OR artist.name = BINARY 'Cranberries' ) AND ( 0 OR album.name = BINARY '' ) AND ( 0 OR ( 0 OR album.name  LIKE '%linge%' ESCAPE '/' OR artist.name  LIKE '%linge%' ESCAPE '/' OR tags.title  LIKE '%linge%' ESCAPE '/'  )  )  AND tags.deviceid IN (1,2,3,4,5,6,7,8,9,12,-1) ORDER BY LOWER( statistics.name ) ;




For more info,

xushi@xushitop ~ $ emerge --info
Portage 2.1.2.2 (default-linux/x86/2006.1/desktop, gcc-4.1.1, glibc-2.5-r0, 2.6.20-ck1 i686)
=================================================================
System uname: 2.6.20-ck1 i686 Intel(R) Pentium(R) M processor 1.73GHz
Gentoo Base System release 1.12.9
Timestamp of tree: Thu, 15 Mar 2007 07:50:01 +0000
ccache version 2.4 [enabled]
dev-java/java-config: 1.3.7, 2.0.31-r4
dev-lang/python:     2.3.5-r3, 2.4.3-r4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.4-r6
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.61
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.14
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.17-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-Os -march=pentium-m -pipe -fomit-frame-pointer -ftracer -fweb -fvar-tracking -fvisibility-inlines-hidden"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config /var/bind"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/php/apache1-php5/ext-active/ /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c"
CXXFLAGS="-Os -march=pentium-m -pipe -fomit-frame-pointer -ftracer -fweb -fvar-tracking -fvisibility-inlines-hidden"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig ccache distlocks metadata-transfer sandbox sfperms strict"
GENTOO_MIRRORS="ftp://gentoo.imj.fr/pub/gentoo/ "
LANG="en.US.UTF-8"
LC_ALL="en_US.UTF-8"
LINGUAS="en uk en_US en_GB ar he et"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages --filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="X a52 aac acpi addbookmarks adns alias alsa amarok amr amuled apache2 apm asf atk automount autoreplace bash-completion berkdb bidi bindist bitmap-fonts branding browserplugin bzip2 bzlib cairo cddb cdinstall cdparanoia cdr cjk clamav clamd cli connectionstatus contactnotes cpdflib cpudetection cracklib crypt css cups curl curlwrappers cvs dba dbus dcc divx divx4linux dri dv dvd dvdr dvdread effects encode epson escreen esd extras fam firefox flac flash freetype gadu gd gd-external gdbm gif gimp gimpprint glitz gpm gstreamer hal hbci highlight history iconv ieee1394 ifp imap inkjar ipv6 irc isdnlog jabber jingle jpeg kde kdeenablefinal kdepim kipi lame latex libg++ live lm_sensors mad midi mikmod mmap mmx mp3 mpc mpeg mpeg2 mpeg4 mplayer musicbrainz mysql nagios-dns nagios-game nagios-ntp nagios-ping nagios-ssh ncurses nls nowlistening nptl nptlonly nsplugin nvidia ofx ogg opengl oscar pam pcre pdf perl php plugin pmu png posix ppds pppd print pthreads python qt3 qt4 quicktime rar readline real reflection remote samba sametime scanner sdl session slp sms snmp sox spell spl sql sse sse2 ssl statistics subversion svg sysfs t1lib tcpd texteffect theora threads translator truetype truetype-fonts type1 type1-fonts unicode usb utf8 v4l v4l2 vcd vidix visualization vorbis webpresence wifi win32codecs winpopup wma wmv wxgtk1 x86 xml xorg xprint xv xvid xvmc zlib" ALSA_CARDS="intel8x0 usb-audio" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route share shm softvol" ELIBC="glibc" INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en uk en_US en_GB ar he et" USERLAND="GNU" VIDEO_CARDS="nvidia"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LDFLAGS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

xushi@xushitop ~ $