<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Irina,</p>
<p>I found another problem. The invoices that are generated, have a
scaling problem. Every next page is scaled at about 66% of the
last one for the first 25 pages, then it start at 100% and scales
down again.</p>
<p>This is my panel-debug:</p>
<p><font size="-2"><tt>Dec 2 13:55:25 spce ngcp-panel: DEBUG:
rsvg-convert -a -f pdf -z 0.8 /tmp/_Q5YIBaFpx/1.svg
/tmp/_Q5YIBaFpx/2.svg /tmp/_Q5YIBaFpx/3.svg
/tmp/_Q5YIBaFpx/4.svg /tmp/_Q5YIBaFpx/5.svg
/tmp/_Q5YIBaFpx/6.svg /tmp/_Q5YIBaFpx/7.svg
/tmp/_Q5YIBaFpx/8.svg /tmp/_Q5YIBaFpx/9.svg
/tmp/_Q5YIBaFpx/10.svg /tmp/_Q5YIBaFpx/11.svg
/tmp/_Q5YIBaFpx/12.svg /tmp/_Q5YIBaFpx/13.svg
/tmp/_Q5YIBaFpx/14.svg /tmp/_Q5YIBaFpx/15.svg
/tmp/_Q5YIBaFpx/16.svg /tmp/_Q5YIBaFpx/17.svg
/tmp/_Q5YIBaFpx/18.svg /tmp/_Q5YIBaFpx/19.svg
/tmp/_Q5YIBaFpx/20.svg /tmp/_Q5YIBaFpx/21.svg
/tmp/_Q5YIBaFpx/22.svg /tmp/_Q5YIBaFpx/23.svg
/tmp/_Q5YIBaFpx/24.svg /tmp/_Q5YIBaFpx/25.svg</tt><tt><br>
</tt><tt>Dec 2 13:55:25 spce ngcp-panel: DEBUG: rsvg-convert -a
-f pdf -z 0.8 /tmp/_Q5YIBaFpx/26.svg /tmp/_Q5YIBaFpx/27.svg
/tmp/_Q5YIBaFpx/28.svg /tmp/_Q5YIBaFpx/29.svg
/tmp/_Q5YIBaFpx/30.svg /tmp/_Q5YIBaFpx/31.svg
/tmp/_Q5YIBaFpx/32.svg /tmp/_Q5YIBaFpx/33.svg
/tmp/_Q5YIBaFpx/34.svg /tmp/_Q5YIBaFpx/35.svg
/tmp/_Q5YIBaFpx/36.svg /tmp/_Q5YIBaFpx/37.svg
/tmp/_Q5YIBaFpx/38.svg /tmp/_Q5YIBaFpx/39.svg
/tmp/_Q5YIBaFpx/40.svg /tmp/_Q5YIBaFpx/41.svg
/tmp/_Q5YIBaFpx/42.svg /tmp/_Q5YIBaFpx/43.svg
/tmp/_Q5YIBaFpx/44.svg /tmp/_Q5YIBaFpx/45.svg
/tmp/_Q5YIBaFpx/46.svg /tmp/_Q5YIBaFpx/47.svg
/tmp/_Q5YIBaFpx/48.svg /tmp/_Q5YIBaFpx/49.svg
/tmp/_Q5YIBaFpx/50.svg</tt><tt><br>
</tt><tt>Dec 2 13:55:25 spce ngcp-panel: DEBUG: rsvg-convert -a
-f pdf -z 0.8 /tmp/_Q5YIBaFpx/51.svg /tmp/_Q5YIBaFpx/52.svg
/tmp/_Q5YIBaFpx/53.svg /tmp/_Q5YIBaFpx/54.svg
/tmp/_Q5YIBaFpx/55.svg /tmp/_Q5YIBaFpx/56.svg
/tmp/_Q5YIBaFpx/57.svg /tmp/_Q5YIBaFpx/58.svg
/tmp/_Q5YIBaFpx/59.svg /tmp/_Q5YIBaFpx/60.svg
/tmp/_Q5YIBaFpx/61.svg /tmp/_Q5YIBaFpx/62.svg
/tmp/_Q5YIBaFpx/63.svg /tmp/_Q5YIBaFpx/64.svg
/tmp/_Q5YIBaFpx/65.svg /tmp/_Q5YIBaFpx/66.svg
/tmp/_Q5YIBaFpx/67.svg /tmp/_Q5YIBaFpx/68.svg
/tmp/_Q5YIBaFpx/69.svg /tmp/_Q5YIBaFpx/70.svg
/tmp/_Q5YIBaFpx/71.svg /tmp/_Q5YIBaFpx/72.svg
/tmp/_Q5YIBaFpx/73.svg /tmp/_Q5YIBaFpx/74.svg
/tmp/_Q5YIBaFpx/75.svg</tt><tt><br>
</tt><tt>Dec 2 13:55:25 spce ngcp-panel: DEBUG: rsvg-convert -a
-f pdf -z 0.8 /tmp/_Q5YIBaFpx/76.svg /tmp/_Q5YIBaFpx/77.svg
/tmp/_Q5YIBaFpx/78.svg /tmp/_Q5YIBaFpx/79.svg
/tmp/_Q5YIBaFpx/80.svg /tmp/_Q5YIBaFpx/81.svg
/tmp/_Q5YIBaFpx/82.svg /tmp/_Q5YIBaFpx/83.svg
/tmp/_Q5YIBaFpx/84.svg /tmp/_Q5YIBaFpx/85.svg
/tmp/_Q5YIBaFpx/86.svg /tmp/_Q5YIBaFpx/87.svg
/tmp/_Q5YIBaFpx/88.svg /tmp/_Q5YIBaFpx/89.svg
/tmp/_Q5YIBaFpx/90.svg /tmp/_Q5YIBaFpx/91.svg
/tmp/_Q5YIBaFpx/92.svg /tmp/_Q5YIBaFpx/93.svg
/tmp/_Q5YIBaFpx/94.svg /tmp/_Q5YIBaFpx/95.svg
/tmp/_Q5YIBaFpx/96.svg</tt><tt><br>
</tt><tt>Dec 2 13:55:25 spce ngcp-panel: DEBUG: gs -dBATCH
-dNOPAUSE -q -sDEVICE=pdfwrite -dPDFSETTINGS=/prepress
-sOutputFile=- /tmp/_Q5YIBaFpx/1.pdf /tmp/_Q5YIBaFpx/2.pdf
/tmp/_Q5YIBaFpx/3.pdf /tmp/_Q5YIBaFpx/4.pdf</tt></font><br>
<br>
</p>
Regards,<br>
<br>
Henk Plessius<br>
<br>
<div class="moz-cite-prefix">On 1-12-2017 13:24, Henk wrote:<br>
</div>
<blockquote type="cite"
cite="mid:70aa5bb3-4c1d-ab72-e989-2209de309673@voipdigit.nl">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<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>
<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>