View Issue Details

IDProjectCategoryView StatusLast Update
0006728module PayPalmodule PayPal - subpublic2018-09-10 16:27
Reporterfthielen 
PrioritynormalSeverityminorReproducibilityalways
Status acknowledgedResolutionopen 
Product Version5.2.2 
Target VersionFixed in Version 
Summary0006728: PayPal Module SQL Error
DescriptionIf i activate the PayPal Module, which is provided with OXID 6.0, and i try to sort the Orders by Payment Type,
the Shop displays the offline page.
This is the error from the EXCEPTION.log:
[24 Nov 19:56:40.943233 2017] [exception] [type OxidEsales\Eshop\Core\Exception\DatabaseErrorException] [code 1054] [file /www/htdocs/Pfad_Zensiert/oxid-6/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php] [line 947] [message Unknown column 'oepaypal_order.oepaypal_paymentstatus' in 'order clause']
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] #0 /www/htdocs/Pfad_Zensiert/oxid-6/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))
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] #1 /www/htdocs/Pfad_Zensiert/oxid-6/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(694): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->select('select `oxorder...', Array)
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] #2 /www/htdocs/Pfad_Zensiert/oxid-6/vendor/oxid-esales/oxideshop-ce/source/Core/Model/ListModel.php(370): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->selectLimit('select `oxorder...', 10, 0, Array)
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] #3 /www/htdocs/Pfad_Zensiert/oxid-6/vendor/oxid-esales/oxideshop-ce/source/Application/Controller/Admin/AdminListController.php(793): OxidEsales\EshopCommunity\Core\Model\ListModel->selectString('select `oxorder...')
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] #4 /www/htdocs/Pfad_Zensiert/oxid-6/vendor/oxid-esales/oxideshop-ce/source/Application/Controller/Admin/AdminListController.php(214): OxidEsales\EshopCommunity\Application\Controller\Admin\AdminListController->getItemList()
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] #5 /www/htdocs/Pfad_Zensiert/oxid-6/vendor/oxid-esales/oxideshop-ce/source/Application/Controller/Admin/OrderList.php(48): OxidEsales\EshopCommunity\Application\Controller\Admin\AdminListController->render()
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] #6 /www/htdocs/Pfad_Zensiert/oxid-6/source/modules/oe/oepaypal/Controller/Admin/OrderList.php(39): OxidEsales\EshopCommunity\Application\Controller\Admin\OrderList->render()
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] #7 /www/htdocs/Pfad_Zensiert/oxid-6/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(453): OxidEsales\PayPalModule\Controller\Admin\OrderList->render()
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] #8 /www/htdocs/Pfad_Zensiert/oxid-6/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(344): OxidEsales\EshopCommunity\Core\ShopControl->_render(Object(OxidEsales\PayPalModule\Controller\Admin\OrderList))
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] #9 /www/htdocs/Pfad_Zensiert/oxid-6/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(276): OxidEsales\EshopCommunity\Core\ShopControl->formOutput(Object(OxidEsales\PayPalModule\Controller\Admin\OrderList))
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] #10 /www/htdocs/Pfad_Zensiert/oxid-6/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(137): OxidEsales\EshopCommunity\Core\ShopControl->_process('OxidEsales\\Esho...', '', NULL, NULL)
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] 0000011 /www/htdocs/Pfad_Zensiert/oxid-6/vendor/oxid-esales/oxideshop-ce/source/Core/Oxid.php(26): OxidEsales\EshopCommunity\Core\ShopControl->start()
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] 0000012 /www/htdocs/Pfad_Zensiert/oxid-6/source/index.php(15): OxidEsales\EshopCommunity\Core\Oxid::run()
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] 0000013 /www/htdocs/Pfad_Zensiert/oxid-6/source/admin/index.php(11): require_once('/www/htdocs/w01...')
[24 Nov 19:56:40.943233 2017] [exception] [stacktrace] 0000014 {main}
Steps To Reproduce1. Enable the provided PayPal Module
2. Go to "Manage Orders" --> "Orders"
3. Click on the Column "Payment Type"
TagsMySQL, Offline, Order List, PayPal

Relationships

related to 0006859 acknowledgedbenjamin.joerger module PayPal "Payment Method" column cant be filtered in Administer Orders 
related to 0006774 resolvedanton.fedurtsya OXID eShop (all versions) In backend, orderlist column 'PAYMENT METHOD' stays empty 

Activities

fthielen

2017-11-27 09:07

reporter