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

ID	Project	Category	View Status	Date Submitted	Last Update

0007013	OXID eShop (all versions)	4.01. Database handling	public	2019-07-23 15:45	2023-07-07 10:31

Reporter	michael_keiluweit	Assigned To
Priority	normal	Severity	minor	Reproducibility	always
Status	acknowledged	Resolution	open
Target Version	6.1.4

Summary	0007013: Migration from CE to PE works not when demodata were installed.
Description	Some 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 Reproduce	1. 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 Information	The 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"] []
Tags	migration

Theme	Not defined
Browser	Not defined
PHP Version	Not defined
Database Version	Not defined

View Issue Details

Relationships

Activities