View Single Post
  #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