Tweet
Как только ставлю в одном из разделов галку "Полнотекстовый поиск" вылазит плашка "Ошибка 500". В других разделах все ровно, а в этом одно какая-то проблема. Вот выдержка из логов. Прошу помощи.
[2020-05-16 12:37:17] Espo.ERROR: (HY000) SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list; GET /api/v1/Lands?select=idObj%2CaccountId%2CaccountName%2Ctar getLand%2CadressCity%2Carea%2CcadNum&maxSize=15&of fset=0&orderBy=invNum&order=asc&where%5B0%5D%5Btyp e%5D=textFilter&where%5B0%5D%5Bvalue%5D=%D0%B0%D0% BA%D0%B0%D0%B4%D0%B5%D0%BC%D0%B8%D0%BA%D0%B0&where %5B1%5D%5Battribute%5D=targetLand; line: 132, file: /var/www/u0762037/data/www/crmras.ru/application/Espo/ORM/DB/Mapper.php [] []
[2020-05-16 12:37:52] Espo.DEBUG: API (HY000) SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list; GET /api/v1/Lands?select=idObj%2CaccountId%2CaccountName%2Ctar getLand%2CadressCity%2Carea%2CcadNum&maxSize=15&of fset=0&orderBy=invNum&order=asc&where%5B0%5D%5Btyp e%5D=textFilter&where%5B0%5D%5Bvalue%5D=%D0%B0%D0% BA%D0%B0%D0%B4%D0%B5%D0%BC%D0%B8%D0%BA%D0%B0; Route pattern: /:controller; Route params: Array ( [controller] => Lands ) [] []
[2020-05-16 12:37:52] Espo.ERROR: (HY000) SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list; GET /api/v1/Lands?select=idObj%2CaccountId%2CaccountName%2Ctar getLand%2CadressCity%2Carea%2CcadNum&maxSize=15&of fset=0&orderBy=invNum&order=asc&where%5B0%5D%5Btyp e%5D=textFilter&where%5B0%5D%5Bvalue%5D=%D0%B0%D0% BA%D0%B0%D0%B4%D0%B5%D0%BC%D0%B8%D0%BA%D0%B0; line: 132, file: /var/www/u0762037/data/www/crmras.ru/application/Espo/ORM/DB/Mapper.php [] []
[2020-05-16 12:37:17] Espo.ERROR: (HY000) SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list; GET /api/v1/Lands?select=idObj%2CaccountId%2CaccountName%2Ctar getLand%2CadressCity%2Carea%2CcadNum&maxSize=15&of fset=0&orderBy=invNum&order=asc&where%5B0%5D%5Btyp e%5D=textFilter&where%5B0%5D%5Bvalue%5D=%D0%B0%D0% BA%D0%B0%D0%B4%D0%B5%D0%BC%D0%B8%D0%BA%D0%B0&where %5B1%5D%5Battribute%5D=targetLand; line: 132, file: /var/www/u0762037/data/www/crmras.ru/application/Espo/ORM/DB/Mapper.php [] []
[2020-05-16 12:37:52] Espo.DEBUG: API (HY000) SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list; GET /api/v1/Lands?select=idObj%2CaccountId%2CaccountName%2Ctar getLand%2CadressCity%2Carea%2CcadNum&maxSize=15&of fset=0&orderBy=invNum&order=asc&where%5B0%5D%5Btyp e%5D=textFilter&where%5B0%5D%5Bvalue%5D=%D0%B0%D0% BA%D0%B0%D0%B4%D0%B5%D0%BC%D0%B8%D0%BA%D0%B0; Route pattern: /:controller; Route params: Array ( [controller] => Lands ) [] []
[2020-05-16 12:37:52] Espo.ERROR: (HY000) SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list; GET /api/v1/Lands?select=idObj%2CaccountId%2CaccountName%2Ctar getLand%2CadressCity%2Carea%2CcadNum&maxSize=15&of fset=0&orderBy=invNum&order=asc&where%5B0%5D%5Btyp e%5D=textFilter&where%5B0%5D%5Bvalue%5D=%D0%B0%D0% BA%D0%B0%D0%B4%D0%B5%D0%BC%D0%B8%D0%BA%D0%B0; line: 132, file: /var/www/u0762037/data/www/crmras.ru/application/Espo/ORM/DB/Mapper.php [] []
Comment