View Issue Details

IDProjectCategoryView StatusLast Update
0007158OXID eShop (all versions)5. ------ UpdateApp / Update ------public2020-12-16 15:29
Reportermikkelfilla 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version6.2.3 
Target VersionFixed in Version 
Summary0007158: Error on upgrade/migrate from CE to PE/EE
DescriptionWhen doing a `composer require oxid-esales/oxideshop-metapackage-pe`the process is stopped with the message:

  [OxidEsales\Eshop\Core\Exception\DatabaseErrorException]
  Unknown column 'oxserial' in 'field list'
                                                            
  [Doctrine\DBAL\Exception\InvalidFieldNameException]
  An exception occurred while executing 'select oxserial from oxshops where oxid = ?' with params [1]:
                                                                                                        
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'oxserial' in 'field list'
                                                                                                        
  [Doctrine\DBAL\Driver\PDOException]
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'oxserial' in 'field list'
                                                                                     
  [PDOException]
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'oxserial' in 'field list'
Steps To Reproducecomposer config repositories.oxid-esales composer https://professional-edition.packages.oxid-esales.com
composer require oxid-esales/oxideshop-metapackage-pe
Additional InformationAs a workaround its possible to do the normal setup and ignore the composer require error:
composer config repositories.oxid-esales composer https://professional-edition.packages.oxid-esales.com
composer require oxid-esales/oxideshop-metapackage-pe
vendor/bin/oe-eshop-db_migrate migrations:migrate
vendor/bin/oe-eshop-db_views_generate

And do the require again:
composer require oxid-esales/oxideshop-metapackage-pe
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionNot defined

Activities

farzam.tahmasebmirza

2020-12-16 15:25

reporter   ~0013370

For upgrading b-6.2.x CE to PE and from b-6.2.x PE to EE documentation is provided in the following link:

https://docs.oxid-esales.com/developer/en/6.2/update/upgrade-from-6.2.x-CE-to-6.2.x-PE.html
https://docs.oxid-esales.com/developer/en/6.2/update/upgrade-from-6.2.x-PE-to-6.2.x-EE.html

Important notice: You can not directly upgrade from CE edition to EE edition. you must first upgrade from CE to PE then from PE to EE based on above documentations.