Support Forum
Support Forum
Offline
a member just brought this to my attention the search function does not seem to be working, so I tested it and I am getting invalid database query notification in a pop up, I have deleted all plug ins and reverted to twenty twelve on my staging site and am still getting it, any suggestions?
Thank-you
Offline
moved it to my staging server, this is the error I am getting in my log
WordPress database error The used table type doesn't support FULLTEXT indexes for query SELECT SQL_CALC_FOUND_ROWS topic_id FROM rufus_sfposts WHERE MATCH(post_content) AGAINST ('earthenstead' IN BOOLEAN MODE) AND rufus_sfposts.forum_id IN (5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5861,5862,5863,5864) /* From [xxxxxxx.xxxxxxxxx.xxxx.com/forums/?search=1&new=1&forum=all&value=earthenstead&type=1&include=1] in [/nas/wp/www/xxxxxxx/xxxxxxx/wp-content/plugins/simple-press/sp-api/sp-api-wpdb.php:169] */ made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/twentyfourteen/page.php'), get_template_part, locate_template, load_template, require('/themes/twentyfourteen/content-page.php'), the_content, apply_filters('the_content'), call_user_func_array, sp_render_forum, sp_process_template, sp_load_template, include('/sp-resources/forum-themes/default/templates/spSearchView.php'), sp_Search, spSearchView->__construct, spSearchView->sp_searchview_control, spSearchView->sp_searchview_query, spdbComplex->select, spdb_select, referer: http:/xxxxxx.xxxxxx.xxxxx.com/forums/
Offline
start with the first part of the error... lets look at you db structure for the sfposts column... check the indexes on the table... it should have sfposts with FULLTEXT type on it...
can you verify please?
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr Papa said
start with the first part of the error... lets look at you db structure for the sfposts column... check the indexes on the table... it should have sfposts with FULLTEXT type on it...can you verify please?
this is out side of my knowledge base, where would I look for this? In admin or myphp?
Offline
phpmyadmin... or other db tool your host might provide (named one is most popular)... look at the sfposts table.. then its structure... then its indexes to see if it has fullttext type...
Visit Cruise Talk Central and Mr Papa's World
Offline
yes, that was step 2... then you need to view the indexes... typically under all that stuff will be a small link to indexes to expand them... check the post_content for fulltext...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)