[Plugin: SEO SearchTerms Tagging 2] Not working on domain with another blog

no, there is no limitation for this plugin. you can install it in unlimited blog.

in your 2nd blog, do you see any error log in your public_html folder? can you find any error related to stt2 plugin?

Thank you, problem resolved with newer SST version

This sounds like a similar issue to what i’m having, but I have the latest version (1.52) on wordpress 3.1

I have installed searchterm tagging on my multisite blog network which obviously use the one primary database for many domains.

The plugin activates and works fine with the primary domain on that blog network but fail to work on the other sub domains.

A look in my error logs tells us that the database table thats ment to be created when enabled doesnt exist.

– WordPress database error Table ‘db_wrdp1.wp_19_stt2_meta’ doesn’t exist for query INSERT IGNORE INTO wp_19_stt2_meta_tmp ( post_id,meta_value,meta_count,last_modified )
SELECT post_id,meta_value,meta_count,last_modified FROM wp_19_stt2_meta; made by require_once, do_action, call_user_func_array, pk_stt2_create_admin_menu, pk_stt2_db_upgrade_db_structure, W3_db->query

– WordPress database error Can’t find file: ‘./db_wrdp1/wp_19_stt2_meta.frm’ (errno: 2) for query RENAME TABLE wp_19_stt2_meta TO wp_19_stt2_meta_backup,
wp_19_stt2_meta_tmp TO wp_19_stt2_meta; made by require_once, do_action, call_user_func_array, pk_stt2_create_admin_menu, pk_stt2_db_upgrade_db_structure, W3_db->query

– WordPress database error Table ‘db_wrdp1.wp_19_stt2_meta’ doesn’t exist for query SELECT count(ID) FROM wp_19_posts WHERE post_status = ‘publish’ AND post_type = ‘post’ AND ID NOT IN (
SELECT post_id FROM wp_19_stt2_meta ); made by require_once, do_action, call_user_func_array, pk_stt2_create_admin_menu, pk_stt2_admin_print_admin_page, pk_stt2_db_get_number_of_posts_wo_traffic, W3_db->query

– WordPress database error Table ‘db_wrdp1.wp_19_stt2_meta’ doesn’t exist for query SELECT meta_value,meta_count,post_id FROM wp_19_stt2_meta ORDER BY meta_count DESC LIMIT 15; made by require_once, do_action, call_user_func_array, pk_stt2_create_admin_menu, pk_stt2_admin_print_admin_page, pk_stt2_admin_print_searchterms, pk_stt2_db_get_popular_terms, W3_db->query

– WordPress database error Table ‘db_wrdp1.wp_19_stt2_meta’ doesn’t exist for query SELECT meta_value,meta_count,post_id FROM wp_19_stt2_meta ORDER BY last_modified DESC LIMIT 15; made by require_once, do_action, call_user_func_array, pk_stt2_create_admin_menu, pk_stt2_admin_print_admin_page, pk_stt2_admin_print_searchterms, pk_stt2_db_get_recent_terms, W3_db->query

– WordPress database error Table ‘db_wrdp1.wp_19_stt2_meta’ doesn’t exist for query SELECT meta_value,meta_count,post_id FROM wp_19_stt2_meta WHERE post_id = 0 ORDER BY meta_count DESC LIMIT 15; made by require_once, do_action, call_user_func_array, pk_stt2_create_admin_menu, pk_stt2_admin_print_admin_page, pk_stt2_admin_print_searchterms, pk_stt2_db_get_home_keywords, W3_db->query

The plugin admin still works but doesnt contain the pre-defined settings as the primary domain install and the search term removal cron settings contain the famous “1970” issue.

Last database cleaned up: Never
Next scheduled database clean up on January 1, 1970, 12:00 AM.

Does anybody have a fix for this issue, thanks.

hi all, i am sorry, i still don’t have time to test the plugin in wordpress multisite.

the plugin was build for single wp blog, therefor, when activated it is only create one database table, but in wp multisite environment, we need to create several tables one for each blog in the network.