asterisk2billing.org
http://forum.asterisk2billing.org/

invoices list is empty
http://forum.asterisk2billing.org/viewtopic.php?f=22&t=5559
Page 1 of 1

Author:  bgp [ Sun May 24, 2009 10:49 am ]
Post subject:  invoices list is empty

Hi !
I create test invoice for one customer with amount of 100, but invoices list is empty.
I use a2billing 1.4RC1 with postgresql-8.3 on ubuntu-9.0.4.

mya2billing=> select * from cc_invoice;
id | reference | id_card | date | paid_status | status | title | description
----+--------------+---------+---------------------+-------------+--------+--------+--------------------
2 | 200900000002 | 1 | 2009-05-21 02:20:43 | 0 | 0 | REFILL | Invoice for refill
3 | 200900000003 | 1 | 2009-05-21 02:21:21 | 0 | 0 | test | TEST
(2 rows)
mya2billing=> select * from cc_invoice_item;
id | id_invoice | date | price | vat | description | id_ext | type_ext
----+------------+----------------------------+-----------+------+-------------+--------+----------
1 | 2 | 2009-05-21 02:20:43 | 100.00000 | 0.00 | TEST | |
2 | 3 | 2009-05-21 02:22:01.656174 | 100.00000 | 0.00 | TEST | |
(2 rows)
posrgres log:
SELECT count(*) FROM (SELECT count(*) FROM cc_invoice LEFT JOIN cc_card ON cc_card.id=id_card LEFT JOIN cc_invoice_item ON cc_invoice_item.id_invoice=cc_invoice.id WHERE 1 GROUP BY cc_invoice.id) as tmp

with mysql database invoice list works fine

Author:  areski [ Wed May 27, 2009 11:30 am ]
Post subject:  Re: invoices list is empty

1.4 postgresql support is not finished unfortunately, there is some DB adaptation that might be needed.

Yours,
/Areski

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/