Thread: Add-On Releases - [AJAX] Live Search
View Single Post
  #224  
Old 01-02-2014, 07:05 AM
ckgb ckgb is offline
 
Join Date: Oct 2007
Posts: 125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Got it to work on 4.2.2. Had to add a couple things to header and headerinclude. Tested in FF, IE and Chrome. Works the same everywhere but not all the way.

Works by topic name great. Option where search by an individual word inside posts was no good. Comes back empty every time. The following error comes up in the error log:

Code:
Database error in vBulletin 4.2.2:

Invalid SQL:

                                SELECT thread.threadid, thread.lastpostid, thread.forumid AS tforumid, thread.title AS ttitle, forum.title AS ftitle
                                FROM thread AS thread
                                LEFT JOIN forum AS forum ON(thread.forumid = forum.forumid)
                                WHERE MATCH(thread.title) AGAINST (' +seatt' IN BOOLEAN MODE)

                                AND thread.forumid NOT IN (0)
                                AND thread.lastpostid > 0
                                ORDER BY thread.lastpost DESC
                                LIMIT 50;

MySQL Error   : The used table type doesn't support FULLTEXT indexes
Error Number  : 1214
Request Date  : Thursday, January 2nd 2014 @ 07:55:35 AM
Error Date    : Thursday, January 2nd 2014 @ 07:55:35 AM
Script        : http://www.sitename.com/ajaxlivesearch.php?do=search
Classname     : vB_Database
MySQL Version : 5.5.34-cll
Also search should probably include blogs and groups.

Great potential but had to uninstall.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01210 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