search error after SMF 1.0 RC upgrade

[bluevoodu]

fixed?



†B†V†

[MrCue]

Could be that you need permission to make temporary tables.

[[Unknown]]

A search for 'Access denied for user' comes up with a few results.

-[Unknown]

[bluevoodu]

A search for 'Access denied for user' comes up with a few results.

-[Unknown]

argh lol.... I did search for about 15 + minutes

I don't think my database permissions have changed.  Before the SMF 1.0 upgrade everything (including the search) was working.

I'll give it a shot though.

†B†V†

[Ben_S]

The way search works has changed in RC1.

[[Unknown]]

You can, as posted in one of those topics probably, use the old Search.php from Beta 5 Public.

-[Unknown]

[bluevoodu]

well... I'll try the support 1st (with my host) and see what I can do on that end.

If not, I can see about the beta 5 search.

thanks for your help!
†B†V†

[bluevoodu]

here is what my host said:

We ran a query to list the permissions for your database user. 

Current Permisions are :
Select  Y
Insert  Y
Update  Y
Delete  Y
Create  Y
Drop    Y
Index   Y
Alter   Y
Lock Tables     Y
Create tmp Table        Y

So that does not seem to be the problem.  Any other suggestions?

†B†V†

[Ben_S]

Tell your host mysql is broken then, since it is telling you permission is denied for this query

         CREATE TEMPORARY TABLE {$db_prefix}matches (
            ID_TOPIC mediumint( unsigned NOT NULL default '0',
            ID_FIRST_MSG int(10) unsigned NOT NULL default '0',
            numReplies int(11) NOT NULL default '0',
            is_subject tinyint(3) unsigned NOT NULL default '0',
            PRIMARY KEY (ID_TOPIC)
         ) TYPE=HEAP", __FILE__, __LINE__);

[[Unknown]]

Tell your host mysql is broken then, since it is telling you permission is denied for this query

         CREATE TEMPORARY TABLE {$db_prefix}matches (
            ID_TOPIC mediumint( unsigned NOT NULL default '0',
            ID_FIRST_MSG int(10) unsigned NOT NULL default '0',
            numReplies int(11) NOT NULL default '0',
            is_subject tinyint(3) unsigned NOT NULL default '0',
            PRIMARY KEY (ID_TOPIC)
         ) TYPE=HEAP", __FILE__, __LINE__);

Rather, that query with the {$db_prefix} part replaced with smf_ and no ", __FILE__, __LINE__);.  Or:

         CREATE TEMPORARY TABLE smf_matches (
            ID_TOPIC mediumint( unsigned NOT NULL default '0',
            ID_FIRST_MSG int(10) unsigned NOT NULL default '0',
            numReplies int(11) NOT NULL default '0',
            is_subject tinyint(3) unsigned NOT NULL default '0',
            PRIMARY KEY (ID_TOPIC)
         ) TYPE=HEAP;

-[Unknown]

[bluevoodu]

well.,..... not sure why... but it decided to start working this morning.

I appreciate your help...
I will keep this and if the error happens again, talk with the host about what you guys were talking about.

BTW... if MySQL was "broken", wouldn't the whole database not work at all?

†B†V†

[Ben_S]

well.,..... not sure why... but it decided to start working this morning.

Possibly you never had the permissions to start off with and when you asked your host added them but never reloaded MySQL to let the permissions take effect and it has sonce reloaded hence it now working.

BTW... if MySQL was "broken", wouldn't the whole database not work at all?
[/quote

Create temporary tables is only needed for search so only search would fail.