WordPress database error

  • I’m trying to write my own little plugin and I have tested it on several of my WP, but when I installed it on my last WP (the one I really want to use it) I got this message:

    WordPress database error: [Too many keys specified; max 64 keys allowed]
    ALTER TABLE wp_Counterize ADD INDEX ( timestamp );

    I don’t think it has any thing to do with my specific plugin.

    Anyone know what to do?

Viewing 5 replies - 1 through 5 (of 5 total)

  • You’ve hit a limit on the number of keys allowed by the MySQL server you are trying to use. That is, you are using too many indexes. You can change the value but only recompiling MySQL. Unless you have the ability to do that, or can talk your host into it, you are going to have to rework your indexes probably.

    Thread Starter Mikael Boldt

    (@boldt)

    I have no Idea I’m only a user.
    My plugin is not establishing any new tables in the database only looking into 2 tables.

    Is it the plugin mentioned in the error (Counterizeii) that is establishing the error?
    or is it a coincident? (order of plugins installed)?

    I had assumed that the plugin named was your plugin. Disable Counterize and see what happens.

    Thread Starter Mikael Boldt

    (@boldt)

    if I deactivate Counterizeii or any other plugin and then activate my plugin nothing happens – meaning no warning occurs.

    It is only a warning all the plugins seems to be working

    Thread Starter Mikael Boldt

    (@boldt)

    I have addressed this problem on Counterizeii webpage
    ( https://www.navision-blog.de/counterize-ii-english/ )
    and they have now found a programme error.
    “The problem is a small typo in the file “counterize_install.php”. If you open the file and you go to the end you will find twice something like:
    if($minorVersion < …

    you have to change them to:
    if($MinorVersion < …

    please note the “M” of “minor” now capital.
    “

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WordPress database error’ is closed to new replies.