Thread: Private Messages Enhancements - User PM Search
View Single Post
  #119  
Old 11-02-2007, 10:23 AM
Acedeal Acedeal is offline
 
Join Date: Jul 2005
Location: Texas
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Applied the update, and it still does not support mysql with full text searches enabled

Any ideas on how to get this to work with mysql and full text ??
MySQL Error : The used table type doesn't support FULLTEXT indexes

Code:
Database error in vBulletin :

Invalid SQL:

			SELECT pm.*, pmtext.*
				, icon.title AS icontitle, icon.iconpath
			FROM vb3_pm AS pm
			LEFT JOIN vb3_pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
			LEFT JOIN vb3_icon AS icon ON(icon.iconid = pmtext.iconid)
			WHERE pm.userid=94
			  AND MATCH(pmtext.title, pmtext.message) AGAINST ('+Larry' IN BOOLEAN MODE) 
			ORDER BY pmtext.dateline DESC;

MySQL Error  : The used table type doesn't support FULLTEXT indexes
Error Number : 1214
Date         : Friday, November 2nd 2007 @ 06:13:13 AM
Script       : http://forum.xxxx.com/private.php?pmsearch=1
Referrer     : http://forum.xxxx.com/private.php?pmsearch=1
IP Address   : 97.100.1.1
Username     : ntbxxx
Classname    : vB_Database
thanks!.. Looks like a great mod, just can not get it to work when forums uses fulltext instead of the default vb search.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01075 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete