Search
Membership
Login:
Membership:
- New Today: 0
- New Yesterday: 0
- Overall: 3242
- Latest: GoodNews
Birthdays:
RomanasRJS
People Online:
- Guests: 246
- Total: 246
The CREATE INDEX problem http://www.openphpnuke.com/system/article/index.php?opnparams=CntdOAI3CmdWMw
Originally 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.
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 (11801 * reads)
Comments
The comments are owned by the poster. We are not responsible for their content.