<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<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">Spce-user@lists.sipwise.com</a>
<a class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
</blockquote>
<br>
</body>
</html>