UPDATE: I solved it installing this packages:
libdbd-mysql-perl libdbi-perl libhtml-template-perl libnet-daemon-perl libplrpc-perl mysql-client mysql-server mysql-server-5.1
But I don't know what happens. That I remember, I not remove any of the previous packages...
(thank's to https://bugs.launchpad.net/ubuntu/+sour ... bug/523269)


Hi!

I'm using Amarok Version 2.3.0 KDE Version 4.4.2 with ubuntu 10.04

Amarok work's perfectly during months, until yesterday. When I started it I see no songs on my collection!

I restored the ~/.kde/share folder from a backup of a few weeks ago, but when I open Amarok, I still see my collection without songs!

Anyone know what may be happening?

Thank's!


Here you have a part of output, starting with --debug...


...
role 1 : ( QIcon ) : QVariant(QIcon, )
role 2 : ( QString ) : QVariant(QString, "")
role 3 : ( QString ) : QVariant(QString, "")
role 0 : ( QString ) : QVariant(QString, "")
role 1 : ( QIcon ) : QVariant(QIcon, )
role 2 : ( QString ) : QVariant(QString, "")
role 3 : ( QString ) : QVariant(QString, "")
HTTP GET QUrl( "http://post.audioscrobbler.com:80/?hs=true&p=1.2.1&c=ark&v=2.3.0&u=nandelbosc&t=1277546876&a=28d949986c17a72ac9201449d65bf2a5&api_key=402d3ca8e9bc9d3cf9b85e1202944ca5&sk=5eb8ca49ac8c36ba0071bac9d17fe572" )
role 0 : ( QVariantList ) : QVariant(QVariantList, (QVariant(QString, "Local Podcasts") ) )
role 1 : ( QVariantList ) : QVariant(QVariantList, (QVariant(QIcon, ) ) )
role 3 : ( QVariantList ) : QVariant(QVariantList, (QVariant(QString, "Local Podcasts") ) )
QMap((0, QMap((0, QVariant(QString, "Local Podcasts") ) ( 1 , QVariant(QIcon, ) ) ( 3 , QVariant(QString, "Local Podcasts") ) ) ) )
Creating empty group: "Local Podcasts"
amarok(2589)/kdecore (KPluginInfo) KPluginInfo::kcmServices: found 0 offers for "Amarok Script Console"
amarok(2589)/kdecore (KPluginInfo) KPluginInfo::kcmServices: found 0 offers for "Playlist2CD"
amarok(2589)/kdecore (KPluginInfo) KPluginInfo::kcmServices: found 0 offers for "NotifyAmarok"
amarok(2589)/kdecore (KPluginInfo) KPluginInfo::kcmServices: found 0 offers for "Statistics"
amarok(2589)/kdecore (KPluginInfo) KPluginInfo::kcmServices: found 0 offers for "LyricWiki"
amarok(2589)/kdecore (KPluginInfo) KPluginInfo::kcmServices: found 0 offers for "CATRadio"
amarok(2589)/kdecore (KPluginInfo) KPluginInfo::kcmServices: found 0 offers for "Cool Streams"
amarok(2589)/kdecore (KPluginInfo) KPluginInfo::kcmServices: found 0 offers for "Librivox.org"
========== Starting Statistics Script ==========

[RATING_STATISTICS] [SQL] SHOW TABLES


[RATING_STATISTICS] [SQL] CREATE TABLE rating_statistics_config (name VARCHAR(255), value VARCHAR(255))


[RATING_STATISTICS] Sucessfully created new configuration table


[RATING_STATISTICS] [SQL] SELECT value FROM rating_statistics_config WHERE name="ignore_unrated"


[RATING_STATISTICS] [SQL] INSERT INTO rating_statistics_config (name,value) VALUES ("ignore_unrated", "2")


[RATING_STATISTICS] Not Found: 2


[RATING_STATISTICS] [SQL] SELECT value FROM rating_statistics_config WHERE name="reverse_results"


[RATING_STATISTICS] [SQL] INSERT INTO rating_statistics_config (name,value) VALUES ("reverse_results", "0")


[RATING_STATISTICS] Not Found: 0


[RATING_STATISTICS] [SQL] SELECT value FROM rating_statistics_config WHERE name="exclude_enabled"


[RATING_STATISTICS] [SQL] INSERT INTO rating_statistics_config (name,value) VALUES ("exclude_enabled", "0")


[RATING_STATISTICS] Not Found: 0


[RATING_STATISTICS] [SQL] SELECT value FROM rating_statistics_config WHERE name="min_tracks_per_album"


[RATING_STATISTICS] [SQL] INSERT INTO rating_statistics_config (name,value) VALUES ("min_tracks_per_album", "4")


[RATING_STATISTICS] Not Found: 4


[RATING_STATISTICS] [SQL] SELECT value FROM rating_statistics_config WHERE name="results_limit"


[RATING_STATISTICS] [SQL] INSERT INTO rating_statistics_config (name,value) VALUES ("results_limit", "15")


[RATING_STATISTICS] Not Found: 15


[RATING_STATISTICS] [SQL] SELECT value FROM rating_statistics_config WHERE name="weight_rating"


[RATING_STATISTICS] [SQL] INSERT INTO rating_statistics_config (name,value) VALUES ("weight_rating", "2")


[RATING_STATISTICS] Not Found: 2


[RATING_STATISTICS] [SQL] SELECT value FROM rating_statistics_config WHERE name="weight_score"


[RATING_STATISTICS] [SQL] INSERT INTO rating_statistics_config (name,value) VALUES ("weight_score", "2")


[RATING_STATISTICS] Not Found: 2


[RATING_STATISTICS] [SQL] SELECT value FROM rating_statistics_config WHERE name="weight_length"


[RATING_STATISTICS] [SQL] INSERT INTO rating_statistics_config (name,value) VALUES ("weight_length", "1")


[RATING_STATISTICS] Not Found: 1


[RATING_STATISTICS] [SQL] SELECT value FROM rating_statistics_config WHERE name="weight_playcount"


[RATING_STATISTICS] [SQL] INSERT INTO rating_statistics_config (name,value) VALUES ("weight_playcount", "2")


[RATING_STATISTICS] Not Found: 2

========== Finished Statistics Script ==========
amarok: ************************************************************************************************************
amarok: ** DEBUGGING OUTPUT IS NOW ENABLED. PLEASE NOTE THAT YOU WILL ONLY SEE THE FULL OUTPUT ON THE NEXT START. **
amarok: ************************************************************************************************************
amarok: END__: static void App::handleCliArgs() - Took 0.00016s
amarok: END__: virtual int App::newInstance() - Took 0.00022s
marc@michael:~$ amarok: BEGIN: void CurrentEngine::resultReady(const QString&, const Meta::AlbumList&)
amarok: END__: void CurrentEngine::resultReady(const QString&, const Meta::AlbumList&) - Took 9.5e-05s
amarok: BEGIN: void CurrentEngine::resultReady(const QString&, const Meta::TrackList&)
amarok: END__: void CurrentEngine::resultReady(const QString&, const Meta::TrackList&) - Took 2.8e-05s
amarok: BEGIN: void CurrentEngine::setupTracksData()
amarok: END__: void CurrentEngine::setupTracksData() - Took 3.2e-05s
amarok: BEGIN: void Albums::dataUpdated(const QString&, const QHash<QString, QVariant>&)
amarok: END__: void Albums::dataUpdated(const QString&, const QHash<QString, QVariant>&) - Took 0.00019s
amarok: BEGIN: void CurrentTrack::dataUpdated(const QString&, const QHash<QString, QVariant>&)
amarok: END__: void CurrentTrack::dataUpdated(const QString&, const QHash<QString, QVariant>&) - Took 0.00011s
amarok: BEGIN: void Playlist::PrettyListView::fixInvisible()
amarok: END__: void Playlist::PrettyListView::fixInvisible() - Took 0.00013s
"OK
83d642c7e21a40f68d466adfa352ae40
http://post.audioscrobbler.com:80/np_1.2
http://post2.audioscrobbler.com:80/protocol_1.2"
amarok: BEGIN: void LastFmService::onGetUserInfo()
amarok: profile info "" "" "n" "13390" false
amarok: profile avatar: "http://userserve-ak.last.fm/serve/34/1079549.jpg"
amarok: END__: void LastFmService::onGetUserInfo() - Took 0.00086s
amarok: BEGIN: void LastFmServiceCollection::slotAddFriendsLoved()
amarok: END__: void LastFmServiceCollection::slotAddFriendsLoved() - Took 0.00041s
amarok: BEGIN: void LastFmServiceCollection::slotAddNeighboursLoved()
amarok: END__: void LastFmServiceCollection::slotAddNeighboursLoved() - Took 0.011s
amarok(2589)/kio (KIOJob) KIO::TransferJob::slotMimetype: mimetype() emitted again, or after sending first data!; job URL = KUrl("http://userserve-ak.last.fm/serve/34/1079549.jpg")
amarok: BEGIN: void LastFmService::onAvatarDownloaded(QPixmap)
QUrl( "http://ws.audioscrobbler.com/2.0/?api_key=402d3ca8e9bc9d3cf9b85e1202944ca5&lang=ca&method=user.getNeighbours&user=nandelbosc" )
QUrl( "http://ws.audioscrobbler.com/2.0/?api_key=402d3ca8e9bc9d3cf9b85e1202944ca5&lang=ca&method=user.getFriends&user=nandelbosc" )
QUrl( "http://ws.audioscrobbler.com/2.0/?api_key=402d3ca8e9bc9d3cf9b85e1202944ca5&lang=ca&method=user.getTopTags&user=nandelbosc" )
QUrl( "http://ws.audioscrobbler.com/2.0/?api_key=402d3ca8e9bc9d3cf9b85e1202944ca5&lang=ca&method=user.getTopArtists&user=nandelbosc" )
amarok: 0
amarok: END__: void LastFmService::onAvatarDownloaded(QPixmap) - Took 0.0046s
amarok: BEGIN: void LastFmTreeModel::slotAddTags()
amarok: END__: void LastFmTreeModel::slotAddTags() - Took 0.00041s
amarok: BEGIN: void LastFmTreeModel::slotAddFriends()
amarok: END__: void LastFmTreeModel::slotAddFriends() - Took 0.00061s
amarok: BEGIN: void LastFmTreeModel::slotAddTopArtists()
amarok: END__: void LastFmTreeModel::slotAddTopArtists() - Took 0.0059s
amarok(2589)/kio (KIOJob) KIO::TransferJob::slotMimetype: mimetype() emitted again, or after sending first data!; job URL = KUrl("http://userserve-ak.last.fm/serve/126/620003.png")
amarok: BEGIN: void LastFmTreeModel::slotAddNeighbors()
amarok: END__: void LastFmTreeModel::slotAddNeighbors() - Took 0.0038s
amarok(2589)/kio (KIOJob) KIO::TransferJob::slotMimetype: mimetype() emitted again, or after sending first data!; job URL = KUrl("http://userserve-ak.last.fm/serve/126/5286865.jpg")
amarok(2589)/kio (KIOJob) KIO::TransferJob::slotMimetype: mimetype() emitted again, or after sending first data!; job URL = KUrl("http://userserve-ak.last.fm/serve/126/40189421.jpg")
amarok(2589)/kio (KIOJob) KIO::TransferJob::slotMimetype: mimetype() emitted again, or after sending first data!; job URL = KUrl("http://userserve-ak.last.fm/serve/126/39263251.jpg")
amarok(2589)/kio (KIOJob) KIO::TransferJob::slotMimetype: mimetype() emitted again, or after sending first data!; job URL = KUrl("http://userserve-ak.last.fm/serve/126/42555301.png")
amarok(2589)/kio (KIOJob) KIO::TransferJob::slotMimetype: mimetype() emitted again, or after sending first data!; job URL = KUrl("http://userserve-ak.last.fm/serve/126/6388885.jpg")
amarok: BEGIN: virtual App::~App()
amarok: BEGIN: virtual void SqlCollection::stopScan()
amarok: Scan error: "Abort requested from SqlCollection::stopScan()"
Object::disconnect: Unexpected null parameter
Object::disconnect: Unexpected null parameter
Object::disconnect: Unexpected null parameter
QCoreApplication::postEvent: Unexpected null receiver
amarok: BEGIN: void ScanManager::stopParser()
amarok: END__: void ScanManager::stopParser() - Took 4.6e-05s
amarok: END__: virtual void SqlCollection::stopScan() - Took 0.00022s
amarok(2589)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig:
amarok: BEGIN: virtual ScriptManager::~ScriptManager()
amarok: BEGIN: void ScriptManager::slotStopScript(QString)
amarok: BEGIN: void ScriptManager::scriptFinished(QString)
amarok: BEGIN: virtual ScriptableServiceScript::~ScriptableServiceScript()
amarok: END__: virtual ScriptableServiceScript::~ScriptableServiceScript() - Took 5e-05s
amarok: END__: void ScriptManager::scriptFinished(QString) - Took 0.0065s
amarok: END__: void ScriptManager::slotStopScript(QString) - Took 0.0066s
...

I tried installing all of those packages, and I still have the "no songs in collection" problem.

sorry fermulator, but I can't help you.... have a look here: https://bugs.launchpad.net/ubuntu/+sour ... bug/523269