[html-formfu] "Column 'id' in field list is ambiguous"

[Jens Schwarz]

Hi and happy new year,

I am stuck with my issue using "default_column" in my yml (see below for the error message). The thread "many_to_many save_to_model & defaults_from_model" from January 2008 does not seem to help me. Right now it seems that I have two options: Either don't use "default_column" and get the "ambiguous" error message when calling the edit action, or use "default_column" and get the "Unknown column" error message when trying to submit the edited form. Both cases do not help on.

Any hints?
Thanks in advance!

-------- Original-Nachricht --------
> Datum: Mon, 08 Dec 2008 14:03:35 +0100
> Von: "Jens Schwarz" <blacky6767 at gmx.de>
> An: html-formfu at lists.scsys.co.uk
> Betreff: Re: [html-formfu] "Column \'id\' in field list is ambiguous"

> Hi Carl,
> 
> -------- Original-Nachricht --------
> > Datum: Thu, 4 Dec 2008 08:38:34 +0000
> > Von: "Carl Franks" <fireartist at gmail.com>
> > An: "HTML Form Creation, 	Rendering and Validation Framework"
> <html-formfu at lists.scsys.co.uk>
> > Betreff: Re: [html-formfu] "Column \'id\' in field list is ambiguous"

> > It looks like it may be the same issue.
> > If you follow the responses in that thread, you'll see it was fixed -
> > though you'll need to make a slight change to your form config file.
> 
> hmm, it seems I am missing something: I now have edited my edit.yml from
> ...
> 
> - type: Text
>   name: name
> - type: Select
>   name: genres
> 
> ... to ...
> 
> - type: Text
>   name: name
> - type: Select
>   name: genres
>   model_config:
>     default_column: me.genres_id
> 
> (By the way: "db: default_column: me.genres_id" as mentioned in the
> January-thread did not work for me - I did not find this "db" attribute
> mentioned.)
> 
> Now I can call my edit action in Catalyst, but when I want to save the
> edited data (i.e. press the 'Submit' button), I get a new error message:
> 
> DBIx::Class::ResultSet::count(): DBI Exception: DBD::mysql::st execute
> failed: Unknown column 'me.genres_id' in 'where clause' [for Statement "SELECT
> COUNT( * ) FROM genres me WHERE ( me.genres_id IN ( ? ) )" with
> ParamValues: 0='2']
-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger