ryanneilmed

Thank you so much, that worked perfectly!

Thanks so much, I appreciate your response. I’ve actually found a way to manually insert the rows needed using a series of SQL queries, thanks to AI SQL generator.

Possibly option 2…but I think I’ll just run a DB INSERT to populate the popularpostsdata table with the post id and views count from post_meta into the respective columns. Then moving forward, any new posts will be recorded views in WPP and the Question Answer plugin. Thanks for your clarity and help with this!

The qa_view_count is how the Question Answer plugin relates views to the questions. It is inside of the post_meta table. So anytime a new question (post) is created, a row in post_meta is created to record number of views for the new post via the post_id.

Hi Hector, thanks for getting back to me. The CPT’s are questions and answers. The view count is stored in post_meta. meta_value is the view count.

My shortcode is:

[wpp limit=’5′ range=’all’ post_type=’question’ order_by=’views’]

If you navigate to dev.neilmed.com you’ll see the questions archive and the number of views for each post (column on the right).

When you go into one of the questions, WPP is showing only recent views, not actual views. You can see the first post “Just purchased sinugator…” has 238 views. But WPP shows it only having 6 views.

I need to have WPP pull views from post_meta table instead of popularpostsdata -> pageviews column. I hope this explanation is helpful.

Thanks!

I think I understand why this is happening now. These are custom post types so I’ll have to run a query in our DB to import them over into the “popularpostsdata” table? I am using the post_type filter.

Used a different directory as nothing else would work