cancel
Showing results for 
Search instead for 
Did you mean: 

Movable Type 4.23: INDEX command denied

drbenway
Dabbler
Posts: 13
Registered: ‎21-01-2009

Movable Type 4.23: INDEX command denied

Hi all,
I'm trying to set up the latest version of Movable Type on CCGI, but apparently I don't have permission to use the INDEX command in MySQL. I'm not too au fait with the workings of MySQL, would having this command enabled be a security risk? If not, could we get it enabled? Or does anyone have a workaround at all?
For reference, the full list of commands MT needs is apparently:
grant
lock tables
drop
create temporary tables
update
create
alter
index
select
references
insert
delete
1 REPLY 1
jah
Grafter
Posts: 38
Thanks: 2
Registered: ‎09-06-2007

Re: Movable Type 4.23: INDEX command denied

I had an issue installing Movable Type too.  During the process, I got [tt]access denied for CREATE INDEX[/tt] errors.  I managed to create some of these indexes using phpMyAdmin and the MT error messages, but this was taking too long so I altered the source code instead.
I modified the file mt/lib/MT/ObjectDriver/DDL.pm on line 300 where I changed the following:
push @stmts, "CREATE INDEX ${table_name}_$name ON $table_name (${field_prefix}_$name)";

to this:
push @stmts, "ALTER TABLE $table_name ADD INDEX ${table_name}_$name (${field_prefix}_$name)";

and then began the installation afresh.  It worked like a charm.