[Spce-user] Error generating invoice
Henk
henk at voipdigit.nl
Fri Dec 1 06:14:56 EST 2017
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20171201/8c4a7ce5/attachment.html>
More information about the Spce-user
mailing list