On Mon, Jul 13, 2009 at 12:01 PM, Peter Rabbitson<[email protected]> wrote: > On Mon, Jul 13, 2009 at 11:11:20AM -0500, Paul Makepeace wrote: >> On Mon, Jul 13, 2009 at 11:03 AM, Rob Kinyon<[email protected]> wrote: >> > On Mon, Jul 13, 2009 at 11:52, Paul Makepeace<[email protected]> wrote: >> > [snip] >> >> specifically, FROM (SELECT COUNT( publication_story.uid ) AS >> >> story_count, ... looks wrong. Or should I update my code somehow? >> >> >> >> This error coincides with upgrading to latest DBIx::Class today. >> > >> > What do you expect to see? >> >> My question is what do _you_ expect to see? > > I expect to see exactly what you have pasted. Also being an ass will > not take you very far with support.
Sorry I wasn't intending to come across as an ass - I had said in my original email "specifically >here< is what looks wrong" so wasn't sure what Rob was getting at. Knowing what he'd expect would help me infer his intent. >> I would fairly reasonably expect to produce SELECT >> COUNT(publication_story.uid) AS story_count and not have that appear >> in the FROM clause (?!) > > Read the SQL more carefully then. I don't understand what you're getting at here. That clause is appearing in a FROM clause whereas it should appear in the earlier SELECT column list. Is that not how you're reading it? >> This has been working until today when I upgraded, so a recent version >> of $module has broken this. > > I need you to *manually* execute the following snippet against your > database: > > SELECT COUNT( publication_story.uid ) AS > story_count, me.uid, me.name, me.short_name, me.url, me.description, > me.publication_type_uid, me.region_uid, me.channel_type_uid, > me.circulation, me.ave1, me.ave2, me.comments FROM publication me > WHERE ( ( name LIKE ? OR short_name LIKE ? ) ) GROUP BY me.uid ORDER > BY name (I filled in the ?s) mysql> SELECT COUNT( publication_story.uid ) AS story_count, me.uid, me.name, me.short_name, me.url, me.description, me.publication_type_uid, me.region_uid, me.channel_type_uid, me.circulation, me.ave1, me.ave2, me.comments FROM publication me WHERE ( ( name LIKE '%red orbit%' OR short_name LIKE '%red orbit%' ) ) GROUP BY me.uid ORDER BY name; ERROR 1054 (42S22): Unknown column 'publication_story.uid' in 'field list' > Let me know if the error persists or you get a somewhat reasonable > result back. It seems reasonable to error out there given that publication_story doesn't appear in the FROM clause. Paul > > _______________________________________________ > List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ > Searchable Archive: http://www.grokbase.com/group/[email protected] > _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
