vb.org Archive - Add-On Releases

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Add-On Releases - [AJAX] Live Search (https://vborg.vbsupport.ru/showthread.php?t=235461)

on my Style i must do this:

in headinclude

after line {vb:raw template_hook.headinclude_javascript}

put this:

<link rel="stylesheet" type="text/css" href="{vb:raw vbcsspath}lsa_css.css" />
<script type="text/javascript" src="clientscript/ajax_live_search_init.js?v={vb:raw vboptions.simpleversion}"></script>

it was does not work else, i dont know

Does not work for me. I can enter words, but no live search, just normal search

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.

Thank you for this feature, it does however need to search for the string even if it was in-between some other words.

Example (I want to buy a dog)
Current Search: (to buy a) = No results
What needs to be done is get the search engine to look for the string in between other words.

Great work however :)

Sorry but the search dont find words in the middle or end of an text

Fixed, turned the Fulltext search of in the Ajax Live search settings

Works not with vB Social have any Fixx??

Please how to exclude some categories or forums from the search?

doesnt work on 4.2.2

edit: disable fulltext seach.

Hello..

sometimes I get a db error:

Code:

Datenbankfehler 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 (' +verbindun' IN BOOLEAN MODE)

                                AND thread.forumid IN (10lsasort=lastpost)

                                AND thread.forumid NOT IN (0,18,52,6,16,17)

                                AND thread.lastpostid > 0

                                ORDER BY thread.lastpost DESC

                                LIMIT 50;



MySQL-Fehler  : Unknown column '10lsasort' in 'where clause'

Fehler-Nr.    : 1054

Fehler-Zeit   : Thursday, 23.04.2015 @ 20:52:15

Datum         : Thursday, 23.04.2015 @ 20:52:15

Skript        : http://www.sps-forum.de/ajaxlivesearch.php?do=search

Referrer      : http://www.sps-forum.de/

IP-Adresse    : 

Benutzername  :

Klassenname   : 

MySQL-Version :

Code:

Datenbankfehler 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 (' +troggel' IN BOOLEAN MODE)

                                AND thread.forumid IN (10lsasort=lastpost)

                                AND thread.forumid NOT IN (0,18,52,6,16,17)

                                AND thread.lastpostid > 0

                                ORDER BY thread.lastpost DESC

                                LIMIT 50;



MySQL-Fehler  : Unknown column '10lsasort' in 'where clause'

Fehler-Nr.    : 1054

Fehler-Zeit   : Sunday, 19.04.2015 @ 17:20:11

Datum         : Sunday, 19.04.2015 @ 17:20:11

Skript        : http://www.sps-forum.de/ajaxlivesearch.php?do=search

Referrer      : http://www.sps-forum.de/

IP-Adresse    : 

Benutzername  :

Klassenname   : 

MySQL-Version :

Hello,

another DB Error:

Code:

Datenbankfehler in vBulletin 4.2.3:



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 (' +BremswegLive +Search' IN BOOLEAN MODE)

                                AND thread.forumid IN (28lsasort=lastpost)

                                AND thread.forumid NOT IN (0,18,52,6,16,17)

                                AND thread.lastpostid > 0

                                ORDER BY thread.lastpost DESC

                                LIMIT 50;



MySQL-Fehler  : Unknown column '28lsasort' in 'where clause'

Fehler-Nr.    : 1054

Fehler-Zeit   : Tuesday, 29.09.2015 @ 15:18:25

Datum         : Tuesday, 29.09.2015 @ 15:18:25

Skript        : http://www.sps-forum.de/ajaxlivesearch.php?do=search

Referrer      : http://www.sps-forum.de/

IP-Adresse    : 

Benutzername  : caveman

Klassenname   : vB_Database

MySQL-Version :

Code:

Datenbankfehler in vBulletin 4.2.3:



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 (' +Live +Search' IN BOOLEAN MODE)

                                AND thread.forumid IN (28lsasort=lastpost)

                                AND thread.forumid NOT IN (0,18,52,6,16,17)

                                AND thread.lastpostid > 0

                                ORDER BY thread.lastpost DESC

                                LIMIT 50;



MySQL-Fehler  : Unknown column '28lsasort' in 'where clause'

Fehler-Nr.    : 1054

Fehler-Zeit   : Tuesday, 29.09.2015 @ 15:18:21

Datum         : Tuesday, 29.09.2015 @ 15:18:21

Skript        : http://www.sps-forum.de/ajaxlivesearch.php?do=search

Referrer      : http://www.sps-forum.de/

IP-Adresse    : 

Benutzername  : caveman

Klassenname   : vB_Database

MySQL-Version :

how can I fix that?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04215 seconds Memory Usage 1,756KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: