1

(27 replies, posted in Installation)

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