# Upgrade procedure for SpiceCRM

**URL:** <https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514>\
**Category:** Installation\
**Created:** [March 6, 2020, 5:11am UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514 "2020-03-06T05:11:46Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![tornmarketing](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.spicecrm.io/tornmarketing/32/195_2.png) [@tornmarketing](https://community.spicecrm.io/u/tornmarketing)\
**Post date:** [March 6, 2020, 5:11am UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/1 "2020-03-06T05:11:46Z")

</div>

Hey team,

What is the upgrade procedure for upgrading both the backend and frontend of SpiceCRM

Dwayne

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [March 14, 2020, 11:55am UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/2 "2020-03-14T11:55:16Z")

</div>

Dwayne,

for now an update may done like this

- wait until latest release was officially announced
- backup files system and database
- pull master branch from spicecrm backend repository
- login to backend as and admin and perform repair/rebuild
- pull master branch from spicecrm frontend repository
- login to frontend as an admin, go to workbench and reload all packages you retrieved in your installation (identifyable by trash can icon next to download incon), start with core package.  
CAUTION with FTS package: if you customized FTS configuration, make a backup of your sysfts table before reloading the package or just do not reload fts package.

Development of a Deployment Solution is planed by the end of 2020.

Val

---

<div class="post-metadata">

**Author:** ![tornmarketing](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.spicecrm.io/tornmarketing/32/195_2.png) [@tornmarketing](https://community.spicecrm.io/u/tornmarketing)\
**Post date:** [March 28, 2020, 1:10am UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/3 "2020-03-28T01:10:40Z")

</div>

> [@maretval](#):
>
> - pull master branch from spicecrm backend repository
> - login to backend as and admin and perform repair/rebuild

I feel I am missing a step here, does the repair/rebuild update any dependencies on the BE? and if so, why would you pull from GIT

---

<div class="post-metadata">

**Author:** ![sscheuring](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.spicecrm.io/sscheuring/32/336_2.png) [@sscheuring](https://community.spicecrm.io/u/sscheuring)\
**Post date:** [May 19, 2020, 10:37pm UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/4 "2020-05-19T22:37:53Z")

</div>

Hi!  
I followed these steps to upgrade my existing installation to 2020.01.002. After pulling frontend via git, i cannot open the admin in FE to reload all packages. Error is: Component **AdministrationHomeScreen** Missing

How can i enable th Admin HomeScreen, without loosing my configuration?

Sebastian

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [May 20, 2020, 5:50am UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/5 "2020-05-20T05:50:42Z")

</div>

Sebastian,

please, run following SQLs into your database

```auto
REPLACE INTO `sysuiobjectrepository` (`id`, `object`, `module`, `path`, `component`, `description`, `componentconfig`, `version`, `package`, `deprecated`) VALUES ('398b8702-ce66-9d5b-bec6-5b65d9385177', 'AdministrationHomeScreen', '4b6fa2bc-2c3f-4b06-a5b4-76debf965af3', NULL, 'AdministrationHomeScreen', 'Home screen for the admin panel', NULL, '2019.12.001', 'core', 0);

    REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('1048f8d8-21a8-11ea-b9e3-54e1ad2083e4', 'Calendar', 'LBL_CALENDAR', 6, '2019.12.001', 'googlecalendar');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('104ccbaa-21a8-11ea-b9e3-54e1ad2083e4', 'Scheduler', 'LBL_SCHEDULER', 2, '2019.12.001', 'core');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('104ef092-21a8-11ea-b9e3-54e1ad2083e4', 'ACL', 'LBL_ACL', 7, '2019.12.001', 'aclmanager');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('10531e08-21a8-11ea-b9e3-54e1ad2083e4', 'Full Text Search', 'LBL_FTS', 8, '2019.12.001', 'core');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('1057db6f-21a8-11ea-b9e3-54e1ad2083e4', 'Workflow', 'LBL_WORKFLOW', 9, '2019.12.001', 'workflow');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('105a24ab-21a8-11ea-b9e3-54e1ad2083e4', 'Language', 'LBL_LANGUAGE', 3, '2019.12.001', 'core');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('105fb625-21a8-11ea-b9e3-54e1ad2083e4', 'Number Ranges', 'LBL_NUMBER_RANGERS', 5, '2019.12.001', 'core');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('10669a8e-21a8-11ea-b9e3-54e1ad2083e4', 'Dictionary', 'LBL_DICTIONARY', 10, '2019.12.001', 'core');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('106f50b8-21a8-11ea-b9e3-54e1ad2083e4', 'E-Marketing', 'LBL_EMARKETING', 11, '2019.12.001', 'campaignmanagement');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('107447e6-21a8-11ea-b9e3-54e1ad2083e4', 'Quota Management', 'LBL_QUOTA_MANAGEMENT', 12, '2019.12.001', 'core');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('352826ad-86a7-413f-be4f-8216560ac4f9', 'HTML Styling', 'LBL_STYLING', 13, '2019.12.001', 'core');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('8B74AF89-A274-4CA2-BFF2-8B3700F8416A', 'Servicemanagement', 'LBL_SERVICEMANAGEMENT', 14, '2020.01.001', 'servicemanagement');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('928F9B18-B928-4256-AFA7-25521CFC2CD1', 'Report', 'LBL_KREPORT', 15, '2020.01.001', 'reporting');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('db04c650-a529-4b32-9a3d-ecc02ca7ee67', 'System', 'LBL_SYSTEM', 1, '2019.12.001', 'core');
REPLACE INTO `sysuiadmingroups` (`id`, `name`, `label`, `sequence`, `version`, `package`) VALUES ('dd595b61-21a7-11ea-b9e3-54e1ad2083e4', 'Workbench', 'LBL_WORKBENCH', 4, '2019.12.001', 'core');
```

---

<div class="post-metadata">

**Author:** ![sscheuring](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.spicecrm.io/sscheuring/32/336_2.png) [@sscheuring](https://community.spicecrm.io/u/sscheuring)\
**Post date:** [May 20, 2020, 2:42pm UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/6 "2020-05-20T14:42:12Z")

</div>

Hi!

Thx… the error message is gone, but the screen keeps blank. When i open objects (contacts, accounts), the screen keeps blank. I see only the header, no data.

Sebastian

 ![Bildschirmfoto 2020-05-20 um 16.41.38](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/a77885b42eb88ee7788dcabeee83758705666ec0.png)

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [May 21, 2020, 8:22am UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/7 "2020-05-21T08:22:37Z")

</div>

Could you reload packages using package loader?

---

<div class="post-metadata">

**Author:** ![sscheuring](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.spicecrm.io/sscheuring/32/336_2.png) [@sscheuring](https://community.spicecrm.io/u/sscheuring)\
**Post date:** [May 21, 2020, 8:45am UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/8 "2020-05-21T08:45:58Z")

</div>

In Admin the Screen is Blank, as shown. So I cannot reload packages 😳!

Sebastian

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [May 21, 2020, 9:37am UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/9 "2020-05-21T09:37:09Z")

</div>

Did you try logging in to Backend and load core package?  
Administration \> Load UI Config

---

<div class="post-metadata">

**Author:** ![sscheuring](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.spicecrm.io/sscheuring/32/336_2.png) [@sscheuring](https://community.spicecrm.io/u/sscheuring)\
**Post date:** [May 21, 2020, 11:50am UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/10 "2020-05-21T11:50:31Z")

</div>

In my first try to update, yes… After that all UI Customisations were gone (Additional fields were missing in UI…).  
After your replace into sql’s I get now:

> Table structure for sysuiroutes is not up-to-date.  
> Reference table = id, path, component, loginrequired, redirectto, pathmatch, version, package, target, aclaction, referencepath, subtabs  
> Client table = id, path, component, redirectto, pathmatch, loginrequired, version, package  
> Action aborted

Sebastian

---

<div class="post-metadata">

**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\
**Post date:** [May 21, 2020, 2:42pm UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/11 "2020-05-21T14:42:34Z")

</div>

Did you run repair/ rebuild in backend?

---

<div class="post-metadata">

**Author:** ![sscheuring](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.spicecrm.io/sscheuring/32/336_2.png) [@sscheuring](https://community.spicecrm.io/u/sscheuring)\
**Post date:** [May 21, 2020, 3:10pm UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/12 "2020-05-21T15:10:19Z")

</div>

I made a rebuild/repair after upgrade from git. Now again and I’m now able to reload all the packages. But again, all customizations (we added some fields in accounts and contacts) are gone. In Backend still available, but in UI (Frontend) gone.  
Additional:  
Google Maps Package could not be installed (nothing happens)  
Error Message in Header of Package Loader: nicht zuordenbare Pakete: salesdocs

How can the “Tabbed” thing enabled?

Regards,  
Sebastian

---

<div class="post-metadata">

**Author:** ![sscheuring](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.spicecrm.io/sscheuring/32/336_2.png) [@sscheuring](https://community.spicecrm.io/u/sscheuring)\
**Post date:** [May 25, 2020, 6:13pm UTC](https://community.spicecrm.io/t/upgrade-procedure-for-spicecrm/514/13 "2020-05-25T18:13:36Z")

</div>

Hi…  
ok, the Tabbed thing is answered with the new blog post: [https://www.spicecrm.io/the-3-new-navigation-modes-in-spicecrm/](https://www.spicecrm.io/the-3-new-navigation-modes-in-spicecrm/) ;). Thx for the post!

Sebastian
