Hi, I have troubles with formfu checkboxgroup/DBIx. I build a very simple example of standard category = product mapping in Catalyst 5.90016. ( Same problem I got with earlier versions of all components )

The following example populates all the selected "categroies" ( e.g. content in the example ) but throws exception when trying to save.

Seems like DBIx doesn't pass the schemaname ( 'page_content_map' instead of 'web.page_content_map' ) or perhaps is it somehow connected with perlbrew ... ? I have build the model with 'qualify_objects=1 db_schema=SCHEMANAME' and the correct prefix is in all models and resultsets.

Thanks for any help in advance. Follows the declaration of the 3 tables + yml + DBI exception.

__PACKAGE__->table("web.page");

__PACKAGE__->has_many(
  "page_content_maps",
  "Web::Schema::Result::PageContentMap",
  { "foreign.page_id" => "self.id" },
  { cascade_copy => 0, cascade_delete => 0 },
);

__PACKAGE__->many_to_many(
        'content' => 'page_content_maps',
        'content'
);

__PACKAGE__->table("web.content");

__PACKAGE__->has_many(
  "page_content_maps",
  "Web::Schema::Result::PageContentMap",
  { "foreign.content_id" => "self.id" },
  { cascade_copy => 0, cascade_delete => 0 },
);

__PACKAGE__->many_to_many(
        'page' => "page_content_maps",
        'page'
);

__PACKAGE__->table("web.page_content_map");

__PACKAGE__->belongs_to(
  "content",
  "Web::Schema::Result::Content",
  { id => "content_id" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE"
+ },
);

__PACKAGE__->belongs_to(
  "page",
  "Web::Schema::Result::Page",
  { id => "page_id" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE"
+ },
);

yml

[download]
- type: Checkboxgroup
            name: content
            label: Content
            model_config:
              model: 'Web::Content'

[download]
Exception 
DBI Exception: DBD::Pg::st execute failed: ERROR: relation "page_conte
+nt_map" does not exist LINE 1: DELETE FROM "page_content_map" WHERE (
+ "page_id" = $1 ) ^ [for Statement "DELETE FROM "page_content_map" WH
+ERE ( "page_id" = ? )" with ParamValues: 1='2'] at /home/bugsy/perl5/
+perlbrew/perls/perl-5.16.1/lib/site_perl/5.16.1/DBIx/Class/Schema.pm 
+line 1101.

[download]

In reply to FormFu nested checkboxgroup by bugsy

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.