| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006728 | module PayPal | module PayPal - sub | public | 2017-11-27 09:07 | 2023-06-29 09:19 |
| Reporter | fthielen | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 5.2.2 | ||||
| Summary | 0006728: PayPal Module SQL Error | ||||
| Description | If 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 Reproduce | 1. Enable the provided PayPal Module 2. Go to "Manage Orders" --> "Orders" 3. Click on the Column "Payment Type" | ||||
| Tags | MySQL, Offline, Order List, PayPal | ||||
- Anonymous
