DB problems again

[Andreas Heinz]

upgrading mysql would end in an handmade mysql which i would like to avoid.

the header files against which amarok has been build are mysql4. so 
there is a difference too.

changing the structure in the database doesnt look that horrible, so i 
would like to try that out. hopefully this helps.

Rich wrote:
> Andreas Heinz wrote:
>> mysql is 5.0.22 ubuntu version
> 
> or was that 5.0.22... can you try upgrading mysql ?
> 
>> amarok is 1.4.4
>>
>> and no, mysql wasn't upgraded. i had made an mysql 4 dump and then put 
>> it clean into mysql 5
> 
> yeah, seems to be the same issue, even though it was supposed to be 
> worked around in 1.4.4.
> 
> if upgrading mysql is not possible, you can try changing varchars to 
> varbinarys. i have lost full list of places where this change has been 
> necessary, but you can try to start with statistics table.
> 
> replace url varchar in there (in a backup copy of your db dump :) ) with 
> : `url` varbinary(255) NOT NULL default '',
> 
> there might be other places wher such a change is necessary, look for 
> varchars with keyword binary or so and change them to vabinarys.
> 
> if this does not help at all, that probably is a different problem 
> (especially as this one is supposed to be fixed in 1.4.4 _and_ appeared 
> only in mysql 5.0.24 - or unreleased 5.0.23).
> 
> btw, are your mysql versions for client libs & server identical ?
> that also can cause weird problems sometimes.
> 
>> so mysql 4 should be an alternative? or is this completly out of the 
>> possibilities?
>>
>> Rich wrote:
>>> migrated to mysql5 from mysql4 and using mysql version 5.0.24 ?
>>> though this should not be a problem with latest amarok, i think...
>>> there is a workaround for the problem i am thinking of that involves 
>>> modifying the db, but if your mysql version is 5.0.24 and your amarok is 
>>> not the latest version (1.4.4), try upgrading both of them.
> ...