![]() |
Can't find FULLTEXT index matching the column list Hello I move my DB from one server to a new server. Now I receive a lot of errors with search script. I find at vbulletin.com and try to solve it* go into AdminCP under vBulletin Options -> Search Type and switch to the vBulletin search and then back to the Fulltext search* but the problem follows. I try to delete de indexes and make a ALTER TABLE vb_post ADD FULLTEXT INDEX (title*pagetext) ALTER TABLE vb_thread ADD FULLTEXT INDEX (title) But the problem follows I need help* please. A sample of error: Code: Database error in vBulletin 3.8.1: Invalid SQL: SELECT DISTINCT thread.threadid* thread.forumid* post.userid FROM vb_thread AS thread INNER JOIN vb_post AS post ON(thread.threadid = post.threadid ) WHERE MATCH(post.title* post.pagetext) AGAINST ('moon') AND thread.forumid NOT IN (0*79*82*59*30*13) AND post.visible = 1 LIMIT 300; MySQL Error : Can't find FULLTEXT index matching the column list Error Number : 1191 And a pic of the indexes of vb_thread db. Any help? Attached Images http://www.vbulletin.com/forum/images/attach/png.gif Imagen 12.png‎ (33.9 KB) |
| الساعة الآن 01:05 PM |
Powered by vBulletin® Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir