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/ |