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.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

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 09:14.


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