vipo

I’ve just reverified, that the header and footer Top-10 sidebar widget is actually showing data from the desired categories (and doing so using the given term_id values)?

Checking the table using [SELECT * FROM wp_term_taxonomy] – using 2331 as where clause gives:

term_taxonomy_id,term_id,taxonomy,description,parent,count
2331,2331,category,””,”0″,48

=> here term_taxonomy_id and term_id ARE THE SAME (!)

=> I don’t know why these ids are different (offset 3) in the other group of categories??

Re offset)

The site is from 2015. I’ve done upgrades from WP4.9 to WP5.2 (on very old server env, e.g. php 5.6), then directly into WP 6.5.2 (on DevKinsta locally, then synced to an empty new staging environment on a kinsta webspace).

The query monitor request shows that a “wrong” category-id (240) is actually used (as from shortcode param), but the results shown are from another category (243)!
BTW: There is NO category with an id 240 in the db! (verified using /wp-admin/edit-tags.php?taxonomy=category&orderby=ID&order=asc and checking results && also did use ‘SELECT * FROM wp_terms WHERE term_id = ‘240’ in adminer yields no results, but 243 does!)

In the db table wp_terms is the key ‘term_id’ in use.

I’ve searched in the table ‘wp_term_taxonomy’ (<=> there seems to be the problem, as you have mentioned!): SELECT * FROM wp_term_taxonomy WHERE term_id = ‘243’

term_taxonomy_id,term_id,taxonomy,description,parent,count
240,243,category,””,153,203

term_taxonomy_id = 240 (as used in the shortcode)
term_id = 243

=> The problem here is, that the term_taxonomy_id is not directly visible within WP.
=> Best solution would be to add an alternate param within the shortcode?

Re WPP stats)

I exported wp_popularpostsdata and wp_popularpostssummary tables from the WP database (using phpmyadmin) as CSV and used simple python scripts to convert into Top 10 import format. Formats and contents are very similar.

BTW: I’ve exported and converted the WPP stats data into the required csv-format to be used within Top-10 and imported the 2 CSVs into Top 10 to have the whole original stats.

I’m migrating an old site (using an old theme) which isn’t using Gutenberg Block Editor, but “Classic Editor” and “Classic Widgets” plugins instead.

The widget works only in the context of the theme header (mega menu) and footer. The widget does’nt work when used on a page context, e.g. embedded using “Widgets On Pages”-plugin. Also the shortcode (used within a page content) doesn’t work, meaning NOT showing the correct filtered category postings, but a listings of posts from another category. So i have to use the WRONG cat-id as a value for include_cat_ids shortcode param to get the results from my original one. Very weired!

In my example: using include_cat_ids=”255″ instead of correctly “258”.

But wait: As i’ve checked the value shifts for this comment, i’ve seen, that it is always a difference of “3” !?? => I’ve found a curious – temporary ?? – workaround for my problem! Now verified that with another page, if i use “cat-id minus 3” the correct/desired listing is produced.

Another info: In my original comment i’ve stated the context are posts, but i’ve used the shortcode only within pages (if that matters).

From Query Monitor: is_page, is_singular,

Header query (working as expected) – used in a mega menu: WP_Query->get_posts()

SELECT?wp_posts.*,wp_top_ten.postnumber, wp_top_ten.cntaccess as visits, wp_top_ten.blog_id?
FROM?wp_posts?
LEFT?JOIN?wp_term_relationships
ON?(wp_posts.ID = wp_term_relationships.object_id)
INNER?JOIN?wp_top_ten
ON?wp_top_ten.postnumber=wp_posts.ID?
WHERE?1=1?
AND?( wp_posts.post_date <= ‘2024-04-12 13:37:47’ )
AND?( wp_term_relationships.term_taxonomy_id?IN?(2337,2343) )
AND?wp_posts.post_type = ‘post’
AND?((wp_posts.post_status = ‘publish’
OR?wp_posts.post_status = ‘inherit’))
AND?wp_top_ten.blog_id?IN?(‘1’)?
GROUP?BY?wp_posts.ID?
ORDER?BY?wp_posts.menu_order, wp_top_ten.cntaccess?DESC
LIMIT?0, 27

Page context (*working*, but using WRONG cat-id 240 instead of 243): WP_Query->get_posts()

Shortcode: [tptn_list include_cat_ids=”240″ limit=”20″ heading=”0″ daily=”0″ how_old=”9999″ show_date=”1″ show_excerpt=”1″ disp_list_count=”1″]

SELECT?wp_posts.*,wp_top_ten.postnumber, wp_top_ten.cntaccess as visits, wp_top_ten.blog_id?
FROM?wp_posts?
LEFT?JOIN?wp_term_relationships
ON?(wp_posts.ID = wp_term_relationships.object_id)
INNER?JOIN?wp_top_ten
ON?wp_top_ten.postnumber=wp_posts.ID?
WHERE?1=1?
AND?( ( wp_posts.post_date >= ‘1996-11-26 00:00:00’
AND?wp_posts.post_date <= ‘2024-04-12 13:37:47’ ) )
AND?( wp_term_relationships.term_taxonomy_id?IN?(240) )
AND?wp_posts.post_password = ”
AND?wp_posts.post_type?IN?(‘post’, ‘page’)
AND?((wp_posts.post_status = ‘publish’
OR?wp_posts.post_status = ‘inherit’))
AND?wp_top_ten.blog_id?IN?(‘1’)?
GROUP?BY?wp_posts.ID?
ORDER?BY?wp_posts.menu_order, wp_top_ten.cntaccess?DESC
LIMIT?0, 60

There is no outcome/mind shift to be expected from Kinsta. Eventually they will reevaluate (no ETA).
As I have to go forward, I have to switch to another plugin in the meantime. I’ve seen you have also authored Recently (including support for Top-10 or WP-PostViews view counts). So maybe I go in this direction.

Is there a possibility to export all the data from WP-Popular Posts and have the data (csv file) imported into Recently/Top-10?

I do not want to loose the collected information.

Hi Héctor, I also had a dispute with Kinsta regarding the banning. They were not willing/able to give an estimate, when a reevaluation will take place. Sad about the situation, because your plugin worked so well.