amorak error

[sartic]

it gives me messagebox on startup:

The amarok database reported the following errors:
GREPME MySQLe query failed! (130) Incorrect file format 'lyrics' on DELETE FROM lyrics WHERE url NOT IN ( SELECT id FROM urls )
In most cases you will need to resolve these errors before Amarok will run properly.

i use amorak only to listen one radio station. it works even with this error.
how to fix this error?

[woodsmoke]

Hi
I was getting the database error on Quantal over the weekend, but it is now not occuring.

There have also been big updates each day so that may have taken care ofit.

woodsmoke

[sartic]

still geting this error
i removed all ppa(backports) and i will wait updates

edit:
no updates so i tried this

Re: MYSQLe error on startup
Thu Aug 25, 2011 12:39 am

Sentynel wrote:You can just remove the database. It's in ~/.kde/share/apps/amarok/mysqle (may be .kde4 on some distros). Note this will lose your statistics etc.
It is possible to connect to the embedded database like any MySQL database and attempt manual recovery if you prefer, but there may well be irrecoverable data loss anyway.

and it is solved