Search button isn't working.

[MagicPID]

I have no idea what happened, this error appeared out of no where.

Happens when you try to search, any ideas?

Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT tagsearch.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM tagsearch AS tagsearch
INNER JOIN tag AS tag ON (tagsearch.tagid = tag.tagid)
WHERE tagsearch.dateline > 1349117971
GROUP BY tagsearch.tagid, tag.tagtext
ORDER BY searchcount DESC
LIMIT 70;

MySQL Error : Incorrect key file for table 'tagsearch'; try to repair it
Error Number : 1034
Request Date : Wednesday, October 31st 2012 @ 10:59:31 PM
Error Date : Wednesday, October 31st 2012 @ 10:59:31 PM
Script : -----/forums/search.php
Referrer : -----
IP Address : -----
Username : -----
Classname : vB_Database
MySQL Version : 5.1.65-cll

[Lynne]

And did you do as the error suggests and try to repair the table?

[MagicPID]

Originally Posted by Lynne

And did you do as the error suggests and try to repair the table?

Yes, I did. It said the table is corrupt

[Lynne]

3 ways to repair a database

===================
1. you need to upload tools.php from your vB zip file to your /admin directory and run this url

yourdomain.com/admin/tools.php

and click [Repair Tables]

2. or using mysqlcheck repair for 3.23.38 and above

i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:

mysqlcheck -r -u mysqlusername -p databasename

3. or via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

myisamchk -r -u root -p databasename

option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.

If none of those work, you will need to contact your host for help.

[MagicPID]

The table is showing as 0kb, is there a way I can re-upload just this table?

Better yet, can I just remove the tag feature from search so it isn't an issue? If it is what I think it is (most searched tags) it isn't really used much.

[Lynne]

If you want, you may just delete the table and recreate it. The schema is in the /install/mysql-schema.php file.

[MagicPID]

Originally Posted by Lynne

If you want, you may just delete the table and recreate it. The schema is in the /install/mysql-schema.php file.

I appreciate your help... I'm getting this error now

[Lynne]

You don't run that file. Open it and you will find the query to create the table.

[MagicPID]

Originally Posted by Lynne

You don't run that file. Open it and you will find the query to create the table.

Ugh, I'm still having issues.

When I try re-creating the table using the query in mysql-schema.php I just keep getting a query error.

[Lynne]

And what is the exact query you are trying to run (please use the code tags)? And what is the exact error you are getting when running it? And do you have a table prefix defined in your config.php file?