Inhalte aufrufen

Profilbild

Installation error: Invalid column name 'AdminComment'

5.0.2 docker installation

  • Bitte melden Sie sich an, um eine Antwort zu verfassen.
1 Antwort zu diesem Thema

#1 profnimrod

profnimrod

    Advanced Member

  • Members
  • PunktPunktPunkt
  • 39 Beiträge

Geschrieben: 02 March 2023 - 00:19

I have a new store up and running based on the following image:

 

ghcr.io/smartstore/smartstore-linux:latest

 

I can access the install page OK.

 

We have an existing SQL database running in Azure that is behind our current 4.2.0.0 store.  I have made a copy of the existing database to be used with the new version of SmartStore we have running in our kubernetes environment.

 

When I try to install the new store using this copy of the of existing database I get the following error:

 

  • Setup failed: An error occurred during installation. Stage: PopulatePictures (Invalid column name 'AdminComment'.)

 

Does there need to be DB changes to be compatible with the latest version of SmartStore when using a DB used for 4.2.0.0?

 



#2 Marcus Gesing

Marcus Gesing

    SmartStore AG

  • Administrators
  • 3831 Beiträge

Geschrieben: 02 March 2023 - 20:26

This is done automatically via migrations that are executed by code at the first application start. An installation is not necessary if a Smartstore database already exists. How to update from 4.2 to 5 is documented here.
 
The error message probably refers to the MediaFile.AdminComment field that was added after 4.2, i.e. the required migration did not run.

Marcus Gesing

Smartstore AG



Auch markiert mit einem oder mehrerer dieser Schlüsselwörter: 5.0.2, docker, installation