Reset billing module

Hi

I've been making tests with my recently bought billing module, and I want to start using it "inproduction". How could I delete all tests I made and start again with no clients and no invoices?

Thanks

 

Is their also a way to completely uninstall the billing module?

Regards,
MaddinXx

 

Thanks Till

However this does not remove the invoice block from clients interface.

Therefor I removed all files according to the files and folders.txt from the plugin as well as the invoice entry in dashboard.php.

Now, everything is gone and what I wanted

 

I did that but now I get:

Code:

0 db->query(SELECT * FROM invoice_settings WHERE invoice_settings_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:225] #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:197] #0 db->query(SELECT * FROM invoice WHERE status_printed = 'y' AND client_id = 3 ORDER BY invoice_date DESC, invoice_number DESC LIMIT 0,12) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:211] #1 db->queryAllRecords(SELECT * FROM invoice WHERE status_printed = 'y' AND client_id = 3 ORDER BY invoice_date DESC, invoice_number DESC LIMIT 0,12) called at [/usr/local/ispconfig/interface/web/dashboard/dashlets/invoices.php:26] #2 dashlet_invoices->show() called at [/usr/local/ispconfig/interface/web/dashboard/dashboard.php:197]

How do I get rid of that message?

 

I figured it out. I removed the invoice.php from the desklets directory.

 

yes I erased all invoice tables..

 

OK I ran.

Code:

CREATE TABLE IF NOT EXISTS `invoice_settings` (
  `invoice_settings_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sys_userid` int(11) NOT NULL DEFAULT '0',
  `sys_groupid` int(11) NOT NULL DEFAULT '0',
  `sys_perm_user` varchar(5) DEFAULT NULL,
  `sys_perm_group` varchar(5) DEFAULT NULL,
  `sys_perm_other` varchar(5) DEFAULT NULL,
  `date_format` varchar(255) DEFAULT NULL,
  `invoice_dir` varchar(255) NOT NULL,
  `invoice_pay_link` varchar(255) NOT NULL,
  `currency` varchar(64) NOT NULL DEFAULT 'EUR',
  `paypal_business` varchar(255) NOT NULL,
  `paypal_url` varchar(255) NOT NULL DEFAULT 'https://www.paypal.com/cgi-bin/webscr',
  `paypal_ipn_url` varchar(255) NOT NULL,
  `paypal_active` varchar(1) NOT NULL DEFAULT 'n',
  `invoice_item_list_with_vat` VARCHAR( 1 ) NOT NULL,
  `revnum` int(11) NOT NULL DEFAULT '17',
  `recurring_invoices_cron_active` enum('n','y') NOT NULL DEFAULT 'n',
  `recurring_invoices_cron_test` enum('n','y') NOT NULL DEFAULT 'n',
  `recurring_invoices_cron_finalize_invoices` enum('n','y') NOT NULL DEFAULT 'y',
  `recurring_invoices_cron_send_invoices` enum('n','y') NOT NULL DEFAULT 'y',
  `recurring_invoices_cron_email_template_id` bigint(20) NOT NULL DEFAULT '0',
  `recurring_invoices_cron_proforma_invoice` enum('n','y') NOT NULL DEFAULT 'n',
  `sepa_core_collectiondate_ooff` int(11) NOT NULL DEFAULT '6',
  `sepa_core_collectiondate_frst` int(11) NOT NULL DEFAULT '6',
  `sepa_core_collectiondate_rcur` int(11) NOT NULL DEFAULT '3',
  `sepa_cor1_collectiondate_ooff` int(11) NOT NULL DEFAULT '2',
  `sepa_cor1_collectiondate_frst` int(11) NOT NULL DEFAULT '2',
  `sepa_cor1_collectiondate_rcur` int(11) NOT NULL DEFAULT '2',
  `sepa_b2b_collectiondate_ooff` int(11) NOT NULL DEFAULT '6',
  `sepa_b2b_collectiondate_frst` int(11) NOT NULL DEFAULT '6',
  `sepa_b2b_collectiondate_rcur` int(11) NOT NULL DEFAULT '3',
  `sepa_mandate_reminders` enum('n','y') NOT NULL DEFAULT 'n',
  `sepa_mandate_reminders_frequency` int(11) NOT NULL DEFAULT '7',
  `sepa_mandate_reminders_subject` varchar(255) DEFAULT NULL,
  `sepa_mandate_reminders_msg` text NOT NULL,
  PRIMARY KEY (`invoice_settings_id`)
) ENGINE=MyISAM;

--
-- Dumping data for table `invoice_settings`
--

INSERT INTO `invoice_settings` (`invoice_settings_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `date_format`, `invoice_dir`, `invoice_pay_link`, `currency`, `paypal_business`, `paypal_url`, `paypal_active`, `revnum`) VALUES(1, 1, 1, 'riud', 'riud', NULL, 'd.m.Y', '', '', 'EUR', '[email protected]', 'https://www.paypal.com/cgi-bin/webscr', 'y', 9);

Restored the invoices.php dashlet and the same error returns.

 

You did not say empty all the tables, you said delete all the tables. So that is what I did. Should I just reload the SQL from the billing module??

 

I loaded the tables from the billing sql module and put the desklet back into the folder and I get no errors now.

 

That is what I wanted to do, uninstall the billing module. Like if I had never installed it.

 

You may also want to reset the AUTO_INCREMENT value under in the "Operations" tab.
However, if you 'empty' the tables, the AUTO_INCREMENT counter is reset to '1'.