| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006985 | OXID eShop (all versions) | 2.4. Administer products | public | 2019-05-23 16:07 | 2019-06-10 16:24 |
| Reporter | alfredbez | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 6.1.3 | ||||
| Fixed in Version | 6.2.0-beta.1 | ||||
| Summary | 0006985: unable to remove last item in category sort-popup (SQL error) | ||||
| Description | You will get a SQL-error if you try to remove the last item on the right side in the AJAX-popup (Category Sorting). | ||||
| Steps To Reproduce | See this short gif: https://i.imgur.com/zOpCEBL.gif 1. open shop backend 2. go to 'Artikel verwalten' > 'Kategorien' 3. Choose a category with some articles 4. Open 4th tab 'Sorterung' 5. Click on 'Artikel sortieren' to open the popup 6. Drag an item to the right side 7. Drag the only item from the right side to the left side => The item remains on the right side and you see this error in the log: <code>[2019-05-23 16:00:33] OXID Logger.ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' atline 1 ["[object] (OxidEsales\\Eshop\\Core\\Exception\\DatabaseErrorException(code: 1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at /var/www/oxideshop/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php:938, Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'select 1 from oxv_oxarticles_de left join oxobject2category on oxv_oxarticles_de.oxid=oxobject2category.oxobjectid where oxobject2category.oxcatnid = '0f4f08358666c54b4fde3d83d2b7ef04' and oxv_oxarticles_de.oxparentid = '' and oxv_oxarticles_de.oxid not in ( ) ':\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at /var/www/oxideshop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:90, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at /var/www/oxideshop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at /var/www/oxideshop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104)\n[stacktrace]\n#0 /var/www/oxideshop/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(304): OxidEsales\\EshopCommunity\\Core\\Database\\Adapter\\Doctrine\\Database->convertException(Object(Doctrine\\DBAL\\Exception\\SyntaxErrorException))\n#1 /var/www/oxideshop/vendor/oxid-esales/oxideshop-ce/source/Application/Controller/Admin/CategoryOrderAjax.php(125): OxidEsales\\EshopCommunity\\Core\\Database\\Adapter\\Doctrine\\Database->getOne('select 1 from o...')\n#2 /var/www/oxideshop/vendor/oxid-esales/oxideshop-ce/source/Application/Controller/Admin/ListComponentAjax.php(144): OxidEsales\\EshopCommunity\\Application\\Controller\\Admin\\CategoryOrderAjax->removeCatOrderArticle()\n#3 /var/www/oxideshop/source/admin/oxajax.php(61): OxidEsales\\EshopCommunity\\Application\\Controller\\Admin\\ListComponentAjax->processRequest('removecatordera...')\n#4 {main}\n"] []</code> | ||||
| Tags | No tags attached. | ||||
| Theme | Not defined | ||||
| Browser | Not defined | ||||
| PHP Version | 7.1 | ||||
| Database Version | 5.7 | ||||
- Anonymous
