Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 29th December 2012, 21:59
agentmoller001 agentmoller001 is offline
Junior Member
 
Join Date: Feb 2012
Location: Glendora, CA - USA
Posts: 11
Thanks: 10
Thanked 8 Times in 3 Posts
Default ISPConfig 3.05 RC1 & Billing Module (Debian Squeeze)

After installing a clean install of (in this order) Debian Squeeze, ISPConfig 3.0.4.6, billing module and then updated ISPConfig 3.05, I am getting this code below when I select the billing module:

Quote:
DB::query(SELECT * FROM invoice_settings WHERE invoice_settings_id = 1) -> mysqli_query Table 'dbispconfig.invoice_settings' doesn't exist#0 db->query(SELECT * FROM invoice_settings WHERE invoice_settings_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT * FROM invoice_settings WHERE invoice_settings_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/billing_functions.inc.php:15] #2 billing_functions->get_invoice_settings() called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:14] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-12-01' AND '2012-12-31') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-12-01' AND '2012-12-31') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-12-01' AND '2012-12-31') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:20] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-11-01' AND '2012-11-30') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-11-01' AND '2012-11-30') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-11-01' AND '2012-11-30') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:28] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-01-01' AND '2012-12-31') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-01-01' AND '2012-12-31') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-01-01' AND '2012-12-31') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:36] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2011-01-01' AND '2011-12-31') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2011-01-01' AND '2011-12-31') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2011-01-01' AND '2011-12-31') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:44] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-01-01' AND '2012-01-31') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-01-01' AND '2012-01-31') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-01-01' AND '2012-01-31') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-02-01' AND '2012-02-29') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-02-01' AND '2012-02-29') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-02-01' AND '2012-02-29') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-03-01' AND '2012-03-31') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-03-01' AND '2012-03-31') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-03-01' AND '2012-03-31') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-04-01' AND '2012-04-30') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-04-01' AND '2012-04-30') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-04-01' AND '2012-04-30') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-05-01' AND '2012-05-31') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-05-01' AND '2012-05-31') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-05-01' AND '2012-05-31') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-06-01' AND '2012-06-30') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-06-01' AND '2012-06-30') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-06-01' AND '2012-06-30') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-07-01' AND '2012-07-31') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-07-01' AND '2012-07-31') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-07-01' AND '2012-07-31') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-08-01' AND '2012-08-31') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-08-01' AND '2012-08-31') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-08-01' AND '2012-08-31') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-09-01' AND '2012-09-30') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-09-01' AND '2012-09-30') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-09-01' AND '2012-09-30') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-10-01' AND '2012-10-31') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-10-01' AND '2012-10-31') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-10-01' AND '2012-10-31') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-11-01' AND '2012-11-30') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-11-01' AND '2012-11-30') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-11-01' AND '2012-11-30') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-12-01' AND '2012-12-31') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-12-01' AND '2012-12-31') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT sum(invoice_amount) as income FROM invoice WHERE (invoice_type = 'invoice' or invoice_type = 'refund') AND status_printed = 'y' AND invoice_date BETWEEN '2012-12-01' AND '2012-12-31') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:53] DB::query(SELECT * FROM invoice WHERE status_printed = 'y' ORDER BY invoice_date DESC LIMIT 0,5) -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT * FROM invoice WHERE status_printed = 'y' ORDER BY invoice_date DESC LIMIT 0,5) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:112] #1 db->queryAllRecords(SELECT * FROM invoice WHERE status_printed = 'y' ORDER BY invoice_date DESC LIMIT 0,5) called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:68] DB::query(SELECT invoice_payment_term_id AS id,due_days FROM invoice_payment_term) -> mysqli_query Table 'dbispconfig.invoice_payment_term' doesn't exist#0 db->query(SELECT invoice_payment_term_id AS id,due_days FROM invoice_payment_term) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:112] #1 db->queryAllRecords(SELECT invoice_payment_term_id AS id,due_days FROM invoice_payment_term) called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:86] DB::query(SELECT * FROM client, invoice WHERE client.client_id = invoice.client_id AND invoice.status_printed = 'y' AND invoice.status_paid = 'n') -> mysqli_query Table 'dbispconfig.invoice' doesn't exist#0 db->query(SELECT * FROM client, invoice WHERE client.client_id = invoice.client_id AND invoice.status_printed = 'y' AND invoice.status_paid = 'n') called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:112] #1 db->queryAllRecords(SELECT * FROM client, invoice WHERE client.client_id = invoice.client_id AND invoice.status_printed = 'y' AND invoice.status_paid = 'n') called at [/usr/local/ispconfig/interface/web/billing/billing_dashboard.php:97]
and this on the Home tab:

Quote:
DB::query(SELECT * FROM invoice_settings WHERE invoice_settings_id = 1) -> mysqli_query Table 'dbispconfig.invoice_settings' doesn't exist#0 db->query(SELECT * FROM invoice_settings WHERE invoice_settings_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:126] #1 db->queryOneRecord(SELECT * FROM invoice_settings WHERE invoice_settings_id = 1) called at [/usr/local/ispconfig/interface/web/dashboard/dashlets/invoices.php:21] #2 dashlet_invoices->show() called at [/usr/local/ispconfig/interface/web/dashboard/dashboard.php:162]
Is the billing module not compatible with the 3.0.5 (RC1) version of ISPConfig yet?

Screen shots are attached.
Attached Images
  
__________________
ISPConfig 3 web hosting at charterhosting.com
Reply With Quote
Sponsored Links
  #2  
Old 30th December 2012, 19:20
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,421
Thanks: 834
Thanked 5,501 Times in 4,330 Posts
Default

Seems as if the billing module was not installed correcly under 3.0.4.6 befaor you updated beacuse one of the tables is missing. You can try to fix this by deleting all tables starting with "invoice" in their table name in the ispconfig mysql database, then load the file sql/ispconfig3_billing.sql from the ispconfig billing module zip file with phpmyadmin into the dbispconfig mysql database.

The billing module 1.2 is for ISPConfg 3.0.4 but should work on 3.0.5 with some minor issues, a billing module for 3.0.5 will be released togehter with ISPConfig 3.0.5 final.

If you need a prerelease of the billing module for 3.0.5 RC1, please contact us by email to the address you received the billing module from.
__________________
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:
agentmoller001 (30th December 2012)
  #3  
Old 31st December 2012, 00:54
agentmoller001 agentmoller001 is offline
Junior Member
 
Join Date: Feb 2012
Location: Glendora, CA - USA
Posts: 11
Thanks: 10
Thanked 8 Times in 3 Posts
 
Thumbs up It Worked Perfect!

It worked perfect after the sql/ispconfig3_billing.sql file import to phpmyadmin.

Thanks!

P.S. - ISPConfig 3 is my favorite hosting control panel. Everyday I find out more and more how powerful of a control panel it is. Thanks for all you guys do!
__________________
ISPConfig 3 web hosting at charterhosting.com
Reply With Quote
The Following 2 Users Say Thank You to agentmoller001 For This Useful Post:
falko (31st December 2012), till (31st December 2012)
Reply

Bookmarks

Tags
billing module, compatibility, ispconfig 3.0.5

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
SquirrelMail login not working glenneh Installation/Configuration 13 9th April 2011 21:01
ISPConfig 3.0.0.8 RC1 released till General 92 22nd February 2010 10:52
Amavisd not identfying spam properly Cracklefish Installation/Configuration 11 22nd December 2009 12:05
[debian 5 + ispconfig 3] Unable to send mail tanakskool HOWTO-Related Questions 6 4th November 2009 19:20
Installation Problems Exilebear Installation/Configuration 4 13th May 2008 14:05


All times are GMT +2. The time now is 06:45.


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