View Issue Details

IDProjectCategoryView StatusLast Update
0006985OXID eShop (all versions)2.4. Administer productspublic2019-06-10 16:24
Reporteralfredbez 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version6.1.3 
Target VersionFixed in VersionNext Minor Version 
Summary0006985: unable to remove last item in category sort-popup (SQL error)
DescriptionYou 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 ReproduceSee 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>
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP Version7.1
MySQL Version5.7

Activities

alfredbez

2019-05-23 16:07

reporter  

OXID-Bug-category-sort.gif (458,490 bytes)

alfredbez

2019-05-23 16:14

reporter   ~0012898

PR: https://github.com/OXID-eSales/oxideshop_ce/pull/707