Database query error after 7.3.4 upgrade in search

Hi please help me,

I upgraded from 7.3.3 to 7.3.4 and now when I search user's full name nickname, I get the database error. When joining, my users do not write First name and Last name. They write only full name. 

Query:

SELECT COUNT(*) FROM `Profiles`  WHERE 1 AND `Profiles`.`Status` ='Active' AND MATCH(`Profiles`.`NickName`, `Profiles`.`FullName`, `Profiles`.`FirstName`, `Profiles`.`LastName`, `Profiles`.`DescriptionMe`, `Profiles`.`City`, `Profiles`.`Tags`) AGAINST ('Alice Johnson') AND (`Profiles`.`Couple` = 0 OR `Profiles`.`Couple` > `Profiles`.`ID`)  

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

Found error in the file '/home/xxxxxxxx/public_html/inc/classes/BxDolSearch.php' at line 506.
Called 'db_value' function with erroneous argument #0.


Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /home/xxxxxxxx/public_html/inc/classes/BxDolDb.php
            [line] => 246
            [function] => error
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => Can't find FULLTEXT index matching the column list
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => xxxxxxx_database_name
                    [user] => *****
                    [password] => *****
                    [link] => Resource id #25
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => BxDolParams Object
                        (
                            [_oDb] => BxDolDb Object
 *RECURSION*
                            [_oCache] => BxDolCacheFile Object
                                (
                                    [sPath] => /home/xxxxxxxx/public_html/cache/
                                )

                            [_sCacheFile] => sys_options_e4f3502a0a5c5512a03693cca74f0453.php
                            [_aParams] => [truncated]
                        )

                    [oDbCacheObject] => BxDolCacheFile Object
                        (
                            [sPath] => /home/xxxxxxxx/public_html/cache/
                        )

                )

           

Could you please specify what is the page generates this error ?

Hi Alex,

Thanks for replying

All pages work fine. This error message "Database querry error" appears on any page as long as I type a word in the search box and press enter. It does not matter the page I am on. The search does not work. it produces the error when I search in the search box. The error code above, I received it through email as bug report.

It looks like your upgrade wasn't successfully completed, I would suggest to run the following SQL query to manually fix this issue:

ALTER TABLE  `Profiles` DROP INDEX  `NickName_2`;
ALTER TABLE  `Profiles` ADD FULLTEXT KEY `NickName_2` (`NickName`,`FullName`,`FirstName`,`LastName`,`City`,`DescriptionMe`,`Tags`);

ALTER TABLE  `Profiles` DROP INDEX  `NickName_2`;
ALTER TABLE  `Profiles` ADD FULLTEXT KEY `NickName_2` (`NickName`,`FullName`,`FirstName`,`LastName`,`City`,`DescriptionMe`,`Tags`);

If the upgrade was not successfully completed, then there might be other areas that are broken.

ALTER TABLE  `Profiles` DROP INDEX  `NickName_2`;
ALTER TABLE  `Profiles` ADD FULLTEXT KEY `NickName_2` (`NickName`,`FullName`,`FirstName`,`LastName`,`City`,`DescriptionMe`,`Tags`);

 Thank you so much AlexT. That solved the problem

 You are right. Some parts might be broken too if the update didn't complete successfully. I will watch out for any other errors if any. Thanks

ALTER TABLE  `Profiles` DROP INDEX  `NickName_2`;
ALTER TABLE  `Profiles` ADD FULLTEXT KEY `NickName_2` (`NickName`,`FullName`,`FirstName`,`LastName`,`City`,`DescriptionMe`,`Tags`);