View Issue Details

IDProjectCategoryView StatusLast Update
0007158OXID eShop (all versions)5. ------ UpdateApp / Update ------public2023-01-20 10:01
Reportermf Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version6.2.3 
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

Relationships

related to 0007013 acknowledgedQA Migration from CE to PE works not when demodata were installed. 

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.