Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-02-2013, 11:17 PM
yotsume's Avatar
yotsume yotsume is offline
 
Join Date: Dec 2006
Posts: 844
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database Error Number: 1191 (vBulletin 3.8.0)

I moved my site from one host to a new one. Import of the database went fine. Everything works except for similar thread searches. It gives a database error.

I receive database errors when performing searches for similar threads.

Also I receive the following database error shown below in my admincp when I try to update counters: "Rebuild Similar Threads".

I have tried a number of solutions but none have worked so far.
I tried:
-Changing the search type (didn't work)
-Emptying and Rebuilding Search Index (didn't work)


Here is my database error:

Code:
Database error in vBulletin 3.8.0:

Invalid SQL:

                        SELECT thread.threadid, MATCH(thread.title) AGAINST ('Training') AS score
                        FROM vb_thread AS thread
                       
                        WHERE MATCH(thread.title) AGAINST ('Training')
                                AND thread.open <> 10
                                 AND thread.threadid <> 20
                               
                        LIMIT 5;

MySQL Error   : Can't find FULLTEXT index matching the column list
Error Number  : 1191
Request Date  : Monday, December 2nd 2013 @ 01:41:22 PM
Error Date    : Monday, December 2nd 2013 @ 01:41:22 PM
Script        : http://www.mydomain.com/emr/admincp/misc.php?do=updatesimilar
Referrer      : http://www.mydomain.com/emr/admincp/misc.php?do=chooser
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.91-community

What can I do to my database to fix this error? I can not make and new threads on my site.

Can anyone help me to fix the error in my database please.

--------------- Added [DATE]1386029989[/DATE] at [TIME]1386029989[/TIME] ---------------

My second error is when I try to make a new thread. I get this error:

Code:
Database error in vBulletin 3.8.0:

Invalid SQL:

			SELECT thread.threadid, MATCH(thread.title) AGAINST ('test post') AS score
			FROM vb_thread AS thread
			
			WHERE MATCH(thread.title) AGAINST ('test post')
				AND thread.open <> 10
				
				
			LIMIT 5;

MySQL Error   : Can't find FULLTEXT index matching the column list
Error Number  : 1191
Request Date  : Monday, December 2nd 2013 @ 05:05:50 PM
Error Date    : Monday, December 2nd 2013 @ 05:05:52 PM
Script        : http://www.mydomain.com/emr/newthread.php?do=postthread&f=7
Referrer      : http://www.mydomain.com/emr/newthread.php?do=newthread&f=7
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.91-community
What do I need to do to my database to fix this???
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:18 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05148 seconds
  • Memory Usage 2,301KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete