Search error Could not create temp table

[kbalkcum]

The search function on my store has generated the error "Could not create temp table" since I upgraded to v 9. I do have the product search field checked on my pages and also the Index for search box checked in the Utilities/Publish section. I am about to upgrade to v10 but want to see if there is a problem with my code:

<form name="productsearch" class="productsearch" action="http://www.theinternationalcupboard.com/cgi-bin/shopsite/sc/productsearch.cgi" method=post >
<div align="right">
<input type=text name="search_field" size=25>
<input type=hidden name="storeid" value="*48795841a1681dfb82bb7d4cbdde774afceeae3c78ab590f0a71965bbd0bb1ea34acd33377fc">
<input type=submit name=submit value="Search">
<!-- <input type=image src="http://www.theinternationalcupboard.com/shopsite-images/en-US/buttons/defaults/Search.gif" align=top border=0 name="/buttons/defaults/Search.gif" alt="/buttons/defaults/Search.gif">
-->
</div>
</form>

Any help would be much appreciated.

[Jim]

Does the problem occur if you use one of the ShopSite provided templates?

[kbalkcum]

Yes, I tried the "Column" template and it came up with the same error when I tried using the search function.

[loren_d_c]

Do you have Search Logging enabled under Preferences -> Search Settings -> Search Logging -> Configure? If so, try disabling that and see if that helps.

-Loren

[kbalkcum]

Search Logging is disabled, so that isn't the problem. Thanks for the suggestion though. Any other ideas?

[Jim]

If you go to Utilities > Database and do a Check Database what do you get?

[kbalkcum]

It shows OK. Here is a copy of what it shows:
shopsite_db OK Tue Nov 25 11:11:03 2008 5219328 OK Sat Feb 16 14:27:45 2008 4892672