• From: USA (Spectrum)
  • Registered: 04/11/2019
  • Posts: 36

Topic: CPanel Installatron skipped versions on upgrade

I installed FA through the 'Installatron' app on Godaddy's CPanel Hosting. I had 'minor' version upgrades checked but it skipped 2.4.5 and 6 but upgraded to 7. I managed to restore my 2.4.4 but am daunted by the process of upgrading myself.

I get the basic idea that I have to update to each minor version in serial order. It's the details that scare me.

1) Could one could do a backup, download the backup, uninstall FA, reinstall the latest version, upload and restore the backup?
    Would one have to do that in version order?

2) I have FTP access to the FA installation folder. Is it as simple as replacing changed files? I found this post but I'm not clear about what to do with the 'changed files.'

3) Are there any CPanel specific instructions?

In the case of 2, would the process be something like
a] back up, download the backup file
b] upload the 'changed files'
c] restore backup
and repeat for each update?

Sorry if this has already been answered but I'm not seeing any instructions that clearly apply to me :[

I've been advised in the future in CPanel to check 'all updates' and have it backup automatically before upgrade. I'm glad I had the latter set before this upgrade, as the restoration was painless. I just see features in the newer releases that might benefit me and want to keep current anyway.

Thanks in advance for any confidence offered.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: CPanel Installatron skipped versions on upgrade

From FA 2.4.4 to 2.4.7:

* FTP the new files
* Put in the missing sys_prefs table records
    print_dialog_direct
    ref_no_auto_increase
* Update the config.php file

- there are no db changes.

Don't forget to update to the latest changes after the release of FA 2.4.7 too.

The install.html and update.html files have been removed.
The files in the "install" folder will need to be deleted.

Post's attachments

FA_2.4.4_to_2.4.7_changed_files.zip 864.3 kb, 1 downloads since 2019-06-30 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • From: USA (Spectrum)
  • Registered: 04/11/2019
  • Posts: 36

Re: CPanel Installatron skipped versions on upgrade

Thank you very much. I don't think I understand your directions, and I don't want to assume anything since I'm new to this.

apmuthu wrote:

* Put in the missing sys_prefs table records
    print_dialog_direct
    ref_no_auto_increase

I found the database that cPanel assigned to FA, and the sys_prefs table. Use PHPMyAdmin to add these? In any particular order?


apmuthu wrote:

* Update the config.php file

I found This Page but I'm unsure what to update.


Sorry for my ignorance but I need just a little more detail.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: CPanel Installatron skipped versions on upgrade

The missing sys_prefs table records can be put in in any order and their sane default values can be found in the sql/en_US-new.sql file.

The config.php file can be compared with the new config.default.php file and the missing entries put into the former.

apmuthu's Website

5 Reply by Technicavolous (edited by Technicavolous 07/03/2019 04:14:17 am)

  • From: USA (Spectrum)
  • Registered: 04/11/2019
  • Posts: 36

Re: CPanel Installatron skipped versions on upgrade

Created an ftp user in cpanel and gave it write permission to the FA directory.
Used Filezilla to upload changed files.

Determined the database name in the settings dialog of cpanel installatron.

From the sql/en_US-new.sql file found
('print_dialog_direct','setup.company', 'tinyint', 1, '0')
('ref_no_auto_increase','setup.company', 'tinyint', 1, '0')

Used phpmyadmin to 'insert' the print_dialog_direct row, ref_no_auto_increase was already there.

copied the following line in
config.default.php
    $xr_providers = array("ECB", "EXCHANGE-RATES.ORG", "GOOGLE", "YAHOO", "BLOOMBERG");

over the following line in
config.php
    $xr_providers = array("ECB", "YAHOO", "GOOGLE", "BLOOMBERG");

used Geany to edit files and uploaded the new file with Filezilla.
Uploaded post updates with filezilla.

Logged in and data appears intact. at the bottom it says 2.4.7. IN setup / software upgrade it shows 2.4.1 and Up To Date (?!)

What else should I see to verify update?

EDIT
Created and downloaded a backup in FA.
Used cpanel installatron to uninstall the upgraded version.
Usined cpanel installatron to do a clean install of 2.4.7
logged into FA and restored the backup, data appears there.

Now to install modules and themes. If modules previously are not reinstalled, can that cause a problem?
.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: CPanel Installatron skipped versions on upgrade

After the $xr_providers array declaration in config.php see that the line below is appropriately assigned like:

$dflt_xr_provider = 0;

You can also upload the post release FA files in the announcement post. Some folders will need write permissions for the webserver user in case you get permission denied errors.

apmuthu's Website