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

When creating a new model with a listing component grid, fulltext search is not working #1315

Open
ioweb-gr opened this issue Mar 13, 2023 · 1 comment · May be fixed by #2037
Open

When creating a new model with a listing component grid, fulltext search is not working #1315

ioweb-gr opened this issue Mar 13, 2023 · 1 comment · May be fixed by #2037
Labels

Comments

@ioweb-gr
Copy link

ioweb-gr commented Mar 13, 2023

Describe the bug (*)

When creating a new model with a grid fulltext search is not working. The entity and the grid is created properly but if you try to filter using the fulltext search, it's throwing an exception.

To Reproduce (*)

Steps to reproduce the behavior:

  1. Create a new entity with grid via the plugin
  2. Go to the backend listing grid
  3. Try to use the full search text box
  4. See error
    image
[2023-03-13 13:36:24] main.CRITICAL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fulltext' in 'where clause', query was: SELECT COUNT(*) FROM `oem_product` AS `main_table` WHERE ((`fulltext` LIKE '%itunes%')) {"exception":"[object] (Zend_Db_Statement_Exception(code: 42): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fulltext' in 'where clause', query was: SELECT COUNT(*) FROM `oem_product` AS `main_table` WHERE ((`fulltext` LIKE '%itunes%')) at /var/www/fasttrack/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:110, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fulltext' in 'where clause' at /var/www/fasttrack/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:91)"}

Expected behavior (*)

Search works correctly

Screenshots

Please complete the following information: (*)

  • OS: Ubuntu 20.04 / Windows 11 x 64
  • PhpStorm/Intellij version: 2022.3.2
  • Plugin Version: 5.0.1

Additional context

It seems at the very least that the plugin is not creating a fulltext search index in the db_schema.xml file (even with placeholder for required attributes) and also it's not creating the DataProvider correctly to add the full text filter in the collection.

@ioweb-gr ioweb-gr added the bug label Mar 13, 2023
@m2-assistant
Copy link

m2-assistant bot commented Mar 13, 2023

Hi @ioweb-gr. Thank you for your report.
To speed up processing of this issue, make sure that you provided sufficient information.
Add a comment to assign the issue: @magento I am working on this


Join Magento Community Engineering Slack and ask your questions in #github channel.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
1 participant