<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Times;
panose-1:2 2 6 3 5 4 5 2 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Hi All<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hoping someone can help<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We of course use dancer2 as a web app, but we also have some back end services that run as command line/service items. We include Dancer in those as we get a lot of the benefits. We recently started to use database calls in those backend
tools but we are getting odd results. In some setups they work, in others we get this error:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Use of uninitialized value in subroutine entry at /usr/local/share/perl5/Dancer2/Plugin.pm line 532.<o:p></o:p></p>
<p class="MsoNormal">Undefined subroutine &main:: called at /usr/local/share/perl5/Dancer2/Plugin.pm line 532.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have setup a simple test that shows the failure:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">#!/usr/bin/perl<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">use lib '/var/www/OMG/lib';<o:p></o:p></p>
<p class="MsoNormal">use Dancer2 appname => 'OMG';<o:p></o:p></p>
<p class="MsoNormal">use strict;<o:p></o:p></p>
<p class="MsoNormal">use warnings;<o:p></o:p></p>
<p class="MsoNormal">use Data::Dumper;<o:p></o:p></p>
<p class="MsoNormal">use Dancer2::Plugin::Database;<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">debug "begin \n";<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">my $sth = database->prepare("select * from public.external_application_token_get('')");<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">debug "end \n";<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">its related to the latest version of the plugin 2.17. 2.14 works. Any clues?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="330" style="width:247.5pt">
<tbody>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;line-height:105%">
<b><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black">Zahir Lalani<br>
Head of Development & Architecture<o:p></o:p></span></b></p>
</td>
</tr>
<tr style="height:22.5pt">
<td style="padding:0cm 0cm 0cm 0cm;height:22.5pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-family:"Times",serif;color:black;mso-fareast-language:EN-GB"><img width="100" height="18" style="width:1.0416in;height:.1833in" id="Picture_x0020_1" src="cid:image002.png@01D33388.100BE460" alt="cid:96F784CA-E917-4CC1-A9A9-96CBDA2AF2BC"></span><span style="font-size:12.0pt;line-height:105%;font-family:"Times",serif;color:black"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black">151 Rosebery Avenue,<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black">London,
</span><span style="color:black">EC1R 4AB</span><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black"> <o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black">m: +44 (0)7956 455168<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:EN-GB">t: +44 (0)203 142 3619</span><span style="font-size:10.5pt;color:black;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black">e: </span><u><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:#0563C1"><a href="mailto:zahirlalani@oliver-marketing.com">zahirlalani@oliver</a>.agency</span></u><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:105%"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black">w: www.oliver.agency<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>