once again apt-get problem

[CrashedAgain]

In my experience apt-get is seldom able to solve it's own problems. .

Really? I have no problems with apt.

Here's a typical one:

apt-get -t unstable install kdemultimedia-kio-plugins
Reading Package Lists... Done
Building Dependency Tree... Done
The following extra packages will be installed:
  jackd kdelibs-bin kdelibs-data kdelibs4 libarts1 libarts1-dev libartsc0 libartsc0-dev libidn11 libjack0.80.0-0
  libjack0.80.0-dev libkcddb1 libopenexr2 libperl5.8 libqt3-compat-headers libqt3-headers libqt3-mt-dev libqt3c102-mt perl
  perl-base perl-modules perl-suid qt3-dev-tools
Suggested packages:
  qjackctl jack-tools meterbridge libjackasyn0 libqt3-i18n qt3-doc libqt3-mt-mysql libqt3-mt-psql libqt3-mt-odbc
  libqt3c102-mt-psql libqt3c102-mt-mysql libqt3c102-mt-odbc perl-doc libterm-readline-perl-perl
The following NEW packages will be installed:
  jackd kdemultimedia-kio-plugins libjack0.80.0-0 libjack0.80.0-dev libopenexr2 libperl5.8 perl-suid
The following held packages will be changed:
  libqt3-mt-dev
The following packages will be upgraded:
  kdelibs-bin kdelibs-data kdelibs4 libarts1 libarts1-dev libartsc0 libartsc0-dev libidn11 libkcddb1 libqt3-compat-headers
  libqt3-headers libqt3-mt-dev libqt3c102-mt perl perl-base perl-modules qt3-dev-tools
17 upgraded, 7 newly installed, 0 to remove and 672 not upgraded.
Need to get 29.5MB/29.6MB of archives.
After unpacking 9310kB of additional disk space will be used.
Do you want to continue? [Y/n]
Get:1 http://ftp.de.debian.org unstable/main perl-modules 5.8.4-2.2 [2182kB]
<edited for brevity>
Preparing to replace perl-modules 5.8.4-2 (using .../perl-modules_5.8.4-2.2_all.deb) ...
Unpacking replacement perl-modules ...
<edited for brevity>
Replacing files in old package kcontrol ...
dpkg: error processing /var/cache/apt/archives/kdelibs-data_4%3a3.3.0-1.1_all.deb (--unpack):
 trying to overwrite `/usr/share/mimelnk/application/vnd.stardivision.calc.desktop', which is also in package openoffice-de-en
dpkg-deb: subprocess paste killed by signal (Broken pipe)
Preparing to replace kdelibs4 4:3.2.3-4 (using .../kdelibs4_4%3a3.3.0-1.1_i386.deb) ...
Unpacking replacement kdelibs4 ...
<edited again>
Unpacking kdemultimedia-kio-plugins (from .../kdemultimedia-kio-plugins_4%3a3.3.0-1_i386.deb) ...
Errors were encountered while processing:
 /var/cache/apt/archives/kdelibs-data_4%3a3.3.0-1.1_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

So now I have:

root@0[knoppix]# apt-get check
Reading Package Lists... Done
Building Dependency Tree... Done
You might want to run `apt-get -f install' to correct these.
The following packages have unmet dependencies:
  kdelibs4: Depends: kdelibs-data (>= 4:3.3.0) but 4:3.2.3-4 is installed
E: Unmet dependencies. Try using -f.

which apt-get is unable to solve:

root@0[knoppix]# apt-get -t unstable -f install kdelibs4
Reading Package Lists... Done
Building Dependency Tree... Done
kdelibs4 is already the newest version.
You might want to run `apt-get -f install' to correct these:
The following packages have unmet dependencies:
  kdelibs4: Depends: kdelibs-data (>= 4:3.3.0) but 4:3.2.3-4 is to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

root@0[knoppix]# apt-get -f install
Reading Package Lists... Done
Building Dependency Tree... Done
Correcting dependencies... Done
The following extra packages will be installed:
  kdelibs-data
The following packages will be upgraded:
  kdelibs-data
1 upgraded, 0 newly installed, 0 to remove and 566 not upgraded.
22 not fully installed or removed.
Need to get 0B/7045kB of archives.
After unpacking 2212kB of additional disk space will be used.
Do you want to continue? [Y/n] y
(Reading database ... 81251 files and directories currently installed.)
Preparing to replace kdelibs-data 4:3.2.3-4 (using .../kdelibs-data_4%3a3.3.0-1.1_all.deb) ...
Unpacking replacement kdelibs-data ...
Replacing files in old package kcontrol ...
dpkg: error processing /var/cache/apt/archives/kdelibs-data_4%3a3.3.0-1.1_all.deb (--unpack):
 trying to overwrite `/usr/share/mimelnk/application/vnd.stardivision.calc.desktop', which is also in package openoffice-de-en
dpkg-deb: subprocess paste killed by signal (Broken pipe)
Errors were encountered while processing:
 /var/cache/apt/archives/kdelibs-data_4%3a3.3.0-1.1_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

Solved with dpkg --force-overwrite:

root@0[knoppix]# dpkg --force-overwrite -i /var/cache/apt/archives/kdelibs-data_4%3a3.3.0-1.1_all.deb
(Reading database ... 81251 files and directories currently installed.)
Preparing to replace kdelibs-data 4:3.2.3-4 (using .../kdelibs-data_4%3a3.3.0-1.1_all.deb) ...
Unpacking replacement kdelibs-data ...
Replacing files in old package kcontrol ...
dpkg - warning, overriding problem because --force enabled:
 trying to overwrite `/usr/share/mimelnk/application/vnd.stardivision.calc.desktop', which is also in package openoffice-de-en
dpkg - warning, overriding problem because --force enabled:
 trying to overwrite `/usr/share/mimelnk/application/vnd.stardivision.chart.desktop', which is also in package openoffice-de-en
dpkg - warning, overriding problem because --force enabled:
 trying to overwrite `/usr/share/mimelnk/application/vnd.stardivision.draw.desktop', which is also in package openoffice-de-en
dpkg - warning, overriding problem because --force enabled:
 trying to overwrite `/usr/share/mimelnk/application/vnd.stardivision.impress.desktop', which is also in package openoffice-de-en
dpkg - warning, overriding problem because --force enabled:
 trying to overwrite `/usr/share/mimelnk/application/vnd.stardivision.math.desktop', which is also in package openoffice-de-en
dpkg - warning, overriding problem because --force enabled:
 trying to overwrite `/usr/share/mimelnk/application/vnd.stardivision.writer-global.desktop', which is also in package openoffice-de-en
dpkg - warning, overriding problem because --force enabled:
 trying to overwrite `/usr/share/mimelnk/application/vnd.stardivision.writer.desktop', which is also in package openoffice-de-en
dpkg - warning, overriding problem because --force enabled:
 trying to overwrite `/usr/share/mimelnk/application/vnd.sun.xml.calc.template.desktop', which is also in package openoffice-de-en
dpkg - warning, overriding problem because --force enabled:
 trying to overwrite `/usr/share/mimelnk/application/vnd.sun.xml.draw.template.desktop', which is also in package openoffice-de-en
dpkg - warning, overriding problem because --force enabled:
 trying to overwrite `/usr/share/mimelnk/application/vnd.sun.xml.impress.template.desktop', which is also in package openoffice-de-en
dpkg - warning, overriding problem because --force enabled:
 trying to overwrite `/usr/share/mimelnk/application/vnd.sun.xml.writer.template.desktop', which is also in package openoffice-de-en
Setting up kdelibs-data (3.3.0-1.1) ...
Installing new version of config file /etc/kde3/katesyntaxhighlightingrc ...
Installing new version of config file /etc/kde3/kdebug.areas ...
Installing new version of config file /etc/kde3/ksslcalist ...
root@0[knoppix]# apt-get check
Reading Package Lists... Done
Building Dependency Tree... Done

It could also be solved by removing/reinstalling openoffice.

Even so, apt-get &/or dpkg is easily the best package management system available & is one of the big reasons I have returned to Knoppix after trying Mandrake.
I had Mandy 9.2, OK system, everything worked right off but then KDE 3.2 came out. It took me about a month to get it installed, I tried compiling from sources with out success & was only able to upgrade it after somebody posted mdk rpms for kde 3.2 which I could use; even then I had to completely remove 3.1 & install 3.2 on a clean system. With apt-get you can do it bit by bit.
Then it's just about impossible to keep Mandy up to date, with Mdk 10 out nobody is going to make rpms for 9.2 so you are on your own. No such problems with Debian, a .deb is a .deb regardless of system version.