Devs, please read...Re: Collection scanner fails for some sampler CDs

[Jeff Mitchell]

I'm not sure what has changed, but I do know what's causing the problem.  It'd 
be instructive to read http://www.mysqlfreaks.com/errors/275.php

Right now I'm going through and updating some code...I'm getting it to the 
point where I can successfully create tables again, limiting the size of the 
index.  I don't know if this is necessary for only MySQL or not, or if it is 
even valid syntax on Postgres/SQLite...

I'm kind of flying by the seat of my pants, so any dev (or other person on 
this list) that knows about databases, please look at this problem.  I'll 
post the revision number when I commit.  I'm hoping I don't break 
Postgres/SQLite, but checks can be added in if necessary to only pass in a 
length argument (which is 255 max by default, it's a compile-time value 
apparently) if it's MySQL.

Also, for now at least I don't have the time to look at conversion code, I'm 
just looking at code starting from no tables.

--Jeff


On Sunday 06 August 2006 19:06, Jeff Mitchell wrote:
> I also just updated and am finding that the code that is supposed to create
> database tables if they don't exist is failing.  I'm checking it out.
>
> --Jeff
>
> On Sunday 06 August 2006 16:36, Martin Burnicki wrote:
> > Hi all,
> >
> > I've not yet received any reply to my original email, but here's some
> > additional info. From the amarok console output:
> >
> > amarok:     [CollectionDB] MYSQL QUERY FAILED: You have an error in your
> > SQL syntax; check the manual that corresponds to your MySQL server
> > version for the right syntax to use near '%4, 1125850911 )' at line 1
> > amarok: FAILED QUERY: REPLACE INTO directories_temp ( dir, deviceid,
> >   changedate ) VALUES ( './pub/music/martin/cd/UFO/Time To Rock
> > (CD12f2)', %4, 1125850911 );
> >
> > I'm not quite familiar with mysql, but from what I see I'd think the '%4'
> > statement in the SQL query should have been replaced with some real
> > value.
> >
> > Also, at startup I see the following mys1ql errors:
> >
> > amarok:       [CollectionDB] MYSQL QUERY FAILED: Table
> > 'amarok.statistics' doesn't exist
> > amarok: FAILED QUERY: SELECT COUNT( url ) FROM statistics LIMIT 1 OFFSET
> > 0; amarok:       [CollectionDB] MYSQL QUERY FAILED: Table
> >   'amarok.podcastchannels' doesn't exist
> > amarok: FAILED QUERY: SELECT COUNT( url ) FROM podcastchannels LIMIT 1
> > OFFSET 0;
> > amarok:       [CollectionDB] MYSQL QUERY FAILED: Table
> >   'amarok.podcastepisodes' doesn't exist
> > amarok: FAILED QUERY: SELECT COUNT( url ) FROM podcastepisodes LIMIT 1
> > OFFSET 0;
> >
> > I.e., the tables 'statistics', 'podcastchannels', and 'podcastepisodes'
> > don't seem to be created when the amarok DB is created.
> >
> > Regards,
> >
> > Martin
>
> _______________________________________________
> Amarok mailing list
> Amarok at kde.org
> https://mail.kde.org/mailman/listinfo/amarok