Title: Table installation query needs updateing
Last modified: May 8, 2017

---

# Table installation query needs updateing

 *  [hypeboxesltd](https://wordpress.org/support/users/hypeboxesltd/)
 * (@hypeboxesltd)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/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 EXISTS`wpprefix_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: `KEY`blog_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](https://wordpress.org/support/users/wpmuguru/)
 * (@wpmuguru)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/table-installation-query-needs-updateing/#post-9123057)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/wordpress-mu-domain-mapping.svg)
 * [WordPress MU Domain Mapping](https://wordpress.org/plugins/wordpress-mu-domain-mapping/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-mu-domain-mapping/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-mu-domain-mapping/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-mu-domain-mapping/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-mu-domain-mapping/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-mu-domain-mapping/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Ron Rennick](https://wordpress.org/support/users/wpmuguru/)
 * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/table-installation-query-needs-updateing/#post-9123057)
 * Status: not resolved