comment on

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

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


laziness, impatience, and hubris
	PerlMonks