Reset billing module

Discussion in 'General' started by Davide, Mar 25, 2012.

  1. Davide

    Davide New Member HowtoForge Supporter

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Delete all records in the invoice and invoice_item tables with phpmyadmin. The billing module has no separate lients, so if you want to remove clients, the delete them in ispconfig.
     
    sleepingranch and DDArt like this.
  3. MaddinXx

    MaddinXx Member HowtoForge Supporter

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

    Regards,
    MaddinXx
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Run:

    rm -rf /usr/local/ispconfig/interface/web/billing
    rm -rf /usr/local/ispconfig/interface/invoices

    and then delete all tables that start with "invoice" in the ispconfig mysql database.
     
    DDArt likes this.
  5. MaddinXx

    MaddinXx Member HowtoForge Supporter

    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 :)
     
  6. fbarcenas

    fbarcenas Member

    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?
     
  7. fbarcenas

    fbarcenas Member

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

    till Super Moderator Staff Member ISPConfig Developer

    Did you empty the table invoice_settings? This table contains the settings of the billing module, it will not work properly anyore when this table was emptied. So thats not a issue with the dashlet that you removed.
     
  9. fbarcenas

    fbarcenas Member

    yes I erased all invoice tables..
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    You can get the record for this table back by using the sql dump that you can find in the billing module zip file. copy the line that inserts the record and run it with phpmyadmin in the dbispconfig database of your billing installation.
     
  11. fbarcenas

    fbarcenas Member

    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.
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    Do you mean that you emptied them or did you really deleted the tables? If they were deleted, then the billing module needs to be installed from scratch.
     
    sleepingranch likes this.
  13. fbarcenas

    fbarcenas Member

    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??
     
  14. fbarcenas

    fbarcenas Member

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

    till Super Moderator Staff Member ISPConfig Developer

    That's post #4 which is the answer of #3 in this thread and the question in #3 was "Is their also a way to completely uninstall the billing module?".

    The question aof the thread starter on how to reset the module was already answered in #2.
     
    sleepingranch likes this.
  16. fbarcenas

    fbarcenas Member

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

Share This Page