Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Data Object] Grid: error when activating filters for a select field without a value #1326

Closed
BlackbitDevs opened this issue Mar 2, 2017 · 0 comments
Assignees
Labels
Milestone

Comments

@BlackbitDevs
Copy link
Contributor

Expected behavior

No filtering

Actual behavior

Status: 500 | Internal Server Error
URL: /admin/object/grid-proxy/classId/3/folderId/11?xaction=read&_dc=1488440541271
Params:
-> language: en
-> class: inquiry

Fatal error: Uncaught Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND object_3.o_type IN ('object','folder')) ORDER BY o_id ASC LIMIT 25' at line 1 in /home/pimcore_demo/www/vendor/zendframework/zendframework1/library/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /home/pimcore_demo/www/vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('SELECT object_3...')
#1 /home/pimcore_demo/www/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT object_3...')
#2 /home/pimcore_demo/www/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('SELECT object_3...')
#3 /home/pimcore_demo/www/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(794): Zend_Db_Ad in /home/pimcore_demo/www/vendor/zendframework/zendframework1/library/Zend/Db/Statement/Mysqli.php on line 77

Steps to reproduce

  1. Create class with select field and add options
  2. Create folder
  3. create object of the class in 1. in the folder of 2. and set select field to any option
  4. save object
  5. open folder
  6. add the select field column to the table
  7. click "Filters" in select field column submenu without actually choosing a value in the Filters submenu
@brusch brusch changed the title 500 error when activating filters for a select field without specifying a filter value [Data Object] Grid: error when activating filters for a select field without a value Jan 31, 2019
@brusch brusch self-assigned this Jan 31, 2019
@brusch brusch added the Bug label Jan 31, 2019
@brusch brusch closed this as completed in 90c143e Jan 31, 2019
@brusch brusch added this to the 5.6.3 milestone Jan 31, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants