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
),
KEYblog_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..
- The topic ‘Table installation query needs updateing’ is closed to new replies.