The CREATE INDEX problem   All articles   Auf Facebook posten http://www.openphpnuke.com/system/article/index.php?opnparams=CntdOAI3CmdWMw

OPN DEV NewsOriginally written by hombergs , translated by xtreme

Who among the Betatesters has encountered problems with CREATE INDEX on his webspace?
I believe, I’ve come up with a solution here.


If you are creating an index and receive the following error (access denied for user: 'XXX@YYY' to database 'ZZZ'), please go to your PHPMyAdmin if you can access that one, and try this: write
ALTER TABLE prefix_users ADD INDEX idxusersxx(uname)
and execute it. If the line is executed without mistakes, write:
ALTER TABLE prefix_users DROP INDEX idxusersxx
and execute that one, too.
In case you receive an error with the first ALTER TABLE , please mail me or send me a PM.
Notice that prefix_ has to be replaced with the prefix for the table you specified.


Posted by manne on 2003-04-24 23:37:03  (10955 * reads) 

  All articles   Auf Facebook posten http://www.openphpnuke.com/system/article/index.php?opnparams=CntdOAI3CmdWMw

Comments

Threshold
The comments are owned by the poster. We are not responsible for their content.


 
Page took 0.07089 seconds to load