Help|Bug in the Search

[Onone.]

Hello, please helpme for fixed bug!

when i'm trying to do a Search I get this message:

http://img385.imageshack.us/img385/4972/ssfsfow6.jpg

notes*
My Version now is 3.7.2

[copiertalk]

What is the error that is reported?

Right click the page > view source.

At the bottom of the page copy and paste the error.

[Onone.]

the error is:

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT
DISTINCT thread.threadid
FROM thread AS thread

INNER JOIN post AS post ON(thread.threadid = post.threadid )
WHERE MATCH(post.title, post.pagetext) AGAINST ('NBA[') AND thread.forumid NOT IN (0,17)
LIMIT 500;

MySQL Error : Can't find FULLTEXT index matching the column list
Error Number : 1191
Request Date : Wednesday, June 25th 2008 @ 12:21:18 AM
Error Date : Wednesday, June 25th 2008 @ 12:21:18 AM
Script : http://onone.co.il/search.php?do=process
Referrer : http://onone.co.il/search.php
IP Address : ****
Username : ****
Classname : vb_database
MySQL Version : 4.1.22-standard


and tnx :)

[Onone.]

This is very important, a lot of Members are unhappy, someone can help me plz?

[Zachery]

Your missing your fulltext indicie on your search.

AdminCP> vBulletin Options > Search Options > Disable and re-enable the fulltext search.

[Wayne Luke]

Run these two queries:

ALTER TABLE vb_post ADD FULLTEXT INDEX (title,pagetext)
ALTER TABLE vb_thread ADD FULLTEXT INDEX (title)

If you use a prefix that isn't vb_ then you need to change that to the prefix specified in your config.php file. If no prefix is specified then delete those characters.

[Onone.]

first message:
I didnt find what you said, what to do?

second message:

i get this error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

what to do?
and tnx.

[Wayne Luke]

Again we need to see the entire error.

[Onone.]

Print screen will be good?

[Wayne Luke]

yes.

[Onone.]

here:
http://img525.imageshack.us/img525/7096/hhhia5.jpg

[Steve Machol]

There is no error there. We need to see the real error.

[Onone.]

yon mean to this one?
http://img385.imageshack.us/img385/4972/ssfsfow6.jpg

[Steve Machol]

That does not show the complete error. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.

[Onone.]

here:
Your submission could not be processed because a security token was missing.<br />
<br />
If this occurred unexpectedly, please <a href="{1}">inform the administrator</a> and describe the action you performed before you received this error.

[Steve Machol]

Please see this thread for the steps to resolve this error in 3.7:

http://www.vbulletin.com/forum/showthread.php?t=268862

[Onone.]

i get this right now:
Table 'onone123_forum.vb_post' doesn't exist

[Onone.]

i understand that maybe there One possibility is i did not upload all the 3.7.0 files when you upgraded.
how do i fix it?

[Steve Machol]

Either your database does not exist, it is missing the post table, or you are using a table prefix and you need to add that prefix to the appropriate section in your includes/config.php file.

Check the database to see if that table is there and to see if you are using a table prefix.

[Onone.]

ok, i did it, but when im searching i get only few message.
more problems is in the quick search, i get this message:
Your submission could not be processed because a security token was missing.<br />
<br />
If this occurred unexpectedly, please <a href="{1}">inform the administrator</a> and describe the action you performed before you received this error.

[Steve Machol]

Answered in post #16.

[Onone.]

i didnt found it.
link?

[Steve Machol]

http://www.vbulletin.com/forum/showpost.php?p=1585834&postcount=16

[Onone.]

i did all of the thing you said in the thread you give me, and still its dosnt work.
what to do?

[Steve Machol]

You cannot get that error if you follow all of those instructions. Try again.

[Onone.]

ok, one minute.

[Onone.]

its dosnt work.

[Steve Machol]

What is the URL to your forums?

[Onone.]

http://www.onone.co.il/index.php

[Steve Machol]

That doesn't look anything like the default vB. In addition you are running third-party add-ons. You need to follow ALL of the instructions here:

http://www.vbulletin.com/forum/showthread.php?t=268862

[Onone.]

i Create a new style that only admin can see him.
and steel its dosnt work.