<?xml version="1.0" encoding="utf-8"?>
<feed xmlns="http://www.w3.org/2005/Atom">
	<title type="html"><![CDATA[FrontAccounting forum — CPanel Installatron skipped versions on upgrade]]></title>
	<link rel="self" href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=8250&amp;type=atom" />
	<updated>2019-07-03T03:55:30Z</updated>
	<generator>PunBB</generator>
	<id>https://frontaccounting.com/punbb/viewtopic.php?id=8250</id>
		<entry>
			<title type="html"><![CDATA[Re: CPanel Installatron skipped versions on upgrade]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35364#p35364" />
			<content type="html"><![CDATA[<p>After the <strong>$xr_providers</strong> array declaration in <strong>config.php</strong> see that the line below is appropriately assigned like:<br /></p><div class="codebox"><pre><code>$dflt_xr_provider = 0;</code></pre></div><p>You can also upload the post release FA files in the <a href="https://frontaccounting.com/punbb/viewtopic.php?pid=35330#p35330">announcement post</a>. Some folders will need write permissions for the webserver user in case you get <em>permission denied</em> errors.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2019-07-03T03:55:30Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35364#p35364</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: CPanel Installatron skipped versions on upgrade]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35363#p35363" />
			<content type="html"><![CDATA[<p>Created an ftp user in cpanel and gave it write permission to the FA directory.<br />Used Filezilla to upload changed files.</p><p>Determined the database name in the settings dialog of cpanel installatron.</p><p>From the sql/en_US-new.sql file found<br />(&#039;print_dialog_direct&#039;,&#039;setup.company&#039;, &#039;tinyint&#039;, 1, &#039;0&#039;)<br />(&#039;ref_no_auto_increase&#039;,&#039;setup.company&#039;, &#039;tinyint&#039;, 1, &#039;0&#039;)</p><p>Used phpmyadmin to &#039;insert&#039; the print_dialog_direct row, ref_no_auto_increase was already there.</p><p>copied the following line in <br />config.default.php<br />&nbsp; &nbsp; $xr_providers = array(&quot;ECB&quot;, &quot;EXCHANGE-RATES.ORG&quot;, &quot;GOOGLE&quot;, &quot;YAHOO&quot;, &quot;BLOOMBERG&quot;);</p><p>over the following line in<br />config.php<br />&nbsp; &nbsp; $xr_providers = array(&quot;ECB&quot;, &quot;YAHOO&quot;, &quot;GOOGLE&quot;, &quot;BLOOMBERG&quot;);</p><p>used Geany to edit files and uploaded the new file with Filezilla.<br />Uploaded post updates with filezilla.</p><p>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 (?!)</p><p>What else should I see to verify update?</p><p>EDIT<br />Created and downloaded a backup in FA.<br />Used cpanel installatron to uninstall the upgraded version.<br />Usined cpanel installatron to do a clean install of 2.4.7<br />logged into FA and restored the backup, data appears there.</p><p>Now to install modules and themes. If modules previously are not reinstalled, can that cause a problem?<br />.</p>]]></content>
			<author>
				<name><![CDATA[Technicavolous]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=44575</uri>
			</author>
			<updated>2019-07-03T03:47:49Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35363#p35363</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: CPanel Installatron skipped versions on upgrade]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35355#p35355" />
			<content type="html"><![CDATA[<p>The missing <strong>sys_prefs</strong> table records can be put in in any order and their sane default values can be found in the <strong>sql/en_US-new.sql</strong> file.</p><p>The <strong>config.php</strong> file can be compared with the new <strong>config.default.php</strong> file and the missing entries put into the former.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2019-07-02T06:33:15Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35355#p35355</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: CPanel Installatron skipped versions on upgrade]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35353#p35353" />
			<content type="html"><![CDATA[<p>Thank you very much. I don&#039;t think I understand your directions, and I don&#039;t want to assume anything since I&#039;m new to this.</p><div class="quotebox"><cite>apmuthu wrote:</cite><blockquote><p>* Put in the missing sys_prefs table records<br />&nbsp; &nbsp; print_dialog_direct<br />&nbsp; &nbsp; ref_no_auto_increase</p></blockquote></div><p>I found the database that cPanel assigned to FA, and the sys_prefs table. Use PHPMyAdmin to add these? In any particular order?</p><br /><div class="quotebox"><cite>apmuthu wrote:</cite><blockquote><p>* Update the config.php file</p></blockquote></div><p>I found <a href="https://frontaccounting.com/fawiki/index.php?n=Main.Config">This Page</a> but I&#039;m unsure what to update.</p><br /><p>Sorry for my ignorance but I need just a little more detail.</p>]]></content>
			<author>
				<name><![CDATA[Technicavolous]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=44575</uri>
			</author>
			<updated>2019-07-02T03:08:38Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35353#p35353</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[Re: CPanel Installatron skipped versions on upgrade]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35342#p35342" />
			<content type="html"><![CDATA[<p>From FA 2.4.4 to 2.4.7:</p><p>* FTP the new files<br />* Put in the missing sys_prefs table records<br />&nbsp; &nbsp; print_dialog_direct<br />&nbsp; &nbsp; ref_no_auto_increase<br />* Update the <strong>config.php</strong> file</p><p>- there are no db changes.</p><p>Don&#039;t forget to update to the <a href="https://frontaccounting.com/punbb/viewtopic.php?pid=35330#p35330">latest changes</a> after the release of FA 2.4.7 too.</p><p>The install.html and update.html files have been removed.<br />The files in the &quot;install&quot; folder will need to be deleted.</p>]]></content>
			<author>
				<name><![CDATA[apmuthu]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=364</uri>
			</author>
			<updated>2019-06-30T13:44:58Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35342#p35342</id>
		</entry>
		<entry>
			<title type="html"><![CDATA[CPanel Installatron skipped versions on upgrade]]></title>
			<link rel="alternate" href="https://frontaccounting.com/punbb/viewtopic.php?pid=35337#p35337" />
			<content type="html"><![CDATA[<p>I installed FA through the &#039;Installatron&#039; app on Godaddy&#039;s CPanel Hosting. I had &#039;minor&#039; 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.</p><p>I get the basic idea that I have to update to each minor version in serial order. It&#039;s the details that scare me.</p><p>1) Could one could do a backup, download the backup, uninstall FA, reinstall the latest version, upload and restore the backup? <br />&nbsp; &nbsp; Would one have to do that in version order?</p><p>2) I have FTP access to the FA installation folder. Is it as simple as replacing changed files? I found <a href="https://frontaccounting.com/punbb/viewtopic.php?id=7996">this post</a> but I&#039;m not clear about what to do with the &#039;changed files.&#039;</p><p>3) Are there any CPanel specific instructions?</p><p>In the case of 2, would the process be something like<br />a] back up, download the backup file<br />b] upload the &#039;changed files&#039; <br />c] restore backup<br />and repeat for each update?</p><p>Sorry if this has already been answered but I&#039;m not seeing any instructions that clearly apply to me :[</p><p>I&#039;ve been advised in the future in CPanel to check &#039;all updates&#039; and have it backup automatically before upgrade. I&#039;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.</p><p>Thanks in advance for any confidence offered.</p>]]></content>
			<author>
				<name><![CDATA[Technicavolous]]></name>
				<uri>https://frontaccounting.com/punbb/profile.php?id=44575</uri>
			</author>
			<updated>2019-06-29T16:51:05Z</updated>
			<id>https://frontaccounting.com/punbb/viewtopic.php?pid=35337#p35337</id>
		</entry>
</feed>
