That was very helpful thanks. The connection was a success and with debug I can see all the tables and columns being set up. In fact there seem to be 2 problems, not 1. The first problem is the error message 

Attempt to free unreferenced scalar: SV 0x1fa7a5c, Perl interpreter: 0
+x224234 at C:/Perl/site/lib/SQL/Abstract/Limit.pm line 325.

[download]

Some more tinkering has established that this is happening when the following line is executed:

@all_countries = $schema->resultset('Country')->all;

If I remove this line, it disappears. And yet it only happens when the schema is loaded via Loader - it does not appear when the schema is loaded via my manually created modules. The Loader debugger does not give any clues.

Further testing has established that the same message appears for the search, next and find methods in DBIx::Class::ResultSet. Also I've tried 3 tables and it happens with all. So it seems that the problem happens with multiple resultset methods against multiple tables but only when tables are loaded using the Loader module.

I'm not sure if it is related to the second problem which I will post as a separate response immediately following this post.

In reply to Re^2: DBIx::Class::Schema::Loader prob by jfrm
in thread DBIx::Class::Schema::Loader prob by jfrm

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.