I have been getting this Data Base Error sent to my email like 2 or 3 times a day. some days I wont get it at all and others i get it even more. My chat room doesnt work at all for anyone (admin, guest, members) and I really need this feature in a big way. I want to do a fresh install as this one was done with a 6.16 migration from what i feel was a bad 6.16 db. I dont want to loose all my d7 community members or any of thier blogs or pictures. Any Advice? here is part of the error
Database error in
Query:
SELECT COUNT(*) FROM `bx_blogs_posts` left JOIN `Profiles` ON `Profiles`.`ID`=`bx_blogs_posts`.`OwnerID` WHERE 1 AND `bx_blogs_posts`.`PostStatus` ='approval' AND MATCH(`bx_blogs_posts`.`Categories`) AGAINST ('Make Me Laugh')
Mysql error: Can't find FULLTEXT index matching the column list
Found error in the file '/home/dolphin/public_html/inc/classes/BxDolSearch.php' at line 511.
Called 'db_value' function with erroneous argument #0.
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/dolphin/public_html/inc/classes/BxDolDb.php
[line] => 238
[function] => error
[class] => BxDolDb
[type] => ->
[object] => BxDolDb Object
(
[error_checking] => 1
[host] => localhost
[port] =>
[socket] =>
[dbname] => dolphin_Whale
[user] => dolphin_unity
[password] => unityd7
[link] => Resource id #44
[current_res] =>
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
*RECURSION*
[_oCache] => BxDolCacheFile Object