View Issue Details

IDProjectCategoryView StatusLast Update
0007013OXID eShop (all versions)4.01. Database handlingpublic2019-07-23 15:46
Reportermichael_keiluweit 
PrioritynormalSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version 
Target Version6.1.4Fixed in Version 
Summary0007013: Migration from CE to PE works not when demodata were installed.
DescriptionSome database fields are missing when installing a CE shop with demo data. Those information are later needed to upgrade and run a PE edition. After doing the migration, the shop throws an exception (see additional information) and is not callable anymore, until the missing fields are added manually.

Steps To Reproduce1. Install CE with demo data
2.
composer config repositories.oxid-esales composer https://professional-edition.packages.oxid-esales.com
composer require oxid-esales/oxideshop-metapackage-pe
3.
vendor/bin/oe-eshop-db_migrate migrations:migrate
vendor/bin/oe-eshop-db_views_generate
4. call the shop
Additional InformationThe reason is located in \OxidEsales\EshopCommunity\Setup\Controller::installShopData.
There is a logic to determine if the demodata should be installed. If yes: execute demodata.sql. if no: execute initial_data.sql.



[2019-07-23 14:27:25] OXID Logger.ERROR: Unknown column 'oxv_oxshops_de.oxserial' in 'field list' ["[object] (OxidEsales\\Eshop\\Core\\Exception\\DatabaseErrorException(code: 1054): Unknown column 'oxv_oxshops_de.oxserial' in 'field list' at /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php:938, Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'select `oxv_oxshops_de`.`oxid`, `oxv_oxshops_de`.`oxactive`, `oxv_oxshops_de`.`oxproductive`, `oxv_oxshops_de`.`oxdefcurrency`, `oxv_oxshops_de`.`oxdeflanguage`, `oxv_oxshops_de`.`oxname`, `oxv_oxshops_de`.`oxtitleprefix`, `oxv_oxshops_de`.`oxtitlesuffix`, `oxv_oxshops_de`.`oxstarttitle`, `oxv_oxshops_de`.`oxinfoemail`, `oxv_oxshops_de`.`oxorderemail`, `oxv_oxshops_de`.`oxowneremail`, `oxv_oxshops_de`.`oxordersubject`, `oxv_oxshops_de`.`oxregistersubject`, `oxv_oxshops_de`.`oxforgotpwdsubject`, `oxv_oxshops_de`.`oxsendednowsubject`, `oxv_oxshops_de`.`oxsmtp`, `oxv_oxshops_de`.`oxsmtpuser`, `oxv_oxshops_de`.`oxsmtppwd`, `oxv_oxshops_de`.`oxcompany`, `oxv_oxshops_de`.`oxstreet`, `oxv_oxshops_de`.`oxzip`, `oxv_oxshops_de`.`oxcity`, `oxv_oxshops_de`.`oxcountry`, `oxv_oxshops_de`.`oxbankname`, `oxv_oxshops_de`.`oxbanknumber`, `oxv_oxshops_de`.`oxbankcode`, `oxv_oxshops_de`.`oxvatnumber`, `oxv_oxshops_de`.`oxtaxnumber`, `oxv_oxshops_de`.`oxbiccode`, `oxv_oxshops_de`.`oxibannumber`, `oxv_oxshops_de`.`oxfname`, `oxv_oxshops_de`.`oxlname`, `oxv_oxshops_de`.`oxtelefon`, `oxv_oxshops_de`.`oxtelefax`, `oxv_oxshops_de`.`oxurl`, `oxv_oxshops_de`.`oxdefcat`, `oxv_oxshops_de`.`oxhrbnr`, `oxv_oxshops_de`.`oxcourt`, `oxv_oxshops_de`.`oxadbutlerid`, `oxv_oxshops_de`.`oxaffilinetid`, `oxv_oxshops_de`.`oxsuperclicksid`, `oxv_oxshops_de`.`oxaffiliweltid`, `oxv_oxshops_de`.`oxaffili24id`, `oxv_oxshops_de`.`oxedition`, `oxv_oxshops_de`.`oxversion`, `oxv_oxshops_de`.`oxseoactive`, `oxv_oxshops_de`.`oxtimestamp`, `oxv_oxshops_de`.`oxserial` from oxv_oxshops_de where 1  and oxv_oxshops_de.oxid = '1'':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'oxv_oxshops_de.oxserial' in 'field list' at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'oxv_oxshops_de.oxserial' in 'field list' at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'oxv_oxshops_de.oxserial' in 'field list' at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)\n[stacktrace]\n#0 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(621): OxidEsales\\EshopCommunity\\Core\\Database\\Adapter\\Doctrine\\Database->convertException(Object(Doctrine\\DBAL\\Exception\\InvalidFieldNameException))\n#1 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/Model/BaseModel.php(736): OxidEsales\\EshopCommunity\\Core\\Database\\Adapter\\Doctrine\\Database->select('select `oxv_oxs...')\n#2 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/Model/BaseModel.php(717): OxidEsales\\EshopCommunity\\Core\\Model\\BaseModel->getRecordByQuery('select `oxv_oxs...')\n#3 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/Model/BaseModel.php(669): OxidEsales\\EshopCommunity\\Core\\Model\\BaseModel->assignRecord('select `oxv_oxs...')\n#4 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Application/Controller/Admin/LoginController.php(82): OxidEsales\\EshopCommunity\\Core\\Model\\BaseModel->load(1)\n#5 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Application/Controller/Admin/LoginController.php(50): OxidEsales\\EshopCommunity\\Application\\Controller\\Admin\\LoginController->setShopConfigParameters()\n#6 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(453): OxidEsales\\EshopCommunity\\Application\\Controller\\Admin\\LoginController->render()\n#7 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(344): OxidEsales\\EshopCommunity\\Core\\ShopControl->_render(Object(OxidEsales\\Eshop\\Application\\Controller\\Admin\\LoginController))\n#8 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(276): OxidEsales\\EshopCommunity\\Core\\ShopControl->formOutput(Object(OxidEsales\\Eshop\\Application\\Controller\\Admin\\LoginController))\n#9 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(137): OxidEsales\\EshopCommunity\\Core\\ShopControl->_process('OxidEsales\\\\Esho...', NULL, NULL, NULL)\n#10 /var/www/html/vendor/oxid-esales/oxideshop-ce/source/Core/Oxid.php(26): OxidEsales\\EshopCommunity\\Core\\ShopControl->start()\n#11 /var/www/html/source/index.php(15): OxidEsales\\EshopCommunity\\Core\\Oxid::run()\n#12 /var/www/html/source/admin/index.php(11): require_once('/var/www/html/s...')\n#13 {main}\n"] []
Tagsmigration
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
MySQL VersionNot defined

Activities

There are no notes attached to this issue.