Shop Problem nach Update

milanffm · September 9, 2020, 8:49am

Hallo,
ich habe einen Shop von 6.0 Beta 3 erst auf 6.1 und dann auf 6.2 aktualisiert.

composer lief auch durch ohne Fehler.

Im Backend sehe ich allerdings keine Artikel, auch die Versandkostenregeln, etc. werden nicht angzeigt.

Folgender Fehlercode:

[2020-09-09 10:40:44]

OXID Logger.ERROR: not set ["[object] (OxidEsales\Eshop\Core\Exception\ObjectException(code: 0): not set at
/vendor/oxid-esales/oxideshop-ce/source/Core/UtilsObject.php:232)\n[stacktrace]

\n#0 source/oxfunctions.php(104): OxidEsales\EshopCommunity\Core\UtilsObject->oxNew(‘OxidEsales\\Esho…’)

\n#1 /vendor/oxid-esales/oxideshop-ce/source/Application/Model/VatSelector.php(62): oxNew(‘OxidEsales\\Esho…’)

\n#2 /vendor/oxid-esales/oxideshop-ce/source/Application/Model/VatSelector.php(192): OxidEsales\EshopCommunity\Application\Model\VatSelector->getUserVat(Object(OxidEsales\PayPalModule\Model\User))

\n#3 /vendor/oxid-esales/oxideshop-ce/source/Application/Model/Article.php(4074): OxidEsales\EshopCommunity\Application\Model\VatSelector->getArticleUserVat(Object(OxidEsales\PayPalModule\Model\Article))

\n#4 /vendor/oxid-esales/oxideshop-ce/source/Application/Model/Article.php(3726): OxidEsales\EshopCommunity\Application\Model\Article->_applyVAT(Object(OxidEsales\Eshop\Core\Price), ‘19’)

\n#5 /vendor/oxid-esales/oxideshop-ce/source/Application/Model/Article.php(2107): OxidEsales\EshopCommunity\Application\Model\Article->_calculatePrice(Object(OxidEsales\Eshop\Core\Price))

\n#6 source/tmp/smarty/21b1130f4dc6b11ff008d8c383deb598^%%27^273^27320283%%article_main.tpl.php(319): OxidEsales\EshopCommunity\Application\Model\Article->getPrice()

\n#7 /vendor/smarty/smarty/libs/Smarty.class.php(1270): include(’/var/www/virtua…’)

\n#8 /vendor/oxid-esales/oxideshop-ce/source/Internal/Framework/Smarty/Legacy/LegacySmartyEngine.php(66): Smarty->fetch(‘article_main.tp…’, ‘tbclarticle_mai…’)

\n#9 /vendor/oxid-esales/oxideshop-ce/source/Internal/Framework/Templating/TemplateRenderer.php(35): OxidEsales\EshopCommunity\Internal\Framework\Smarty\Legacy\LegacySmartyEngine->render(‘article_main.tp…’, Array)

\n#10 /vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(509): OxidEsales\EshopCommunity\Internal\Framework\Templating\TemplateRenderer->renderTemplate(‘article_main.tp…’, Array)

\n#11 /vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(359): OxidEsales\EshopCommunity\Core\ShopControl->_render(Object(OxidEsales\Eshop\Application\Controller\Admin\ArticleMain))

\n#12 /vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(282): OxidEsales\EshopCommunity\Core\ShopControl->formOutput(Object(OxidEsales\Eshop\Application\Controller\Admin\ArticleMain))

\n#13 /vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(142): OxidEsales\EshopCommunity\Core\ShopControl->_process(‘OxidEsales\\Esho…’, NULL, NULL, NULL)

\n#14 /vendor/oxid-esales/oxideshop-ce/source/Core/Oxid.php(27): OxidEsales\EshopCommunity\Core\ShopControl->start()

\n#15 source/index.php(16): OxidEsales\EshopCommunity\Core\Oxid::run()

\n#16 source/admin/index.php(12): require_once(’/var/www/virtua…’)\n#17 {main}\n"] []

Irgendwelche Ideen??
danke

OXID-Design · September 9, 2020, 9:22am

views aktualisiert?

milanffm · September 9, 2020, 9:35am

dann kommt nur “Fehler beim Aktualisieren der Datenbank-Views.”

milanffm · September 9, 2020, 9:40am

[2020-09-09 11:37:46] OXID Logger.ERROR: ‘pamina19_samuel.oxv_oxarticles’ is not of type ‘VIEW’ ["[object] (OxidEsales\Eshop\Core\Exception\DatabaseErrorException(code: 1347): ‘pamina19_samuel.oxv_oxarticles’ is not of type ‘VIEW’ at /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php:925, Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘CREATE OR REPLACE SQL SECURITY INVOKER VIEW oxv_oxarticles AS SELECT oxarticles.OXID,oxarticles.OXSHOPID,oxarticles.OXPARENTID,oxarticles.OXACTIVE,oxarticles.OXHIDDEN,oxarticles.OXACTIVEFROM,oxarticles.OXACTIVETO,oxarticles.OXARTNUM,oxarticles.OXEAN,oxarticles.OXDISTEAN,oxarticles.OXMPN,oxarticles.OXTITLE,oxarticles.OXSHORTDESC,oxarticles.OXPRICE,oxarticles.OXBLFIXEDPRICE,oxarticles.OXPRICEA,oxarticles.OXPRICEB,oxarticles.OXPRICEC,oxarticles.OXBPRICE,oxarticles.OXTPRICE,oxarticles.OXUNITNAME,oxarticles.OXUNITQUANTITY,oxarticles.OXEXTURL,oxarticles.OXURLDESC,oxarticles.OXURLIMG,oxarticles.OXVAT,oxarticles.OXTHUMB,oxarticles.OXICON,oxarticles.OXPIC1,oxarticles.OXPIC2,oxarticles.OXPIC3,oxarticles.OXPIC4,oxarticles.OXPIC5,oxarticles.OXPIC6,oxarticles.OXPIC7,oxarticles.OXPIC8,oxarticles.OXPIC9,oxarticles.OXPIC10,oxarticles.OXPIC11,oxarticles.OXPIC12,oxarticles.OXWEIGHT,oxarticles.OXSTOCK,oxarticles.OXSTOCKFLAG,oxarticles.OXSTOCKTEXT,oxarticles.OXNOSTOCKTEXT,oxarticles.OXDELIVERY,oxarticles.OXINSERT,oxarticles.OXTIMESTAMP,oxarticles.OXLENGTH,oxarticles.OXWIDTH,oxarticles.OXHEIGHT,oxarticles.OXFILE,oxarticles.OXSEARCHKEYS,oxarticles.OXTEMPLATE,oxarticles.OXQUESTIONEMAIL,oxarticles.OXISSEARCH,oxarticles.OXISCONFIGURABLE,oxarticles.OXVARNAME,oxarticles.OXVARSTOCK,oxarticles.OXVARCOUNT,oxarticles.OXVARSELECT,oxarticles.OXVARMINPRICE,oxarticles.OXVARMAXPRICE,oxarticles.OXVARNAME_1,oxarticles.OXVARSELECT_1,oxarticles.OXVARNAME_2,oxarticles.OXVARSELECT_2,oxarticles.OXVARNAME_3,oxarticles.OXVARSELECT_3,oxarticles.OXTITLE_1,oxarticles.OXSHORTDESC_1,oxarticles.OXURLDESC_1,oxarticles.OXSEARCHKEYS_1,oxarticles.OXTITLE_2,oxarticles.OXSHORTDESC_2,oxarticles.OXURLDESC_2,oxarticles.OXSEARCHKEYS_2,oxarticles.OXTITLE_3,oxarticles.OXSHORTDESC_3,oxarticles.OXURLDESC_3,oxarticles.OXSEARCHKEYS_3,oxarticles.OXBUNDLEID,oxarticles.OXFOLDER,oxarticles.OXSUBCLASS,oxarticles.OXSTOCKTEXT_1,oxarticles.OXSTOCKTEXT_2,oxarticles.OXSTOCKTEXT_3,oxarticles.OXNOSTOCKTEXT_1,oxarticles.OXNOSTOCKTEXT_2,oxarticles.OXNOSTOCKTEXT_3,oxarticles.OXSORT,oxarticles.OXSOLDAMOUNT,oxarticles.OXNONMATERIAL,oxarticles.OXFREESHIPPING,oxarticles.OXREMINDACTIVE,oxarticles.OXREMINDAMOUNT,oxarticles.OXAMITEMID,oxarticles.OXAMTASKID,oxarticles.OXVENDORID,oxarticles.OXMANUFACTURERID,oxarticles.OXSKIPDISCOUNTS,oxarticles.OXRATING,oxarticles.OXRATINGCNT,oxarticles.OXMINDELTIME,oxarticles.OXMAXDELTIME,oxarticles.OXDELTIMEUNIT,oxarticles.OXUPDATEPRICE,oxarticles.OXUPDATEPRICEA,oxarticles.OXUPDATEPRICEB,oxarticles.OXUPDATEPRICEC,oxarticles.OXUPDATEPRICETIME,oxarticles.OXISDOWNLOADABLE,oxarticles.OXSHOWCUSTOMAGREEMENT FROM oxarticles ‘:\n\nSQLSTATE[HY000]: General error: 1347 ‘pamina19_samuel.oxv_oxarticles’ is not of type ‘VIEW’ at /var/www/virtual/pamina19/shopsamuelsstuff/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 1347 ‘pamina19_samuel.oxv_oxarticles’ is not of type ‘VIEW’ at /var/www/virtual/pamina19/shopsamuelsstuff/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1347 ‘pamina19_samuel.oxv_oxarticles’ is not of type ‘VIEW’ at /var/www/virtual/pamina19/shopsamuelsstuff/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:41)\n[stacktrace]\n#0 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(767): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->convertException(Object(Doctrine\DBAL\Exception\DriverException))\n#1 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(564): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->executeUpdate(‘CREATE OR REPLA…’, Array)\n#2 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Application/Model/Shop.php(368): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->execute(‘CREATE OR REPLA…’)\n#3 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Application/Model/Shop.php(142): OxidEsales\EshopCommunity\Application\Model\Shop->_runQueries()\n#4 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/DbMetaDataHandler.php(571): OxidEsales\EshopCommunity\Application\Model\Shop->generateViews(false, Array)\n#5 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Application/Controller/Admin/ToolsList.php(37): OxidEsales\EshopCommunity\Core\DbMetaDataHandler->updateViews()\n#6 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/Controller/BaseController.php(534): OxidEsales\EshopCommunity\Application\Controller\Admin\ToolsList->updateViews()\n#7 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(347): OxidEsales\EshopCommunity\Core\Controller\BaseController->executeFunction(‘updateViews’)\n#8 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(280): OxidEsales\EshopCommunity\Core\ShopControl->executeAction(Object(OxidEsales\Eshop\Application\Controller\Admin\ToolsList), ‘updateViews’)\n#9 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(142): OxidEsales\EshopCommunity\Core\ShopControl->_process(‘OxidEsales\\Esho…’, ‘updateViews’, NULL, NULL)\n#10 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/Oxid.php(27): OxidEsales\EshopCommunity\Core\ShopControl->start()\n#11 /var/www/virtual/pamina19/shopsamuelsstuff/source/index.php(16): OxidEsales\EshopCommunity\Core\Oxid::run()\n#12 /var/www/virtual/pamina19/shopsamuelsstuff/source/admin/index.php(12): require_once(’/var/www/virtua…’)\n#13 {main}\n"] []
[2020-09-09 11:37:46] OXID Logger.ERROR: ‘pamina19_samuel.oxv_oxarticles_de’ is not of type ‘VIEW’ ["[object] (OxidEsales\Eshop\Core\Exception\DatabaseErrorException(code: 1347): ‘pamina19_samuel.oxv_oxarticles_de’ is not of type ‘VIEW’ at /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php:925, Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing 'CREATE OR REPLACE SQL SECURITY INVOKER VIEW oxv_oxarticles_de AS SELECT oxarticles.OXID AS OXID,oxarticles.OXSHOPID AS OXSHOPID,oxarticles.OXPARENTID AS OXPARENTID,oxarticles.OXACTIVE AS OXACTIVE,oxarticles.OXHIDDEN AS OXHIDDEN,oxarticles.OXACTIVEFROM AS OXACTIVEFROM,oxarticles.OXACTIVETO AS OXACTIVETO,oxarticles.OXARTNUM AS OXARTNUM,oxarticles.OXEAN AS OXEAN,oxarticles.OXDISTEAN AS OXDISTEAN,oxarticles.OXMPN AS OXMPN,oxarticles.OXTITLE AS OXTITLE,oxarticles.OXSHORTDESC AS OXSHORTDESC,oxarticles.OXPRICE AS OXPRICE,oxarticles.OXBLFIXEDPRICE AS OXBLFIXEDPRICE,oxarticles.OXPRICEA AS OXPRICEA,oxarticles.OXPRICEB AS OXPRICEB,oxarticles.OXPRICEC AS OXPRICEC,oxarticles.OXBPRICE AS OXBPRICE,oxarticles.OXTPRICE AS OXTPRICE,oxarticles.OXUNITNAME AS OXUNITNAME,oxarticles.OXUNITQUANTITY AS OXUNITQUANTITY,oxarticles.OXEXTURL AS OXEXTURL,oxarticles.OXURLDESC AS OXURLDESC,oxarticles.OXURLIMG AS OXURLIMG,oxarticles.OXVAT AS OXVAT,oxarticles.OXTHUMB AS OXTHUMB,oxarticles.OXICON AS OXICON,oxarticles.OXPIC1 AS OXPIC1,oxarticles.OXPIC2 AS OXPIC2,oxarticles.OXPIC3 AS OXPIC3,oxarticles.OXPIC4 AS OXPIC4,oxarticles.OXPIC5 AS OXPIC5,oxarticles.OXPIC6 AS OXPIC6,oxarticles.OXPIC7 AS OXPIC7,oxarticles.OXPIC8 AS OXPIC8,oxarticles.OXPIC9 AS OXPIC9,oxarticles.OXPIC10 AS OXPIC10,oxarticles.OXPIC11 AS OXPIC11,oxarticles.OXPIC12 AS OXPIC12,oxarticles.OXWEIGHT AS OXWEIGHT,oxarticles.OXSTOCK AS OXSTOCK,oxarticles.OXSTOCKFLAG AS OXSTOCKFLAG,oxarticles.OXSTOCKTEXT AS OXSTOCKTEXT,oxarticles.OXNOSTOCKTEXT AS OXNOSTOCKTEXT,oxarticles.OXDELIVERY AS OXDELIVERY,oxarticles.OXINSERT AS OXINSERT,oxarticles.OXTIMESTAMP AS OXTIMESTAMP,oxarticles.OXLENGTH AS OXLENGTH,oxarticles.OXWIDTH AS OXWIDTH,oxarticles.OXHEIGHT AS OXHEIGHT,oxarticles.OXFILE AS OXFILE,oxarticles.OXSEARCHKEYS AS OXSEARCHKEYS,oxarticles.OXTEMPLATE AS OXTEMPLATE,oxarticles.OXQUESTIONEMAIL AS OXQUESTIONEMAIL,oxarticles.OXISSEARCH AS OXISSEARCH,oxarticles.OXISCONFIGURABLE AS OXISCONFIGURABLE,oxarticles.OXVARNAME AS OXVARNAME,oxarticles.OXVARSTOCK AS OXVARSTOCK,oxarticles.OXVARCOUNT AS OXVARCOUNT,oxarticles.OXVARSELECT AS OXVARSELECT,oxarticles.OXVARMINPRICE AS OXVARMINPRICE,oxarticles.OXVARMAXPRICE AS OXVARMAXPRICE,oxarticles.OXBUNDLEID AS OXBUNDLEID,oxarticles.OXFOLDER AS OXFOLDER,oxarticles.OXSUBCLASS AS OXSUBCLASS,oxarticles.OXSORT AS OXSORT,oxarticles.OXSOLDAMOUNT AS OXSOLDAMOUNT,oxarticles.OXNONMATERIAL AS OXNONMATERIAL,oxarticles.OXFREESHIPPING AS OXFREESHIPPING,oxarticles.OXREMINDACTIVE AS OXREMINDACTIVE,oxarticles.OXREMINDAMOUNT AS OXREMINDAMOUNT,oxarticles.OXAMITEMID AS OXAMITEMID,oxarticles.OXAMTASKID AS OXAMTASKID,oxarticles.OXVENDORID AS OXVENDORID,oxarticles.OXMANUFACTURERID AS OXMANUFACTURERID,oxarticles.OXSKIPDISCOUNTS AS OXSKIPDISCOUNTS,oxarticles.OXRATING AS OXRATING,oxarticles.OXRATINGCNT AS OXRATINGCNT,oxarticles.OXMINDELTIME AS OXMINDELTIME,oxarticles.OXMAXDELTIME AS OXMAXDELTIME,oxarticles.OXDELTIMEUNIT AS OXDELTIMEUNIT,oxarticles.OXUPDATEPRICE AS OXUPDATEPRICE,oxarticles.OXUPDATEPRICEA AS OXUPDATEPRICEA,oxarticles.OXUPDATEPRICEB AS OXUPDATEPRICEB,oxarticles.OXUPDATEPRICEC AS OXUPDATEPRICEC,oxarticles.OXUPDATEPRICETIME AS OXUPDATEPRICETIME,oxarticles.OXISDOWNLOADABLE AS OXISDOWNLOADABLE,oxarticles.OXSHOWCUSTOMAGREEMENT AS OXSHOWCUSTOMAGREEMENT FROM oxarticles ':\n\nSQLSTATE[HY000]: General error: 1347 ‘pamina19_samuel.oxv_oxarticles_de’ is not of type ‘VIEW’ at /var/www/virtual/pamina19/shopsamuelsstuff/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 1347 ‘pamina19_samuel.oxv_oxarticles_de’ is not of type ‘VIEW’ at /var/www/virtual/pamina19/shopsamuelsstuff/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1347 ‘pamina19_samuel.oxv_oxarticles_de’ is not of type ‘VIEW’ at /var/www/virtual/pamina19/shopsamuelsstuff/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:41)\n[stacktrace]\n#0 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(767): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->convertException(Object(Doctrine\DBAL\Exception\DriverException))\n#1 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(564): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->executeUpdate(‘CREATE OR REPLA…’, Array)\n#2 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Application/Model/Shop.php(368): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->execute(‘CREATE OR REPLA…’)\n#3 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Application/Model/Shop.php(142): OxidEsales\EshopCommunity\Application\Model\Shop->_runQueries()\n#4 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/DbMetaDataHandler.php(571): OxidEsales\EshopCommunity\Application\Model\Shop->generateViews(false, Array)\n#5 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Application/Controller/Admin/ToolsList.php(37): OxidEsales\EshopCommunity\Core\DbMetaDataHandler->updateViews()\n#6 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/Controller/BaseController.php(534): OxidEsales\EshopCommunity\Application\Controller\Admin\ToolsList->updateViews()\n#7 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(347): OxidEsales\EshopCommunity\Core\Controller\BaseController->executeFunction(‘updateViews’)\n#8 /var/www/virtual/pamina19/shopsamuelsstuff/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(280): OxidEsales\EshopCommunity\Core\ShopControl->executeAction(Object(

OXID-Design · September 9, 2020, 10:00am

vom 6.0 beta auf 6.1 hat es alles funktioniert oder bist du ohne es zu testen direkt auf 6.2 gegangen? es scheint ein problem mit den datenbank views zu geben. deshalb wird dir auch backend nichts angezeigt.

milanffm · September 9, 2020, 10:18am

ich bin mit dem Shop umgezogen auf einen neuen Server. Ich dachte, da dort die minimale PHP Version 7.2 ist, ich mace die Updates in composer und dann läuft der Shop. Also ungetestet… Aber wird wohl so nichts. Ich muss wahrscheinlich den alten Shop mit PHP 7.2 erst mal zum laufen bekommen. Oder?

OXID-Design · September 9, 2020, 10:22am

ja, das habe ich schon verstanden aber meine frage war, hast du die 6er beta auf dem neuen server zum laufen gebracht? es scheint so als ob überhaupt keine views in der datenbank gibt.

vanilla_thunder · September 9, 2020, 10:24am

Prüfe mal die Datenbank, ob oxv_* Views auch wirklich als Views importiert wurden.

milanffm · September 9, 2020, 12:07pm

ich habe jetzt mal die Beta 6 neu kopiert. Und sie läuft nicht. folgende Fehlermeldungen:
[Wed Sep 14:03:44.563201 2020] [exception] [type OxidEsales\EshopCommunity\Core\Exception\ObjectException] [code 0] [file /vendor/oxid-esales/oxideshop-ce/source/Core/UtilsObject.php] [line 251] [message not set]
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#0 /source/oxfunctions.php(119): OxidEsales\EshopCommunity\Core\UtilsObject->oxNew(‘OxidEsales\Esho…’)
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#1 /vendor/oxid-esales/oxideshop-ce/source/Application/Model/VatSelector.php(77): oxNew(‘OxidEsales\Esho…’)
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#2 /vendor/oxid-esales/oxideshop-ce/source/Application/Model/VatSelector.php(203): OxidEsales\EshopCommunity\Application\Model\VatSelector->getUserVat(Object(oePayPalOxUser))
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#3 /vendor/oxid-esales/oxideshop-ce/source/Application/Model/Article.php(3916): OxidEsales\EshopCommunity\Application\Model\VatSelector->getArticleUserVat(Object(oePayPalOxArticle))
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#4 /vendor/oxid-esales/oxideshop-ce/source/Application/Model/Article.php(3590): OxidEsales\EshopCommunity\Application\Model\Article->_applyVAT(Object(OxidEsales\EshopCommunity\Core\Price), ‘19’)
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#5 /vendor/oxid-esales/oxideshop-ce/source/Application/Model/Article.php(2070): OxidEsales\EshopCommunity\Application\Model\Article->_calculatePrice(Object(OxidEsales\EshopCommunity\Core\Price))
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#6 /source/tmp/smarty/ee5ab84e14c98522f7a4ff6fb4f32001^%%27^273^27320283%%article_main.tpl.php(319): OxidEsales\EshopCommunity\Application\Model\Article->getPrice()
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#7 /vendor/smarty/smarty/libs/Smarty.class.php(1270): include(’/var/www/virtua…’)
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#8 /vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(504): Smarty->fetch(‘article_main.tp…’, NULL)
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#9 /vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(360): OxidEsales\EshopCommunity\Core\ShopControl->_render(Object(OxidEsales\EshopCommunity\Application\Controller\Admin\ArticleMain))
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#10 /vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(292): OxidEsales\EshopCommunity\Core\ShopControl->formOutput(Object(OxidEsales\EshopCommunity\Application\Controller\Admin\ArticleMain))
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#11 /vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(153): OxidEsales\EshopCommunity\Core\ShopControl->_process(‘OxidEsales\Esho…’, NULL, NULL, NULL)
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#12 /vendor/oxid-esales/oxideshop-ce/source/Core/Oxid.php(43): OxidEsales\EshopCommunity\Core\ShopControl->start()
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#13 /source/index.php(31): OxidEsales\EshopCommunity\Core\Oxid::run()
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#14 /source/admin/index.php(27): require_once(’/var/www/virtua…’)
[Wed Sep 14:03:44.563201 2020] [exception] [stacktrace]

#15 {main}

und auf der Seite mit den Artikeln folgende Fehlermedlung:

not set

#0 /var/www/virtual/pamina19/shopsamuelsstuff-123/source/oxfunctions.php(119): OxidEsales\EshopCommunity\Core\UtilsObject->oxNew(‘OxidEsales\Esho…’)
#1 /var/www/virtual/pamina19/shopsamuelsstuff-123/vendor/oxid-esales/oxideshop-ce/source/Application/Model/VatSelector.php(77): oxNew(‘OxidEsales\Esho…’)
#2 /var/www/virtual/pamina19/shopsamuelsstuff-123/vendor/oxid-esales/oxideshop-ce/source/Application/Model/VatSelector.php(203): OxidEsales\EshopCommunity\Application\Model\VatSelector->getUserVat(Object(oePayPalOxUser))
#3 /var/www/virtual/pamina19/shopsamuelsstuff-123/vendor/oxid-esales/oxideshop-ce/source/Application/Model/Article.php(3916): OxidEsales\EshopCommunity\Application\Model\VatSelector->getArticleUserVat(Object(oePayPalOxArticle))
#4 /var/www/virtual/pamina19/shopsamuelsstuff-123/vendor/oxid-esales/oxideshop-ce/source/Application/Model/Article.php(3590): OxidEsales\EshopCommunity\Application\Model\Article->_applyVAT(Object(OxidEsales\EshopCommunity\Core\Price), ‘19’)
#5 /var/www/virtual/pamina19/shopsamuelsstuff-123/vendor/oxid-esales/oxideshop-ce/source/Application/Model/Article.php(2070): OxidEsales\EshopCommunity\Application\Model\Article->_calculatePrice(Object(OxidEsales\EshopCommunity\Core\Price))
#6 /var/www/virtual/pamina19/shopsamuelsstuff-123/source/tmp/smarty/ee5ab84e14c98522f7a4ff6fb4f32001^%%27^273^27320283%%article_main.tpl.php(319): OxidEsales\EshopCommunity\Application\Model\Article->getPrice()
#7 /var/www/virtual/pamina19/shopsamuelsstuff-123/vendor/smarty/smarty/libs/Smarty.class.php(1270): include(’/var/www/virtua…’)
#8 /var/www/virtual/pamina19/shopsamuelsstuff-123/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(504): Smarty->fetch(‘article_main.tp…’, NULL)
#9 /var/www/virtual/pamina19/shopsamuelsstuff-123/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(360): OxidEsales\EshopCommunity\Core\ShopControl->_render(Object(OxidEsales\EshopCommunity\Application\Controller\Admin\ArticleMain))
#10 /var/www/virtual/pamina19/shopsamuelsstuff-123/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(292): OxidEsales\EshopCommunity\Core\ShopControl->formOutput(Object(OxidEsales\EshopCommunity\Application\Controller\Admin\ArticleMain))
#11 /var/www/virtual/pamina19/shopsamuelsstuff-123/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(153): OxidEsales\EshopCommunity\Core\ShopControl->_process(‘OxidEsales\Esho…’, NULL, NULL, NULL)
#12 /var/www/virtual/pamina19/shopsamuelsstuff-123/vendor/oxid-esales/oxideshop-ce/source/Core/Oxid.php(43): OxidEsales\EshopCommunity\Core\ShopControl->start()
#13 /var/www/virtual/pamina19/shopsamuelsstuff-123/source/index.php(31): OxidEsales\EshopCommunity\Core\Oxid::run()
#14 /var/www/virtual/pamina19/shopsamuelsstuff-123/source/admin/index.php(27): require_once(’/var/www/virtua…’)
#15 {main};

rubbercut · September 9, 2020, 12:22pm

Welche php-Version? MariaDB ?

milanffm · September 9, 2020, 12:25pm

PHP:	7.2.33
MySQL:	10.3.24-MariaDB
Apache:	Apache/2.4.39 (Unix)

OXID-Design · September 9, 2020, 12:45pm

merkst du was? man sollte immer aktualisieren, dann testen und dann wenn alles funktioniert der nächster schritt. hast du schon geguckt, wie marat schon gesagt hat ob in der db die views existieren und ob die auch so gekennzeichnet sind?

milanffm · September 9, 2020, 12:58pm

ja .-) … ich dachte nur, dass der alte shop mit php 7.2 und mariaDB 10 eh nicht richtig läuft und somit ich erst updaten muss … ich schau mal nach der DB …

milanffm · September 9, 2020, 1:00pm

wie sehe ich ob sie als Views importiert worden sind?

OXID-Design · September 9, 2020, 1:04pm

unter einem db sind es zwei getrennte auflistungen, views und die eigentliche shop tabellen. die views werden auch als “views” gekennzeichnet (phpmyadmin).

milanffm · September 9, 2020, 1:09pm

also die views sind leer.

alsod z.B. die Tabelle oxattribute hat einträge und die Tabelle

oxv_oxattribute keine

OXID-Design · September 9, 2020, 1:10pm

wie sieht es mit der tabelle oxv_oxarticles aus, auch leer?

milanffm · September 9, 2020, 1:14pm

Ja oxv_oxarticles ist auch leer.

rubbercut · September 9, 2020, 1:14pm

Ist nicht zufäälig aktiviert? $this->blSkipViewUsage = true;

https://docs.oxid-esales.com/developer/en/6.1/project/configincphp.html

milanffm · September 9, 2020, 1:16pm

$this->blSkipViewUsage ist auf false gestellt.