2017-02-09 04:35:04
2017-02-08 21:24:12
2017-02-08 21:24:12
7305
@Friendica Support
Fulltext search doesn't work on my system anymore. The logfile says
@Michael Vogel
Is this maybe the result of an failed update? Or maybe the result from the switch to InnoDB?
Fulltext search doesn't work on my system anymore. The logfile says
2017-02-08 21:06:37@ll7dsh4pv24o7a5a29ii32ed47 [NORMAL]:dba.php:257:q DB Error (Connected) 1191: Can't find FULLTEXT index matching the column list
2017-02-08 21:06:37@ll7dsh4pv24o7a5a29ii32ed47 [NORMAL]:dba.php:290:q dba: SELECT `item`.`author-link`, `item`.`author-name`, `item`.`author-avatar`,
`item`.`owner-link`, `item`.`owner-name`, `item`.`owner-avatar`,
`item`.`contact-id`, `item`.`uid`, `item`.`id`, `item`.`parent`,
`item`.`uri`, `item`.`thr-parent`, `item`.`parent-uri`,
`item`.`commented`, `item`.`created`, `item`.`edited`,
`item`.`verb`, `item`.`object-type`, `item`.`postopts`, `item`.`plink`,
`item`.`guid`, `item`.`wall`, `item`.`private`, `item`.`starred`,
`item`.`title`, `item`.`body`, `item`.`file`, `item`.`event-id`,
`item`.`location`, `item`.`coord`, `item`.`app`, `item`.`attach`,
`item`.`rendered-hash`, `item`.`rendered-html`, `item`.`object`,
`item`.`allow_cid`, `item`.`allow_gid`, `item`.`deny_cid`, `item`.`deny_gid`,
`item`.`id` AS `item_id`, `item`.`network` AS `item_network`,
`author`.`thumb` AS `author-thumb`, `owner`.`thumb` AS `owner-thumb`,
`contact`.`network`, `contact`.`url`, `contact`.`name`, `contact`.`writable`,
`contact`.`self`, `contact`.`id` AS `cid`, `contact`.`alias`
FROM `item` STRAIGHT_JOIN `contact` ON `contact`.`id` = `item`.`contact-id` AND
(NOT `contact`.`blocked` OR `contact`.`pending`)
LEFT JOIN `contact` AS `author` ON `author`.`id`=`item`.`author-id`
LEFT JOIN `contact` AS `owner` ON `owner`.`id`=`item`.`owner-id`
WHERE `item`.`visible` AND NOT `item`.`deleted` AND NOT `item`.`moderated` AND (`item`.`uid` = 0 OR (`item`.`uid` = 8 AND NOT `item`.`global`))
AND MATCH (`item`.`body`, `item`.`title`) AGAINST ('Tabellen' in boolean mode)
GROUP BY `item`.`uri` ORDER BY `item`.`id` DESC LIMIT 0 , 50 returned false.
Can't find FULLTEXT index matching the column list
@Michael Vogel
Is this maybe the result of an failed update? Or maybe the result from the switch to InnoDB?
Hypolite Petovan likes this.
Michael Vogel
Rabuzarus
Hypolite Petovan
convert_innodb.sql
.Rabuzarus
But you can have a look in the admin settings if fulltext search is enabled
Hypolite Petovan
Rabuzarus
OK have it.
The fulltext indexes for title and body are needed for the search (https://github.com/friendica/friendica/blob/develop/mod/search.php#L207)
but they were commented out with
https://github.com/friendica/friendica/commit/44d966574dc2edc58e1f5c0402a1956d4d554235
and deleted with
https://github.com/friendica/friendica/commit/37ce5ce88624163c8a748bfe16a2def5c18a53dc
Hypolite Petovan
Michael Vogel