WordPress database error Table 'wp_2_links_extrainfo' doesn't exist

  • Shefik

    (@shefik)


    10 years, 3 months ago

    I keep getting this error under WordPress 4.4, with multisite enabled:

    WordPress database error Table ‘wp_2_links_extrainfo’ doesn’t exist

    I checked the database, and table indeed doesn’t exist, so there seems to be an issue with the “links_extrainfo table getting created automatically for a new multisites, even though it is created for the first site.

    How to fix?

    https://wordpress.org/plugins/link-library/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Mike

    (@crushaxe)

    10 years, 3 months ago

    Does your database user have the ability to create tables?

    You could try running this SQL statement manually:

    CREATE TABLEwp_links_extrainfo` (
    link_id bigint(20) NOT NULL DEFAULT ‘0’,
    link_second_url varchar(255) DEFAULT NULL,
    link_telephone varchar(128) DEFAULT NULL,
    link_email varchar(128) DEFAULT NULL,
    link_visits bigint(20) DEFAULT ‘0’,
    link_reciprocal varchar(255) DEFAULT NULL,
    link_submitter varchar(255) DEFAULT NULL,
    link_submitter_name varchar(128) DEFAULT NULL,
    link_submitter_email varchar(128) DEFAULT NULL,
    link_textfield text,
    link_no_follow varchar(1) DEFAULT NULL,
    link_featured varchar(1) DEFAULT NULL,
    link_manual_updated varchar(1) DEFAULT NULL,
    UNIQUE KEY link_id (link_id)
    )`

    Plugin Author Yannick Lefebvre

    (@jackdewey)

    10 years, 3 months ago

    Link Library is supposed to create a new table for every new network site that gets created. Indeed, if the database user does not have table creation permissions, it would cause problems when new sites are created.

    Thread Starter Shefik

    (@shefik)

    10 years, 3 months ago

    The database user does have permission to create a table. The tab;e did not get created properly. The site was initially a regular WordPress site, and then multisite was enabled. The table did not get created in this case.

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

The topic ‘WordPress database error Table 'wp_2_links_extrainfo' doesn't exist’ is closed to new replies.