Joined: Wed May 13, 2009 7:19 am Posts: 24
|
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
|
|