Support » Plugin: WordPress MU Domain Mapping » Table installation query needs updateing

  • After i installed this plugin and attempting to map a domain to a site i noticed that nothing was happening.

    so looking at the database i could see the plugin had created the ‘domain_mapping_logins’ table but not the ‘domain_mapping’ table.

    I then procceeded to attempt to manually install the table via the query found in file: domain_mapping.php line 94.

    MySql threw an error: #1071 – Specified key was too long; max key length is 1000 bytes

    so i updated the query to the following and the query went though, and the plugin worked again:

    CREATE TABLE IF NOT EXISTSwpprefix_domain_mapping` (
    id bigint(20) NOT NULL auto_increment,
    blog_id bigint(20) NOT NULL,
    domain varchar(255) NOT NULL,
    active tinyint(4) default ‘1’,
    PRIMARY KEY (id),
    KEY blog_id (blog_id,domain(50),active)
    );`

    the diffrence is in this line: KEYblog_id(blog_id,domain(50),active)

    the varchar(255) is just to big to be indexed, so we do the above to only index part of the data stored in the column.

    Id also like to note that the plugin really should improve upon its error reporting as this could have turned into hours of searching..

Viewing 1 replies (of 1 total)
  • Plugin Author Ron Rennick

    (@wpmuguru)

    MultiSite Guru

    New WP installs do not need this plugin. Domains can be mapped directly in WP Network Admin as of WP 4.4.

Viewing 1 replies (of 1 total)
  • The topic ‘Table installation query needs updateing’ is closed to new replies.