Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: agridoc on February 13, 2005, 04:58:28 PM

Title: Search error
Post by: agridoc on February 13, 2005, 04:58:28 PM
When I try search I get this message


2: mysql_query() [<a href='http://www.mysql.com/doc'>http://www.mysql.com/doc</a>]: Unknown table 'smf_matches'
File: /.../Sources/Search.php
Line: 390


Could anyone help?

Kind regards

agridoc
Title: Re: Search error
Post by: Oldiesmann on February 13, 2005, 10:11:06 PM
Disable temporary tables (Admin -> Edit Features and Options) or ask your host to allow you to create them.
Title: Re: Search error
Post by: agridoc on February 14, 2005, 04:37:07 AM
OK, it works with temporary tables disabled.

I start to like SMF a lot. Excellent possibilities and excellent support too.

Thanks a lot.

agridoc

P.S. I might ask in the future about temp file creation, I can create files through my MySQL database manager that the server provides but that will have to wait.
Title: Re: Search error
Post by: [Unknown] on February 14, 2005, 04:39:31 AM
Quote from: agridoc on February 14, 2005, 04:37:07 AM
P.S. I might ask in the future about temp file creation, I can create files through my MySQL database manager that the server provides but that will have to wait.

You need the "CREATE TEMPORARY TABLES" privilege, or this functionality won't work.  Strangely, you're getting a very different error than most people get, which leads me to believe /tmp is probably not writable.

-[Unknown]
Title: Re: Search error
Post by: Oldiesmann on February 14, 2005, 10:00:53 AM
Yeah... I was wondering why it got that far without screaming about not being able to create temporary tables...