Page 1 of 1
Fulltext index for search ...
Posted: Fri Oct 07, 2005 4:06 pm
by Lux
Hi,
we get an error in our fresh installed (version 0.8.5) dog blog:
Code: Select all
CREATE FULLTEXT INDEX entry_idx on serendipity_entries (title,body,extended)
Because I am not the admin of my providers database system, I did:
Code: Select all
ALTER TABLE `serendipity_entries` ADD FULLTEXT (
`title` ,
`body` ,
`extended`
);
I hope, that is the same.
Greetings
Dirk
Re: Fulltext index for search ...
Posted: Fri Oct 07, 2005 4:42 pm
by garvinhicking
Yes, the ALTER TABLE command should basically do the same.
Best regards,
Garvin
Re: Fulltext index for search ...
Posted: Fri Oct 07, 2005 4:47 pm
by Lux
garvinhicking wrote:Yes, the ALTER TABLE command should basically do the same.
Maybe you put the ALTER TABLE statement into the error message. Because you need no administrator priviledge to do that.
Dirk
Re: Fulltext index for search ...
Posted: Fri Oct 07, 2005 4:54 pm
by garvinhicking
It has nothing to do with administrator privilege, only with MySQL privileges.
Each action (SELECT, CREATE, DELETE, INSERT, INDEX, UPDATE, GRANT, ..) has its own privilege for MySQL. Usually those privileges apart from GRANT are all set for a MySQL user account.
In your case, your mysql user is missing the "INDEX" privilege. However this is a very common privilege that very seldom is not set for user accounts. It makes to sense to disallow INDEX privileges usually, because setting an index can only make things better and not worse.
Serendipity thus uses CREATE INDEX on several occasions, not only in the given message -- and on most of all MySQL setups (and 100% of setups I have personally seen) the INDEX privilege is given for the user.
So you should better contact your sysadmin and ask him, why your mysql user has no INDEX privilege, and that this is quite common...
Or what error message are you getting when you want to execute the "CREATE FULLTEXT..." query?
Best regards,
Garvin
Re: Fulltext index for search ...
Posted: Fri Oct 07, 2005 5:11 pm
by Lux
garvinhicking wrote:Or what error message are you getting when you want to execute the "CREATE FULLTEXT..." query?
#1142 - INDEX command denied to user: 'xxx' for table 'serendipity_entries'
Alter Table works.
Dirk
Re: Fulltext index for search ...
Posted: Fri Oct 07, 2005 5:39 pm
by garvinhicking
Lux wrote:garvinhicking wrote:Or what error message are you getting when you want to execute the "CREATE FULLTEXT..." query?
#1142 - INDEX command denied to user: 'xxx' for table 'serendipity_entries'
Okay, then all applies to you what I've written. Contact your sysadmin and ask him for a single reason why your user XXX has no "INDEX" privilege. This does not make sense at all.
It's like giving you an FTP account that can only write files and not download files.
Regards,
Garvin
Re: Fulltext index for search ...
Posted: Fri Oct 07, 2005 5:41 pm
by Lux
garvinhicking wrote:Okay, then all applies to you what I've written. Contact your sysadmin and ask him for a single reason why your user XXX has no "INDEX" privilege. This does not make sense at all.
I will do!
Regards and thanks for your support
Dirk
Re: Fulltext index for search ...
Posted: Fri Oct 07, 2005 5:52 pm
by garvinhicking
Great -- and please report back here, I would really like to know the reasoning of a sysadmin behind not allowing this, but allowing ALTER TABLE.
Best regards,
Garvin
Re: Fulltext index for search ...
Posted: Fri Oct 07, 2005 7:18 pm
by Lux
garvinhicking wrote:Great -- and please report back here, I would really like to know the reasoning of a sysadmin behind not allowing this, but allowing ALTER TABLE.
It was a configuration error of the provider.
Regards
Dirk
Re: Fulltext index for search ...
Posted: Sun Oct 09, 2005 10:57 pm
by garvinhicking
Thanks for this feedback. Great to know that there really is no reason why it shouldn't be allowed.
Best regards,
Garvin