I love this plugin very much. Currently, it can works in WPMU , only in main blog. (e.g. https://domain.com/blogs/), but it can not works in WPMU non-main blogs (e.g https://domain.com/blogs/thirdblog/)
where:
/blogs/ is my main blog as WPMU superadmin
/blogs/thirdblog/ is my users blog in WPMU
[Edited]
This is because searchmeter doesn’t make tables for the other WPMU member’s blogs. If I copy the two tables that searchmeter have for my main blog to make tables for member blogs, then it will work as usual. But My hands are tired to make tables copy each time a new member’s blog created. How I can make it automaticly create new tables for other member’s blog?
I did this :
CREATE TABLE
dbprefix_wpmudb.
blognumber_2_searchmeter` (
terms
varchar( 50 ) NOT NULL ,
date
date NOT NULL ,
count
int( 11 ) NOT NULL ,
last_hits
int( 11 ) NOT NULL ,
PRIMARY KEY ( terms
, date
)
) ENGINE = MYISAM DEFAULT CHARSET = utf8;
CREATE TABLE dbprefix_wpmudb
.blognumber_2_searchmeter_recent
(
terms
varchar( 50 ) NOT NULL ,
datetime
datetime NOT NULL ,
hits
int( 11 ) NOT NULL ,
details
text NOT NULL ,
KEY datetimeindex
( datetime
)
) ENGINE = MYISAM DEFAULT CHARSET = utf8;`