notification: A required database table is missing.

  • Resolved jannee21

    (@jannee21)


    12 years, 2 months ago

    after upgrading to Version 2.5.4, appeared
    ? message:
    A required database table is missing. Please run the following sql command on your database server to create the missing table.
    CREATE TABLE wp_PO_groups (group_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, group_name varchar(255) NOT NULL default ”, group_members longtext NOT NULL, PRIMARY KEY PO_group_id (group_id));

    A required database table is missing. Please run the following sql command on your database server to create the missing table.
    CREATE TABLE wp_PO_post_plugins (post_id bigint(20) unsigned NOT NULL, permalink longtext NOT NULL, disabled_plugins longtext NOT NULL, enabled_plugins longtext NOT NULL, PRIMARY KEY PO_post_id (post_id));

    A required database table is missing. Please run the following sql command on your database server to create the missing table.
    CREATE TABLE wp_PO_url_plugins (url_id bigint(20) unsigned NOT NULL auto_increment, permalink longtext NOT NULL, children int(1) NOT NULL default 0, disabled_plugins longtext NOT NULL, enabled_plugins longtext NOT NULL, PRIMARY KEY PO_id (url_id));

    I run these queries, but I get the answer: Table already exists.

    https://www.ads-software.com/extend/plugins/plugin-organizer/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Jeff Sterup

    (@foomagoo)

    What do you get when you run the following command on your database?

    SHOW TABLES LIKE ‘wp_PO_url_plugins’

    Plugin Author Jeff Sterup

    (@foomagoo)

    Update to version 2.5.5 to see if you still get the error message. There was a problem where mysql running on windows returned the table names in lower case which is different than linux.

    Thread Starter jannee21

    (@jannee21)

    after the command SHOW TABLES LIKE ‘wp_PO_url_plugins’
    I get an answer,that the request has been executed successfully:
    Tables wp_po_url_plugins
    Thank you! After the upgrade to version 2.5.5 , the error message disappears.Your plugin is very good and helped me greatly

    Plugin Author Jeff Sterup

    (@foomagoo)

    NP. Just a difference in the windows world where the table name is all lowercase even if it was created with uppercase.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘notification: A required database table is missing.’ is closed to new replies.