I'm using Amarok 1.1 on a Debian Unstable using the kalyxo build.
I have configured it to scan two directories recursively. One of them it's on hard disk, the other it's on a cdrom. When I start Amarok I've got nothing on the collection, even if I select start scan, everything it's scanned, but then nothing shows in the collection. This is the complete output of a session:
1. Open Amarok
2. Select Start Scan

jose@debian:~$ amarok
[amaroK loader] connecting to /home/jose/.kde/socket-debian/amarok.loader_socket
[amaroK loader] amaroK not running. Trying to start it..
amarok: BEGIN [static EngineBase* EngineController::loadEngine()]
amarok: [PluginManager] Plugin trader constraint: [X-KDE-amaroK-framework-version] == 3 and [X-KDE-amaroK-plugintype] == 'engine' and [X-KDE-amaroK-name] == 'void-engine' and [X-KDE-amaroK-rank] > 0
amarok: [PluginManager] Trying to load: libamarok_void-engine_plugin
amarok: [amaroK::Plugin::Plugin(bool)]
amarok:
amarok: PluginManager Service Info:
amarok: ---------------------------
amarok: name :
amarok: library : libamarok_void-engine_plugin
amarok: desktopEntryPath : amarok_void-engine_plugin.desktop
amarok: X-KDE-amaroK-plugintype : engine
amarok: X-KDE-amaroK-name : void-engine
amarok: X-KDE-amaroK-authors : (Max Howell,Mark Kretschmann)
amarok: X-KDE-amaroK-rank : 1
amarok: X-KDE-amaroK-version : 1
amarok: X-KDE-amaroK-framework-version: 3
amarok:
amarok: END [static EngineBase* EngineController::loadEngine()]
amarok: [browserBar] Initialisation statistics:
amarok: Init: ContextBrowser
amarok: [ContextBrowser::ContextBrowser(const char*)]
amarok: Time: 0.12s
amarok: Init: CollectionBrowser
amarok: [CollectionView::CollectionView(CollectionBrowser*)]
amarok: [void CollectionView::renderView()]
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: near ".": syntax error
amarok: ERROR: on query: SELECT DISTINCT .name, '0' FROM tags, WHERE .id=tags. ORDER BY lower(.name) DESC;
amarok: Time: 0.04s
amarok: Init: PlaylistBrowser
amarok: Time: 0.06s
amarok: Init: SearchBrowser
amarok: Time: 0s
amarok: Init: FileBrowser
amarok: Time: 0.04s
amarok: Session Playlist: /home/jose/.kde/share/apps/amarok/current.xml
amarok: BEGIN [void App::applySettings(bool)]
amarok: Discovered 170 widgets in PlaylistWindow
amarok: BEGIN [PlayerWidget::PlayerWidget(QWidget*, const char*, bool)]
amarok: END [PlayerWidget::PlayerWidget(QWidget*, const char*, bool)]
amarok: Baranalyzer Resized(168x56)
amarok: BAND_COUNT = 33 MAX_UP = 2MAX_DOWN = -1
amarok: BAND_COUNT = 33 MAX_UP = 2MAX_DOWN = -1
amarok: Qt::showEvent
amarok: BEGIN [static EngineBase* EngineController::loadEngine()]
amarok: [PluginManager] Plugin trader constraint: [X-KDE-amaroK-framework-version] == 3 and [X-KDE-amaroK-plugintype] == 'engine' and [X-KDE-amaroK-name] == 'arts-engine' and [X-KDE-amaroK-rank] > 0
amarok: [PluginManager] Trying to load: libamarok_artsengine_plugin
amarok: [amaroK::Plugin::Plugin(bool)]
amarok: [ArtsEngine::ArtsEngine()]
amarok:
amarok: PluginManager Service Info:
amarok: ---------------------------
amarok: name : Motor aRts
amarok: library : libamarok_artsengine_plugin
amarok: desktopEntryPath : amarok_artsengine_plugin.desktop
amarok: X-KDE-amaroK-plugintype : engine
amarok: X-KDE-amaroK-name : arts-engine
amarok: X-KDE-amaroK-authors : (Mark Kretschmann)
amarok: X-KDE-amaroK-rank : 200
amarok: X-KDE-amaroK-version : 1
amarok: X-KDE-amaroK-framework-version: 3
amarok:
amarok: BEGIN [virtual bool ArtsEngine::init()]
amarok: END [virtual bool ArtsEngine::init()]
amarok: [static void PluginManager::unload(amaroK::Plugin*)]
amarok: [virtual amaroK::Plugin::~Plugin()]
amarok: [PluginManager] Unloading library: libamarok_void-engine_plugin
amarok: END [static EngineBase* EngineController::loadEngine()]
amarok: END [void App::applySettings(bool)]
amarok: [App] Pruned 0 of 15 amazon cover images.
[amaroK loader] startup successful.
[amaroK loader] exiting.
jose@debian:~$ amarok: [virtual void LoaderServer::newConnection(int)]
amarok: Received: STARTUP (8 bytes)
amarok: [void CollectionView::scan()]
amarok: [void CollectionDB::scan(const QStringList&, bool, bool)]
popoup cleared!
amarok: [weaver] Started..
amarok: BEGIN [void CollectionReader::readTags(const QStringList&)]
amarok: [void CollectionDB::createTables(bool)]
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
TagLib: ID3v2.4 no longer supports the frame type TSIZ. It will be discarded from the tag.
amarok: [void CollectionDB::dropTables(bool)]
amarok: [void CollectionDB::createTables(bool)]
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: table directories already exists
amarok: ERROR: on query: CREATE TABLE directories (dir VARCHAR(100) UNIQUE,changedate INTEGER );
amarok: [void CollectionDB::dropTables(bool)]
amarok: END [void CollectionReader::readTags(const QStringList&)]
amarok: [virtual void CollectionDB::customEvent(QCustomEvent*)]
amarok: [void CollectionView::renderView()]
amarok: ERROR: [bool CollectionDB::execSql(const QString&, QStringList*, QStringList*, bool)] [CollectionDB] sqlite3_compile error:
amarok: ERROR: near ".": syntax error
amarok: ERROR: on query: SELECT DISTINCT .name, '0' FROM tags, WHERE .id=tags. ORDER BY lower(.name) DESC;
amarok: [weaver] Done!

What's the problem?

I had the same problem, but it was simply because there was no ftag filter selected, maybe it will solve your problem...
So just select for example Taf filter -> primary -> Artists
It should be listed as a bug to be fixed for the upcoming amarok 1.1.1