<div dir="ltr">Here is the output after using Test::DiagINC and I don't see SQL::Abstract in the list but I see DBIx::Class version is <b> 0.08270</b><div><br>DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::Pg::st execute failed: ERROR: syntax error at or near "IDENT"<br>
LINE 1: ... JOIN "AlertProfile" "Profile" ON "Profile"."Id" IDENT $1 W...<br> ^ [for Statement "SELECT "me"."Id", "me"."ProfileId", "me"."Name", "me"."Type", "me"."Sou<br>
rce", "me"."Destination", "me"."Activated", "me"."AlertStopId", "me"."EnorDisabledUserId", "me"."CreatedUserId", "me"."CreatedEpoch", "me"."UpdatedUse<br>
rId", "me"."UpdatedEpoch", "me"."DeletedUserId", "me"."DeletedEpoch" FROM "AlertContact" "me" JOIN "AlertProfile" "Profile" ON "Profile"."Id" IDENT ?<br>
WHERE ( ( "Name" = ? AND "Profile"."ReferenceId" = ? ) )" with ParamValues: 1='me.ProfileId', 2='Office Email', 3='71717171711'] at t/sheeju/10_alert<br><a href="http://s.pl">s.pl</a> line 23<br>
# Listing modules from %INC<br># 5.71 AutoLoader <br># 1.29 B <br># 0.12 B::Hooks::EndOfScope <br>
# 0.12 B::Hooks::EndOfScope::XS <br># 1.32 Carp <br># 6.04 Carp::Clan <br>
# 1.32 Carp::Heavy <br># 0.34 Class::Accessor <br># 0.34 Class::Accessor::Fast <br>
# 0.10010 Class::Accessor::Grouped <br># 1.001000 Class::C3::Componentised <br># 0.04004 Class::Data::Accessor <br>
# 0.08 Class::Data::Inheritable <br># 1.28 Class::Inspector <br># 0.20 Class::Load <br>
# 0.06 Class::Load::XS <br># 2.1005 Class::MOP <br># 2.1005 Class::MOP::Attribute <br>
# 2.1005 Class::MOP::Class <br><b># 2.19.3 DBD::Pg <br># 1.627 DBI <br># 0.08270 DBIx::Class </b> <br>
</div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><div><br></div>Best Regards, <br>Sheeju Alex<br>
<div style="display:inline"></div></div></div>
<br><br><div class="gmail_quote">On Wed, Feb 12, 2014 at 8:00 PM, Peter Rabbitson <span dir="ltr"><<a href="mailto:rabbit+dbic@rabbit.us" target="_blank">rabbit+dbic@rabbit.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="">On Wed, Feb 12, 2014 at 01:25:41PM +0530, Sheeju Alex wrote:<br>
> I have upgraded to SQL::Abstract 1.77 version but still I see this issue<br>
><br>
> I have upgraded to DBIx::Class 0.08270 version but still I see this issue<br>
><br>
> Here is the relationship between AlertContact table and AlertProfile<br>
><br>
> __PACKAGE__->belongs_to(<br>
> Profile => 'PAMS::WWW::Schema::Result::AlertProfile',<br>
> {<br>
> 'foreign.Id' => 'self.ProfileId'<br>
> }<br>
> );<br>
><br>
> Here is the search call<br>
><br>
> my $alert_contact = $c->model('PAMSDB::AlertContact')->search(<br>
> {<br>
> 'Profile.ReferenceId' => $profile->{ID},<br>
> 'Name' => $href->{ContactMethod}<br>
> },<br>
> {'join' => 'Profile'}<br>
> )->first;<br>
><br>
> Still this gives below Error<br>
<br>
</div>Please install Test::DiagINC and use it somewhere in your script. When<br>
things blow up it will output a list of loaded modules to STDERR. Double<br>
and tripple check that SQLA is indeed 1.77. The error below does not<br>
have another obvious explanation (for now).<br>
<div class=""><br>
> Statement "SELECT * FROM "AlertContact" "me" JOIN "AlertProfile" "Profile"<br>
> ON "Profile"."Id" IDENT ? WHERE ( ( "Name" = ? AND "Profile"."ReferenceId"<br>
> = ? ) )" with ParamValues: 1='me.ProfileId', 2='Office Email', 3='1']<br>
><br>
<br>
</div>Cheers<br>
<br>
<br>
_______________________________________________<br>
List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>
IRC: <a href="http://irc.perl.org#dbix-class" target="_blank">irc.perl.org#dbix-class</a><br>
SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" target="_blank">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>
Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" target="_blank">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a><br>
</blockquote></div><br></div>