Topic: Upgrading

Having problems upgrading from FA2.3.24 to 2.4.4 Would appreciate some guidance ion ho to do it. Or I'll be happy to pay anyone that can do it.

Re: Upgrading

Steps to Upgrade it

1. Backup the database from your current version FA 2.3.24 .
2. Install a new fresh FA 2.3.26 on separate directory.
3. Restore the database which you backed up on FA2.3.24 and login as admin in FA 2.3.26
4. Again here Backup database  from 2.3.26 and save it on your pc
5. Download Fresh New FA copy, 2.4.4 and install it fresh.
6. Now you need to Restore the backup you exported from FA2.3.26
7. Now when you login as administrator, FA will ask you to update your database. 
8. Now go to Software Upgrade.  You can see Update option, Just click and update the Database. 

Once these steps done successfully, everything will be alright with new version.

Re: Upgrading

hey,

i am trying to update FA 2.4.4 to 2.4.5,

i am using custom theme and let me know can we update files SIDE by SIDE code or another way to do this instead of replacing files?

Regards

Re: Upgrading

Custom Theme should not generally be affected when uploading the version change files.

Re: Upgrading

kvvaradha wrote:

Steps to Upgrade it

1. Backup the database from your current version FA 2.3.24 .
2. Install a new fresh FA 2.3.26 on separate directory.
3. Restore the database which you backed up on FA2.3.24 and login as admin in FA 2.3.26
4. Again here Backup database  from 2.3.26 and save it on your pc
5. Download Fresh New FA copy, 2.4.4 and install it fresh.
6. Now you need to Restore the backup you exported from FA2.3.26
7. Now when you login as administrator, FA will ask you to update your database. 
8. Now go to Software Upgrade.  You can see Update option, Just click and update the Database. 

Once these steps done successfully, everything will be alright with new version.

I have seen these steps mentioned in a few posts.

Why do you say to upgrade to Ver 2.3.26 (last version of FA2.3) before moving to FA2.4.x?
Does this last version save things differently or the upgrade?

I ask because In Theory any FA2.3 version should have the same DB structure

Tom

Re: Upgrading

I wrote the things. But I forget the reason. But there is some program helps to move from here. Its good to upgrade the database with 2.3 to 2.4

Re: Upgrading

I was able to import it ok from 2.3.16 to 2.4.6 using the steps you provided (skipping the fresh install of 2.3.26)

Well so far it looks good smile

Tom

Re: Upgrading

Than its great to hear

Re: Upgrading

Verify with the stock sql/en_US-new.sql for any schema changes and unused tables and field orders.

Re: Upgrading

I do see some differences... (table entry order, defaults, etc)

So I guess that the large jump I made caused some of the sql/alter.[sql|php] scripts to not run correctly

Has that been fixed in fa2.4.x?

I will load my db into fa2.3.26 and then to 2.4.6 and see if the db is better...

Tom

Re: Upgrading

@ tom - I guess if you do the missiby step.  It will fix the db issue.

Re: Upgrading

kvvaradha wrote:

Steps to Upgrade it

3. Restore the database which you backed up on FA2.3.24 and login as admin in FA 2.3.26
4. Again here Backup database  from 2.3.26 and save it on your pc

6. Now you need to Restore the backup you exported from FA2.3.26
7. Now when you login as administrator, FA will ask you to update your database.

In steps 3 and 6 does "Restore" mean using phpadmin IMPORT or mysql command or import through FA Setup-Backup/Restore?

I ask because is using FA we'd already be logged in as admin...

The devil is in the details

Tom

Re: Upgrading

kvvaradha wrote:

@ tom - I guess if you do the missiby step.  It will fix the db issue.

I hope that FA2.4 correctly updates the DB...

Tom

Re: Upgrading

Not phpmyadmin
it's all through  FA.

Re: Upgrading

After a detailed look at my database I have found that he difference between my tables (2.3.16) and 2.3.26 are that 3 fields are out of order.
Seems they were added to the end not in the middle.

There are also many defaults that are different.

I am wondering if I could export my DATA only and import into the 2.3.26 tables (truncating the tables before inserting)

It seems that could work, unless I am missing anything obvious

Thoughts?
(Yes everything is backed up so total failure is not a real problem)

Re: Upgrading

@tom - I forget the reason for it. But all these steps will help you to update database.if yoy have backup. Then go with test instance and try them.

Re: Upgrading

Is this statement correct?

7. Now when you login as administrator, FA will ask you to update your database. 

I loaded the demo data from 2.3.26 into my 2.4.6 install and FA does not ask me to update my DB.

I can go do the update, but it never asks me.
What triggers this question from the code?

Is there something missing from mt DB?

Tom

Re: Upgrading

You may be in the main menu section. Try to open sub module pages like direct invoice. It will prompt the message. Or you can directly goto setup-> software updates. There you can see update option available

Re: Upgrading

When I was comparing my database to the FA2.4 I found a number of fields had different default values and such, so I felt it might be better if I make my DB conform to the exact same structures of demo data.

So here is what I ended up doing:
1. Exported my data with phpMyAdmin keeping Just the Data and truncating the tables (as opposed to dropping them)
2. I created a fresh DB and imported the 2.3.26 demo data with phpMyAdmin (my system was FA2.3.16)
3. I imported my Data Only with phpMyAdmin
4. I then logged into an admin account of my DB and did a Software Update

All appears to be well.

The same steps could work for an FA2.4 db clean up as well

Tom

Re: Upgrading

I have a problem to update the database after migrating and upgrading from FA2.3.26 (on a webhost) to FA2.4.6  (on Xampp).
first I can't upload my back-up file so I copied it into the company/backup folder
The theme is set to default, the company name is same and the Table Pref is the same in the two versions.
When I log as administrator in the company "0" and do a software upgrade, the process fails. The "current version" number is changed to "2.3rc". The "last log" shows:

Upgrade log for company '4'
[14-Apr-2019 10:39:45 Europe/Berlin] [Info] Upgrade started for company 4.
[14-Apr-2019 10:39:52 Europe/Berlin] [Info] Security backup in file ../company/4/backup/erdai149_fron989_4_20190414_1039.sql done.
[14-Apr-2019 10:41:07 Europe/Berlin] [Error] 30:Duplicate column name 'tax_shipping'
[14-Apr-2019 10:41:07 Europe/Berlin] [Error] 36:Duplicate key name 'stkcode'
......
[14-Apr-2019 10:41:07 Europe/Berlin] [Error] 97:Duplicate entry 'print_item_images_on_quote' for key 'PRIMARY'
[14-Apr-2019 10:41:07 Europe/Berlin] [Error] 98:Duplicate entry 'default_receival_required' for key 'PRIMARY'
[14-Apr-2019 10:43:02 Europe/Berlin] [Info] Upgrade failed. Original database content restored successfully.
[14-Apr-2019 10:43:04 Europe/Berlin] [Info] Upgrade for company 4 finished.

Help would be very much appreciated.
Thanks
Iffig