Your database can be easily backed up using the 'Download Database Backup' button at the top of the System Settings page. Use an FTP utility such as FileZilla or direct file access from your hosting control panel to download a copy of your site files.
Log into your account at FusionInvoice.com, ensure your support/update plan is up to date, and download the latest package. Save it locally to your computer.
Navigate to the downloaded install package and unzip the contents into a temporary folder on your computer.
Delete these folders from the FusionInvoice installation on your server:
Upload the following folders and files from the installer package to the FusionInvoice folder on your server:
It is recommended that you use a standard FTP program such as FileZilla to upload the files to your server.
Delete all existing files from within the following directories:
This step involves running the setup process, which performs all the new version updates to your
FusionInvoice
database.
To avoid caching issues that could cause a failed upgrade and general unhappiness, we recommend that
you
run the update in a private/incognito browser window . If you wish to run the update in your
normal (non-private) browser
window, first close your browser. If you have multiple browser windows open, you must close them all.
From the newly opened browser window, navigate to http://YourFusionInvoiceURL/setup. If your
http://YourFusionInvoiceURL/setup produces an error, try using
http://YourFusionInvoiceURL/index.php/setup instead. When finished, your database will be updated. Once
this step is completed, you
will be able to log back into your upgraded FusionInvoice system.
Your database can be easily backed up using the 'Download Database Backup' button at the top of the System Settings page. Use an FTP utility such as FileZilla or direct file access from your hosting control panel to download a copy of your site files.
There were many requirement changes from the previous version. This is an important step.
Log into your account at FusionInvoice.com, ensure your support/update plan is up to date, and download the latest package. Save it locally to your computer.
Navigate to the downloaded install package and unzip the contents into a temporary folder on your computer.
In previous releases, it was possible to transfer your license key and database information by copying the older files. Due to important modifications to the code within those files, that is not possible with this release.
Copy the following section, which will be contain your database connection information, from the /config/database.php of your existing installation into a separate text file.
'mysql' => [
'host' => 'yourhost',
'database' => 'yourdatabasename',
'username' => 'yourusername',
'password' => 'yourpassword',
'prefix' => '',
'driver' => 'mysql',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'strict' => false,
],
Copy your license key, which should be in the section that looks similar to the code below:
'key' => 'YourLicenseKeywillbehere',
Delete these folders from the FusionInvoice installation on your server:
Upload the following folders and files from the installer package to the FusionInvoice folder on your server:
It is recommended that you use a standard FTP program such as FileZilla to upload the files to your server.
Delete all existing files from within the following directories:
Find the following section of code in /config/database.php and replace it with the information from the old database.php file in Step 4.
'mysql' => [
'host' => 'yourhost',
'database' => 'yourdatabasename',
'username' => 'yourusername',
'password' => 'yourpassword',
'prefix' => '',
'driver' => 'mysql',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'strict' => false,
],
Enter your license key into /config/app.php.
'key' => 'Enteryourlicensekeyhere',
The media folder will require recursive read, write, and modify permissions.
This step involves running the setup process, which performs all the new version updates to your
FusionInvoice
database.
To avoid caching issues that could cause a failed upgrade and general unhappiness, we recommend
that you
run the update in a private/incognito browser window . If you wish to run the update in your
normal (non-private) browser
window, first close your browser. If you have multiple browser windows open, you must close them
all.
From the newly opened browser window, navigate to http://YourFusionInvoiceURL/setup. If your
http://YourFusionInvoiceURL/setup produces an error, try using
http://YourFusionInvoiceURL/index.php/setup instead. When finished, your database will be updated.
Once this step is completed, you
will be able to log back into your upgraded FusionInvoice system.
*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 FusionInvoice database.
Below is an
example command to run, to change the settings for your client table:
alter table clients ROW_FORMAT=DYNAMIC;
Your database can be easily backed up using the 'Download Database Backup' button at the top of the System Settings page. Use an FTP utility such as FileZilla or direct file access from your hosting control panel to download a copy of your site files.
There were many requirement changes from the previous version. This is an important step.
Log into your account at FusionInvoice.com, ensure your support/update plan is up to date, and download the latest package. Save it locally to your computer.
Navigate to the downloaded install package and unzip the contents into a temporary folder on your computer.
In previous releases, it was possible to transfer your license key and database information by copying the older files. Due to important modifications to the code within those files, that is not possible with this release.
Copy the following section, which will be contain your database connection information, from the /config/database.php of your existing installation into a separate text file.
'mysql' => [
'host' => 'yourhost',
'database' => 'yourdatabasename',
'username' => 'yourusername',
'password' => 'yourpassword',
'prefix' => '',
'driver' => 'mysql',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'strict' => false,
],
Copy your license key, which should be in the section that looks similar to the code below:
'key' => 'YourLicenseKeywillbehere',
Delete these folders from the FusionInvoice installation on your server:
Upload the following folders and files from the installer package to the FusionInvoice folder on your server:
It is recommended that you use a standard FTP program such as FileZilla to upload the files to your server.
Delete all existing files from within the following directories:
Find the following section of code in /config/database.php and replace it with the information from the old database.php file in Step 4.
'mysql' => [
'host' => 'yourhost',
'database' => 'yourdatabasename',
'username' => 'yourusername',
'password' => 'yourpassword',
'prefix' => '',
'driver' => 'mysql',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'strict' => false,
],
Enter your license key into /config/app.php.
'key' => 'Enteryourlicensekeyhere',
The media folder will require recursive read, write, and modify permissions.
Visit http://YourFusionInvoiceURL/setup in your web browser. If your http://YourFusionInvoiceURL/setup produces an error, try using http://YourFusionInvoiceURL/index.php/setup instead. This step will upgrade your database. Once this step is completed, you should be able to log back into your upgraded FusionInvoice system.
If you are using custom quote and/or invoice templates, there are some changes you'll need to make. If any of these exist in your custom template(s), they should be changed as follows:
For custom invoice templates:
| Change this: | To this: |
|---|---|
| $invoice->user->company | $invoice->companyProfile->company |
| $invoice->user->formatted_address | $invoice->companyProfile->formatted_address |
| $invoice->user->phone | $invoice->companyProfile->phone |
| $invoice->user->fax | $invoice->companyProfile->fax |
| $invoice->user->mobile | $invoice->companyProfile->mobile |
| $invoice->user->web | $invoice->companyProfile->web |
| $invoice->user->address | $invoice->companyProfile->address |
| $invoice->user->city | $invoice->companyProfile->city |
| $invoice->user->state | $invoice->companyProfile->state |
| $invoice->user->zip | $invoice->companyProfile->zip |
| $invoice->user->country | $invoice->companyProfile->country |
| Logo::size(width, height) | $invoice->companyProfile->logo(width, height) |
For custom quote templates:
| Change this: | To this: |
|---|---|
| $quote->user->company | $quote->companyProfile->company |
| $quote->user->formatted_address | $quote->companyProfile->formatted_address |
| $quote->user->phone | $quote->companyProfile->phone |
| $quote->user->fax | $quote->companyProfile->fax |
| $quote->user->mobile | $quote->companyProfile->mobile |
| $quote->user->web | $quote->companyProfile->web |
| $quote->user->address | $quote->companyProfile->address |
| $quote->user->city | $quote->companyProfile->city |
| $quote->user->state | $quote->companyProfile->state |
| $quote->user->zip | $quote->companyProfile->zip |
| $quote->user->country | $quote->companyProfile->country |
| Logo::size(width, height) | $quote->companyProfile->logo(width, height) |
Log into your account at FusionInvoice.com and download the add-on package to upgrade. Save it locally to your computer.
Navigate to the downloaded Add-on package and unzip the contents.
Upload the unzipped add-on folder from your computer to the custom/addons folder on your server and let it merge/overwrite the existing folder. It is recommended that you use a standard FTP program such as FileZilla to upload the folder to your server.
Log into your FusionInvoice install and go to System -> Add-ons and press the Upgrade button for the add-on if it appears. If the Upgrade button doesn't appear, then no further action is required and the add-on should be upgraded and ready to use.