I've just upgraded to version 2 using the Debian testing package but now whenever I try to play music I get

amarok: [ERROR!] GREPME MySQLe query failed! Table 'amarok.bookmarks' doesn't exist on "SELECT id, parent_id, name, url, description, custom FROM bookmarks WHERE url LIKE '%ZmlsZTovLy92YXIvbXVzaWMvYWlyL21vb25fc2FmYXJpLzA3JTIwLSUyMFlvdSUyMG1ha2UlMjBpdCUyMGVhc3kubXA%'"

and nothing will play.

I did an import collection from my v1 database but the problem happened before and after that.

Upgraded from which version to which version exactly?
What kind of database is your 1.4 version?
Move .kde/share/apps/amarok to .kde/share/apps/amarok.old and remove .kde/share/config/amarok*
Do a fresh scan and import your old db afterwards.

m0nk

I don't know the old version, I didn't check before the upgrade but it is whatever version comes with Debian Lenny

The new version is

Version 2.1.1
Using KDE 4.2.4 (KDE 4.2.4)
(Build Date: Aug 4 2009)

From Debian testing

I followed the instructions for clearing down the old config files but I'm still getting the same error. I'm assuming that Amarok 2 has dropped mysql in favour of file based storage as I can't find a way to configure which database it is connecting to. The only db reference I can find is for importing old configs.

This is the full debug output when trying to play a track just by using the play media option

Code: Select all

amarok: BEGIN: void Playlist::PrettyListView::trackActivated(const QModelIndex&)
amarok:   BEGIN: void Playlist::Actions::play(quint64, bool)
amarok:     BEGIN: void EngineController::play(const Meta::TrackPtr&, uint)
amarok:       BEGIN: void EngineController::playUrl(const KUrl&, uint)
amarok:         BEGIN: void EngineController::slotStopFadeout()
amarok:         END__: void EngineController::slotStopFadeout() - Took 9.5e-05s
amarok:         [EngineController] URL:  "file:///var/music/2007/amy_winehouse//back_to_black//01%20%20Amy%20Winehouse%20-%20Rehab.mp3"
amarok:         BEGIN: void EngineController::slotNewTrackPlaying(const Phonon::MediaSource&)
amarok:           [EngineController] Using gain of 0 with relative peak of 0
amarok:           BEGIN: void EngineSubject::stateChangedNotify(Phonon::State, Phonon::State)
amarok:           END__: void EngineSubject::stateChangedNotify(Phonon::State, Phonon::State) - Took 9.6e-05s
amarok:           BEGIN: void Playlist::PrettyListView::scrollToActiveTrack()
amarok:             [Playlist::PrettyListView] skipping scroll? true
amarok:           END__: void Playlist::PrettyListView::scrollToActiveTrack() - Took 0.00016s
amarok:           BEGIN: virtual void ProgressWidget::engineNewTrackPlaying()
amarok:             BEGIN: virtual void ProgressWidget::engineTrackLengthChanged(long int)
amarok:                new length:  215
amarok:                slider enabled!
amarok:                here 1
amarok:                here 2
amarok:               BEGIN: static BookmarkList PlayUrlRunner::bookmarksFromUrl(KUrl)
amarok:                  query:  "SELECT id, parent_id, name, url, description, custom FROM bookmarks WHERE url LIKE '%ZmlsZTovLy92YXIvbXVzaWMvMjAwNy9hbXlfd2luZWhvdXNlLy9iYWNrX3RvX2JsYWNrLy8wMSUyMCUyMEFteSUyMFdpbmVob3VzZSUyMC0lMjBSZWhhYi5tcDM%'"
amarok:                  [ERROR!] GREPME MySQLe query failed! Table 'amarok.bookmarks' doesn't exist  on  "SELECT id, parent_id, name, url, description, custom FROM bookmarks WHERE url LIKE '%ZmlsZTovLy92YXIvbXVzaWMvMjAwNy9hbXlfd2luZWhvdXNlLy9iYWNrX3RvX2JsYWNrLy8wMSUyMCUyMEFteSUyMFdpbmVob3VzZSUyMC0lMjBSZWhhYi5tcDM%'"
amarok:               END__: static BookmarkList PlayUrlRunner::bookmarksFromUrl(KUrl) - Took 0.00056s
amarok:             END__: virtual void ProgressWidget::engineTrackLengthChanged(long int) - Took 0.00096s
amarok:           END__: virtual void ProgressWidget::engineNewTrackPlaying() - Took 0.0012s
amarok:           BEGIN: virtual void TimecodeObserver::engineNewTrackPlaying()
amarok:           END__: virtual void TimecodeObserver::engineNewTrackPlaying() - Took 9.3e-05s
amarok:         END__: void EngineController::slotNewTrackPlaying(const Phonon::MediaSource&) - Took 0.0044s

(<unknown>:4018): GStreamer-CRITICAL **: gst_element_make_from_uri: assertion `gst_uri_is_valid (uri)' failed
amarok:       END__: void EngineController::playUrl(const KUrl&, uint) - Took 0.0058s
amarok:     END__: void EngineController::play(const Meta::TrackPtr&, uint) - Took 0.006s
amarok:   END__: void Playlist::Actions::play(quint64, bool) - Took 0.0062s
amarok: END__: void Playlist::PrettyListView::trackActivated(const QModelIndex&) - Took 0.0064s


From looking around it looks like there is also a problem with gstreamer

Code: Select all

(<unknown>:4018): GStreamer-CRITICAL **: gst_element_make_from_uri: assertion `gst_uri_is_valid (uri)' failed

I get this when trying to test the sound card. I have gstreamer-alsa and gstreamer-tools packages installed but don't know how to test them with other apps to see if they are working for other programs.

First of all: get rid of gstreamer and use xine.
Lenny ships with 1.4.10 and MySQL 5.0.x
So if you update to 2.1.1 your 1.4 database won't work anymore.
And your MySQL packages should be updated to 5.1.3x minimum.
Amarok prior to 2.2 supports only MySQL embedded as database.
Move the old ~/.kde/share/apps/amarok out of the way, but don't delete it.
Removing the configs is insufficient.

m0nk

I did move both the directories out of the way and it all started from fresh. I also tried creating a completely new user and using it to start Amarok but that failed in the same way.

I've got mysql install and running happily but I can't find where in Amarok to configure the database options.

I just tried installing the amarok-engine-xine package, that removed Amarok itself! After re-installing the Amarok package I don't get xine as an option even though I've got xine installed and gxine plays media fine.

Do you use Gnome or KDE4?
You can't select database options, 'cause there are none.
You really need a version of MySQL higher or equal to 5.1.34.
And Lenny ships with MySQL 5.0.
After starting Amarok, do you have a directory .kde/share/apps/amarok/mysqle/amarok now?
Are there any files in it?

Btw. Gstreamer/Xine has nothing to do with the database, but the phonon-gstreamer backend is buggy.

m0nk

I'm a developer so I've got a dev server running mysql 5.1.37 which is where I'd like Amarok to put the database. I use various other machines and with 1.4 had them all point at this one database, can't I do the same with version 2?

I have the directory .kde/share/apps/amarok/mysqle/amarok and it contains plenty of files, notably none are called bookmarks.

I know Gstreamer/Xine is nothing to do with my db problem just thought I'd mention it as it looks like I might not be able to get any sound out even if I get it to start playing audio. I'll leave that till later, one step at a time.

OK, last try:
Amarok prior to 2.2-beta1 doesn't support external MySQL databases!
Either you use 2.2-beta1 or you use the local database.
If you decide to use the local version, be sure you have 5.1.37 installed on that machine.
Don't try to use or copy the database from your server!

m0nk

Looks like I'll be waiting for it to come out of beta then as the whole selling point of Amarok was the ability to share the database over multiple machines.

Worked so nicely on version 1.x as well.