ISPConfig 3 Billing Module

[neorom]

Thanks you Till

It is working now. The command line that's changed the situation was the first one :
chmod 770 /usr/local/ispconfig/interface/invoices

Do you think this line is missing in your update script (from 3.0.3.3 to 3.0.4) ?

Thank you

Neorom

[till]

I will see if we can integrate the permission handling for that directory in the ispconfig installer too. Currently this directory is managed by the billing module updater.

[Toucan]

Wow, what a great update - love the new dashboard look to the front showing my profits for the year!

Thanks for the hardword - this help managing my bills so much easier

[pititis]

Yeah!

+1 to this update. Great job.

[pititis]

Something is missing in the sql update Till, company_name_short field don't exist in the invoice_company table.

Can you check it please?

[till]

The field is in the sql update but there was a bug in the updater so the database schema update can be incomplete. To fix that, please redo the sql update as described here:

http://bugtracker.ispconfig.org/inde...1861&project=5

[jboud]

Platform: Debian 5 lenny
Ispconfig 3.0.4

Updated the billing addon and everything seemed ok until I tried to create an invoice. This is a production server so I didn't test until required. Now I'm getting this error when finalizing a new invoice or a draft. Creation of a draft causes no problems but it's not summing up the prices.(not sure if it should)

Did this:
chmod 770 /usr/local/ispconfig/interface/invoices
chown ispconfig:ispconfig /usr/local/ispconfig/interface/invoices

Nothing changed.

Problem:
Warning: page_action::include(templates/pdf_invoice//make_pdf_invoice.php) [page-action.include]: failed to open stream: No such file or directory in /usr/local/ispconfig/interface/web/billing/invoice_edit.php on line 193

Warning: page_action::include() [function.include]: Failed opening 'templates/pdf_invoice//make_pdf_invoice.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /usr/local/ispconfig/interface/web/billing/invoice_edit.php on line 193

Fatal error: Class 'PDFInvoice_' not found in /usr/local/ispconfig/interface/web/billing/invoice_edit.php on line 196

Tried to dig it up a bit but can't be very careful now, not at home. I'm pretty sure that it's permission thingy.

[till]

You have the same issue with the database scheme that pitits posted. Please update the database scheme as described here to fix that:

http://bugtracker.ispconfig.org/inde...1861&project=5

[jboud]

Thanks man, billing just got epic

[pititis]

Originally Posted by till

The field is in the sql update but there was a bug in the updater so the database schema update can be incomplete. To fix that, please redo the sql update as described here:

http://bugtracker.ispconfig.org/inde...1861&project=5

I get this error AFTER apply this update(task 1861). This update work well but I think is not compete because 'company_name_short' is missing in invoice_company.

Unknown column 'company_name_short' in 'field list'