<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<html><body>
<p>Merely removing the create option makes this commend execute successfully.</p>
<p>I have updated the table schema manually.</p>
<p>Thanks for your suggestion.</p>
<p>But now the question is why it hangs with create=static option?</p>
<p>is it because of some permission issue.</p>
<p>all the *.pm files are owned by same user and run by same user. can there be any thing else which i m missing here?</p>
<p> </p>
<p>On Sat, 23 Apr 2011 10:56:38 +0530, Rohan M wrote:</p>
<blockquote type="cite" style="padding-left:5px; border-left:#1010ff 2px solid; margin-left:5px; width:100%"><!-- html ignored --><!-- head ignored --><!-- meta ignored -->
<p>Hi Vivek,</p>
<div>Try removing create=static from the command. This parameter is used to create the table structure automatically from the database.</div>
<div>Just to cross check whether you app is in working try doing following.</div>
<div>1) Create a table class in lib->Apty->Schema->Result->Table.pm</div>
<div>2) In Schema directory add Schema.pm with following </div>
<div> package Apty::Schema;
<div>use strict;</div>
<div>use warnings;</div>
<div>use base 'DBIx::Class::Schema';</div>
<div>__PACKAGE__->load_namespaces;</div>
<div># Created by DBIx::Class::Schema::Loader v0.04006 @ 2011-02-22 16:47:06</div>
<div># DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:foYv+STv7emsvGCJ4mWjIg</div>
<div># You can replace this text with custom content, and it will be preserved on regeneration</div>
<div>1;</div>
<div>3) Table.pm </div>
<div> package Apty::Schema::Result::Table.pm</div>
<div>use strict;</div>
<div>use warnings;</div>
<div>use base 'DBIx::Class';</div>
<div>__PACKAGE__->load_components("InflateColumn::DateTime", "Core");</div>
<div>__PACKAGE__->table("Table");</div>
<div>__PACKAGE__->add_columns(</div>
<div> "id",</div>
<div> { data_type => "INT", default_value => undef, is_nullable => 0, size => 20 },</div>
<div> "value",</div>
<div> {</div>
<div> data_type => "TEXT",</div>
<div> default_value => undef,</div>
<div> is_nullable => 0,</div>
<div> size => 65535,</div>
<div> },</div>
<div>);</div>
<div># Created by DBIx::Class::Schema::Loader v0.04006 @ 2011-02-22 16:47:06</div>
<div># DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oogTrnt1wIwBbA7hgj7axA</div>
<div># You can replace this text with custom content, and it will be preserved on regeneration</div>
<div>1;</div>
<div>If above thing works out then there is certainly problem with db side. May be relations are not properly set.</div>
<div>Also if it doesn't work try comment out __Package=>immutable thing.</div>
<div>Hope this works..</div>
<br />
<div class="gmail_quote">On Sat, Apr 23, 2011 at 1:04 AM, Vivek Chhikara <span><<a href="mailto:vivek@chhikara.org">vivek@chhikara.org</a>></span> wrote:<br />
<blockquote class="gmail_quote" style="margin: 0 0 0 .8ex; border-left: 1px #ccc solid; padding-left: 1ex;">
<div>
<p>I just checked my app trace and below warning also added to list.</p>
<pre><br />Not inlining a constructor for Apty::Schema since its parent DBIx::Class::Schema doesn't contain a 'new' method. <br />If you are certain you don't need to inline your constructor, specify inline_constructor => 0 in your call to Apty::Schema->meta->make_immutable</pre>
<div>
<div class="h5">
<pre> </pre>
<p>On Sat, 23 Apr 2011 00:08:45 +0530, Vivek Chhikara wrote:</p>
<blockquote style="padding-left: 5px; border-left: #1010ff 2px solid; margin-left: 5px; width: 100%;">
<p>Folks,</p>
<p>I added a few columns to one of my mysql table and tried to reload the DB model. </p>
<p>But it hangs ofter displaying below output.</p>
<pre>-bash-3.2$ ./<a href="http://apty_create.pl">apty_create.pl</a> model DB DBIC::Schema Apty::Schema create=static dbi:mysql:database user password<br /> exists "/home/apty/script/../lib/Apty/Model"<br />
exists "/home/apty/script/../t"<br /><br />^C<br />-bash-3.2$</pre>
<pre> </pre>
<pre>I tried to connect to the db using mysql with above user+password and I am able to connnect.</pre>
<pre> </pre>
<pre>Any clue is appreciated. </pre>
<div> </div>
</blockquote>
<p> </p>
<div> </div>
</div>
</div>
</div>
<br />_______________________________________________<br /> List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br /> Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br /> Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/">http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br /> Dev site: <a href="http://dev.catalyst.perl.org/">http://dev.catalyst.perl.org/</a><br /><br /></blockquote>
</div>
<br /><br clear="all" /><br />-- <br /><span style="font-size: large; line-height: 32px;">रोहन मल्लेल्रवार</span>
<div><span style="line-height: 32px; font-size: large;"><br /></span></div>
b</div>
</blockquote>
<p> </p>
<div> </div>
</body></html>