Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Jul 2018, 14:07
itilm's Avatar
itilm itilm is offline
 
Join Date: Aug 2011
Location: Karachi
Real name: smartyounus
Database error after server move

I am getting data base error on new thread

I have run Rebuild Search Index But result was same Please help me

If i Select Remove Fulltext Indexes to NO Every thing start working fine

can any one also explain what Fulltext indexes do ?

nvalid SQL:

SELECT thread.threadid, MATCH(thread.title) AGAINST ('Assalam o alikum') AS score
FROM thread AS thread

WHERE MATCH(thread.title) AGAINST ('Assalam o alikum')
AND thread.open <> 10


LIMIT 5;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Saturday, July 7th 2018 @ 06:50:45 AM
Error Date : Saturday, July 7th 2018 @ 06:50:45 AM
Script : http://www.domain.com/newthread.php?do=postthread&f=49
Referrer : http://www.domain.com/newthread.php?do=newthread&f=49
IP Address :
Username : username
Classname : vB_Database_MySQLi
MySQL Version : 10.2.16-MariaDB
Server :
User Agent :


Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1254
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 479
#2 vB_Database->query_read_slave() called in [path]/includes/functions_search.php on line 368
#3 fetch_similar_threads() called in [path]/includes/class_dm_threadpost.php on line 1174
#4 vB_DataManager_Thread->pre_save() called in [path]/includes/class_dm_threadpost.php on line 1614
#5 vB_DataManager_Thread_FirstPost->pre_save() called in [path]/includes/functions_newpost.php on line 468
#6 build_new_post() called in [path]/newthread.php on line 216
__________________
Pakistan's It education Forum
Come and join us
www.itilm.com
Reply With Quote
  #2  
Old 08 Jul 2018, 16:10
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Real name: Brandon
Add FULLTEXT to that column


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

enter your table and column names and try this

always make a backup before doing any work
__________________

I've been supporting vBulletin and Wordpress for over a decade, contact me for any assistance.
Interested in DNA testing or drug testing information, look here.
Reply With Quote
  #3  
Old 08 Jul 2018, 16:17
snakes1100 snakes1100 is online now
 
Join Date: Dec 2001
Real name: Anthony
Verify the fulltext indexes exist in phpmyadmin on the post & thread tables.

Remove the fulltext index in phpmyadmin
Add the fulltext index manually in phpmyadmin or vb's admincp
Reply With Quote
  #4  
Old 08 Jul 2018, 19:18
itilm's Avatar
itilm itilm is offline
 
Join Date: Aug 2011
Location: Karachi
Real name: smartyounus
Originally Posted by Brandon Sheley View Post
Add FULLTEXT to that column


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

enter your table and column names and try this

always make a backup before doing any work
can you please provide more information , i am unaware of this, how can i do this
__________________
Pakistan's It education Forum
Come and join us
www.itilm.com
Reply With Quote
  #5  
Old 08 Jul 2018, 21:52
DCD.RB DCD.RB is offline
 
Join Date: Jan 2011
Originally Posted by itilm View Post
can you please provide more information , i am unaware of this, how can i do this
It's a PHPMyAdmin SQL Query.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 10:10.

Layout Options | Width: Wide Color: