Frequently Asked Questions

Why does my license show an expiration date? I thought FusionInvoice was buy once, use forever?

Why can't I change my invoice status to Paid?

Why aren't my recurring invoices working?

I forgot my password - how can I reset it?

Why do the totals on my dashboard all show zero?

Can FusionInvoice work with XYZ payment gateway?

How can I remove index.php from my URL?

How can I force my FusionInvoice installation to be served over https?

How can I resolve the Row Size Too Large error?

Why does my license show an expiration date? I thought FusionInvoice was buy once, use forever?

You're right - it is, and it always will be! Renewing your support period is completely optional. FusionInvoice will never stop working simply because your support period has expired. Renewing your support period gives you access to another full year of support and program updates (every update, including major version releases).

Why can't I change the status to paid?

The paid status is the only status you cannot manually change an invoice to. To change an invoice to Paid status, the invoice must have a payment made in full. Once the invoice has no remaining balance, the status will automatically update to Paid.

Why aren't my recurring invoices working?

First, check the Next Date of the recurring invoice you expect should have generated.

1. Click Recurring Invoices.
2. The date in the Next Date field indicates the date which this invoice should recur next. If this date is in the future, then the invoice isn't ready to recur yet.

If the Next Date is today's date or prior to today's date but the recurring invoice hasn't been generated, then the next step would be to visit http://YourFusionInvoiceURL/tasks/run (or http://YourFusionInvoiceURL/index.php/tasks/run if you have to specify index.php in your URL).

One of two things will happen when you visit this URL in your browser:

1. You'll be greeted by an empty, white page. This is good - if you go back to check your list of recurring invoices, you should find that the Next Date has incremented to the next date in the set frequency. You should also find that the new invoice has appeared in your list of invoices. If this is the case. then the Task Scheduler cron job hasn't been set up or has been set up improperly.
2. You'll be greeted with a lovely, "Whoops..." error message. If this is the case, there will be details logged at the bottom of your storage/logs/laravel.log file. If you are unable to determine the cause of the problem after reviewing the file, email a copy of the log file to [email protected] along with a description of the problem you're having.

I forgot my password - how can I reset it?

1. Download the Reset Password utility.
2. Unzip the contents.
3. Upload the unzipped ResetPassword folder to the app/Modules folder on your server so that it becomes app/Modules/ResetPassword.
4. Visit your FusionInvoiceURL/resetpassword to reset your password.
5. Once your password has been reset, delete the app/Modules/ResetPassword folder from your server.

Why do the totals on my dashboard all show zero?

There are settings on the Dashboard tab of System Settings which control this behavior for both quotes and invoices. The default option is Year to Date. This can be changed to This Quarter, All Time, or Custom Date Range.

Can FusionInvoice work with XYZ payment gateway?

How can I remove index.php from my URL?

If you're using Apache, try these things in the order they're listed below:

1. Verify that the .htaccess file distributed in the FusionInvoice download file was actually uploaded to your server. This file should exist in the root folder of your FusionInvoice installation (in the same folder as the index.php file). This file should work out of the box 99% of the time for Apache environments.
2. Make sure the Apache mod_rewrite module is installed and enabled. If you are unsure of how to check for this, contact your web host support or system administrator to ask them.
3. Open the .htaccess file and change this:

   RewriteEngine On

   to this:

   RewriteEngine On
           RewriteBase /

   If RewriteBase / makes no difference, you can also try:

   RewriteEngine On
           RewriteBase /TheNameOfYourFusionInvoiceFolder/

If you're using nginx:

Add the following location directive (or change your existing location directive) in your site configuration file:

        location / {
            try_files $uri $uri/ /index.php?$query_string;
        }
        

If you're using IIS:

Use this guide to import the include mod_rewrite rules from the .htaccess file into a web.config file for IIS.

How can I force my FusionInvoice installation to be served over https?

Version 2018-4 added an option to the General tab of System Settings which will force FusionInvoice to be served over https. Prior to enabling this option, be sure your FusionInvoice installation is functional via https. Failure to do so may result in a non-functional (but fixable) installation.

It is recommended that your server environment be configured to redirect incoming requests from http to https, but if this is not an option, you may enable the Force HTTPS option in System Settings.

If you're unable to access your installation after enabling the Force HTTPS option, run the following query in your FusionInvoice database to undo the change:

        update settings set setting_value = '0' where setting_key = 'forceHttps'
        

Resolving Row Size Too Large Database Error

In rare instances users have reported the following error when attempting to upgrade:
"SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126"
This is due to an incompatible Row Format setting. Please check the Row Options set on your FusionInvoice database's tables and change the setting to "Don/'t Use" or "Dynamic".
It is recommended that you change the setting on all tables within your database. Below is an example command to run to change these settings for the clients table:

            alter table clients ROW_FORMAT=DYNAMIC;