[Spce-user] Error generating invoice

[Henk]

Hi Irina,

Sorry I missed that. Now the first invoice works, but the second has 
another error:

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=""

Regards,

Henk

On 1-12-2017 12:19, Irina Peshinskaya wrote:
>
> Dear Henk,
>
> Just the same as was described yesterday, kindly upgrade your 
> ngcp-panel to the 5.5.1.5:
>
>      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'
>
> Best regards,
>
> Irina Peshinskaya
>
>
> On 01.12.2017 13:14, Henk wrote:
>>
>> Hi all,
>>
>> I'm on the latest version mr5.5.1 and cannot generate invoices 
>> anymore. In panel.log I get the following message:
>>
>> 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=""
>>
>> My current DB version is 15367. Did I miss a part of the DB upgrade?
>>
>> Regards,
>>
>> Henk Plessius
>>
>>
>>
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> https://lists.sipwise.com/listinfo/spce-user
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20171201/4a44c8d0/attachment-0001.html>