<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Irina,</p>
<p>Sorry I missed that. Now the first invoice works, but the second
has another error:</p>
<p><font size="-1"><tt>MSG="Failed to create invoice ({UNKNOWN}:
Can't call method "start" on an undefined value at
/usr/share/perl5/NGCP/Panel/Utils/Invoice.pm line 61. at
/usr/share/perl5/Catalyst/Model/DBIC/Schema.pm line 526#012)"
LOG=""</tt></font><br>
</p>
Regards,<br>
<br>
Henk<br>
<br>
<div class="moz-cite-prefix">On 1-12-2017 12:19, Irina Peshinskaya
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:b9f50067-47f9-cd48-d79b-c252e80a9faa@sipwise.com">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<p>Dear Henk,</p>
<p>Just the same as was described yesterday, kindly upgrade your
ngcp-panel to the 5.5.1.5:</p>
<pre wrap=""> apt-get update
apt-get install ngcp-panel
ngcpcfg apply 'commit mesasge'
or better update to latest hotfixes:
apt-get update && apt-get upgrade && \
ngcp-update-db-schema && ngcp-update-cfg-schema && \
ngcpcfg apply 'commit message'</pre>
<p>Best regards,</p>
<p>Irina Peshinskaya<br>
</p>
<br>
<div class="moz-cite-prefix">On 01.12.2017 13:14, Henk wrote:<br>
</div>
<blockquote
cite="mid:f2ab4498-4506-dac8-6ac7-04faf6b5849d@voipdigit.nl"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=utf-8">
<p>Hi all,</p>
<p>I'm on the latest version mr5.5.1 and cannot generate
invoices anymore. In panel.log I get the following message:<br>
</p>
<p><font size="-1"><tt>MSG="Failed to create invoice ....
Unknown column 'me.source_cli_suppression_id' in 'field
list' [for Statement "SELECT `me`.`source_user`,
`me`.`source_domain`, `me`.`source_cli`,
`me`.`destination_user_in`,
`me`.`source_cli_suppression_id`,
`me`.`destination_user_in_suppression_id`,
`me`.`start_time`, `me`.`duration`, `me`.`call_type`,
`me`.`source_customer_cost`,
`source_customer_billing_zones_history`.`zone`,
`source_customer_billing_zones_history`.`detail` FROM
`accounting`.`cdr` `me` LEFT JOIN
`billing`.`billing_zones_history`
`source_customer_billing_zones_history` ON
`source_customer_billing_zones_history`.`id` =
`me`.`source_customer_billing_zone_id` WHERE ( (
`call_status` = ? AND `source_account_id` = ? AND
`source_user_id` != ? AND ( `start_time` >= ? AND
`start_time` <= ? ) ) ) ORDER BY `start_time`" with
ParamValues: 0='ok', 1="26", 2='0', 3=1509494400,
4=1512086399] at
/usr/share/perl5/NGCP/Panel/Utils/Invoice.pm line 84#012)"
LOG=""</tt></font></p>
<p>My current DB version is 15367. Did I miss a part of the DB
upgrade?</p>
<p>Regards,</p>
<p>Henk Plessius<br>
</p>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Spce-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com" moz-do-not-send="true">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user" moz-do-not-send="true">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>