WP Database Show Index Error

Resolved

(@xforce)

I have turned on

define('WP_DEBUG_LOG', true);
define('WP_DEBUG', true);

in my wp-config.php and when I try to activate short-url plugin I am getting

Plugin could not be activated because it triggered a fatal error.
WordPress database error: []
SHOW INDEX FROM wp_pluginSL_shorturl;

Any idea why?

https://wordpress.org/plugins/shorten-url/

Viewing 15 replies - 1 through 15 (of 18 total)

1 2 →

Sed Lex
(@sedlex)

12 years ago

Hum … You have a normal MySQL database ? The idea of that line is to test if an index exist in that table and then delete it if it exists …

Sed Lex
(@sedlex)

12 years ago

Could you type this command directly in your database to have the full error ?

Thread Starter xforce
(@xforce)

12 years ago

No errors, I tried to run it via phpmyadmin and heidisql. No errors in both of them.

Sed Lex
(@sedlex)

12 years ago

Therefore it is very strange … And if you try to reactivate the plugin ? Sometime WP generates some random error

Thread Starter xforce
(@xforce)

12 years ago

Tried many times, but when I turn off the WP_DEBUG flags, it works. I tried to debug it but didn’t found the reason so I posted it here. I also noticed one error.

Its in line 170 core.class.php
add_option("db_version", $db_version);

I have added below line 161 core.class.php
global $db_version;

to fix it.

Sed Lex
(@sedlex)

12 years ago

You are definitely right … it is a bug : I will release a new version in a couple of weeks to correct that.

Thanks a lot.

The “funny” thing is that the plugin is out for years and no one complain for that bug 🙁

Thread Starter xforce
(@xforce)

12 years ago

No problem. Any idea why I was getting the above error. I tried to debug it but not able to resolve it.

Sed Lex
(@sedlex)

12 years ago

When you add global $db_version; it does not solve the issue ?

Thread Starter xforce
(@xforce)

12 years ago

This one is solved. I am asking about the show index one.

Sed Lex
(@sedlex)

12 years ago

Oh sorry … I believed that you had only one error !

Definitely I do not know why WP generates an error while MySQL does not !!

Sed Lex
(@sedlex)

12 years ago

Do you have any index for that table ? If so, could you delete the index ?
I have tried the same configuration without any error …

Thread Starter xforce
(@xforce)

12 years ago

No there are not any indexes for that table. Ok so I think no harm in that error.

Thanks for your help

Sed Lex
(@sedlex)

12 years ago

There is a harm here if you could not activate the plugin no ?

Thread Starter xforce
(@xforce)

12 years ago

Yes when the debug flags are ON, I can’t activate the plugin. I have to turn them off and then ON again.

Sed Lex
(@sedlex)

12 years ago

IT IS STRANGE !!!
I do not like it anyway …

Viewing 15 replies - 1 through 15 (of 18 total)

1 2 →

The topic ‘WP Database Show Index Error’ is closed to new replies.

Tags