Database error - photos

Hi, 

I started to receive a lot of emails about Database error

This is what error is about:

Query:

SELECT COUNT(*) FROM `bx_photos_main`  left JOIN `Profiles` ON `Profiles`.`ID`=`bx_photos_main`.`Owner` left JOIN `sys_albums_objects` ON `sys_albums_objects`.`id_object`=`bx_photos_main`.`ID` left JOIN `sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album` WHERE 1 AND `bx_photos_main`.`Status` ='approved' AND `Profiles`.`Status` NOT IN('Rejected','Suspended') AND MATCH(`bx_photos_main`.`Tags`) AGAINST ('like') AND `sys_albums`.`AllowAlbumView` NOT IN('8') AND `sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_photos' 

Mysql error: Can't find FULLTEXT index matching the column list

Any help about that?

Hello Mayki!

This error means that your `bx_photos_main`table hasn't FULLTEXT indexes in some columns (for now it's a `tags`). You have 2 ways to fix it:

1) Disable Full-Text Search via admin panel->settings->advanced settings, turn off the parameter with the same name.

2) Install this index via the execution of the following query in your Dolphin DB:

ALTER TABLE `bx_photos_main` ADD FULLTEXT KEY `ftMain` (`Title`, `Tags`, `Desc`, `Categories`);

ALTER TABLE `bx_photos_main` ADD FULLTEXT KEY `ftTags` (`Tags`);

ALTER TABLE `bx_photos_main` ADD FULLTEXT KEY `ftCategories` (`Categories`);

LeonidS, thank you very much for your help.

I have disabled full text search in advanced settings.

Kind regards

Mayki