Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #31  
Old 7th November 2011, 21:24
neorom neorom is offline
Junior Member
 
Join Date: Nov 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
Sponsored Links
  #32  
Old 7th November 2011, 22:02
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,483
Thanks: 835
Thanked 5,524 Times in 4,345 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #33  
Old 20th November 2011, 17:05
Toucan Toucan is offline
Senior Member
 
Join Date: Dec 2009
Posts: 479
Thanks: 78
Thanked 40 Times in 34 Posts
Default

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
Reply With Quote
The Following 2 Users Say Thank You to Toucan For This Useful Post:
falko (21st November 2011), till (20th November 2011)
  #34  
Old 21st November 2011, 13:51
pititis pititis is offline
Senior Member
 
Join Date: Dec 2010
Location: München
Posts: 364
Thanks: 39
Thanked 89 Times in 68 Posts
Default

Yeah!

+1 to this update. Great job.
Reply With Quote
The Following User Says Thank You to pititis For This Useful Post:
till (21st November 2011)
  #35  
Old 23rd November 2011, 19:37
pititis pititis is offline
Senior Member
 
Join Date: Dec 2010
Location: München
Posts: 364
Thanks: 39
Thanked 89 Times in 68 Posts
Default

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?
Reply With Quote
  #36  
Old 24th November 2011, 09:42
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,483
Thanks: 835
Thanked 5,524 Times in 4,345 Posts
Default

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
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #37  
Old 24th November 2011, 13:05
jboud jboud is offline
Member
 
Join Date: Dec 2010
Posts: 57
Thanks: 11
Thanked 10 Times in 3 Posts
Default

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.
Reply With Quote
  #38  
Old 24th November 2011, 14:06
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,483
Thanks: 835
Thanked 5,524 Times in 4,345 Posts
Default

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
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
jboud (24th November 2011)
  #39  
Old 24th November 2011, 14:14
jboud jboud is offline
Member
 
Join Date: Dec 2010
Posts: 57
Thanks: 11
Thanked 10 Times in 3 Posts
Default

Thanks man, billing just got epic
Reply With Quote
  #40  
Old 24th November 2011, 14:34
pititis pititis is offline
Senior Member
 
Join Date: Dec 2010
Location: München
Posts: 364
Thanks: 39
Thanked 89 Times in 68 Posts
 
Default

Quote:
Originally Posted by till View Post
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.

Code:
Unknown column 'company_name_short' in 'field list'
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Proftpd + MySQL virtual users, can't connect geekman HOWTO-Related Questions 28 27th September 2010 19:03
ISPconfig 3: can't send or receive messages zogthegreat Installation/Configuration 6 22nd May 2010 15:45
Amavisd not identfying spam properly Cracklefish Installation/Configuration 11 22nd December 2009 12:05
ISPConfig 3: Monitor Module & Logfiles - All setup correctly? Master One Installation/Configuration 2 10th July 2009 19:51
proFTPd passive mode problems bisbell Server Operation 8 6th August 2008 22:12


All times are GMT +2. The time now is 16:34.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.