From my site when i click on search and add a key word in key word search I get a DB error in red on the site. The system sends me, the admin, a db error email. Anyone else getting this ? I have been getting this for months now I know why. Here is the top of the email:
Query:
SELECT COUNT(*) FROM `bx_ads_main` inner JOIN `bx_ads_category_subs` ON `bx_ads_category_subs`.`ID`=`bx_ads_main`.`IDClassifiedsSubs` inner JOIN `bx_ads_category` ON `bx_ads_category`.`ID`=`bx_ads_category_subs`.`IDClassified` inner JOIN `Profiles` ON `Profiles`.`ID`=`bx_ads_main`.`IDProfile` WHERE 1 AND `bx_ads_main`.`Status` ='active' AND MATCH(`bx_ads_main`.`Subject`, `bx_ads_main`.`Message`, `bx_ads_main`.`Tags`, `bx_ads_main`.`City`) AGAINST ('I') AND UNIX_TIMESTAMP() - `bx_ads_main`.`LifeTime`*24*60*60 < `bx_ads_main`.`DateTime`
Mysql error: Can't find FULLTEXT index matching the column list
Found error in the file '/home/maddxwx/public_html/inc/classes/BxDolSearch.php' at line 514.
Called 'db_value' function with erroneous argument #0.
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/maddxwx/public_html/inc/classes/BxDolDb.php
[line] => 236
[function] => error
[class] => BxDolDb
[type] => ->
[object] => BxDolDb Object
(
[error_checking] => 1
[host] => localhost
[port] =>
