Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Fri Mar 29, 2024 2:23 pm
Voice Broadcast System


All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: invoices list is empty
PostPosted: Sun May 24, 2009 10:49 am 
Offline

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


Top
 Profile  
 
 Post subject: Re: invoices list is empty
PostPosted: Wed May 27, 2009 11:30 am 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
1.4 postgresql support is not finished unfortunately, there is some DB adaptation that might be needed.

Yours,
/Areski


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 
Predictive Dialer


All times are UTC


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group