wayneljw

Thank you @crossi72 ,

The other issue I noticed is that when I have many posts and many post_meta data, the update_posts() would never ends. I have to comment out the two lines which states: “self::update_posts($post_types, $searches, $replaces);”.

I can understand that it spends time to search the database for the original media file name and replacing, but I’m not sure what is the best strategy to improve this task. And I’m also not sure what the side effects are when I ignore update_posts(). I’m just reporting this to you for your reference.

Hi @shabti ,

The other issue is that, when I use the Dynamic OrderBy function, there is nowhere I can define ascending or descending. (and I notice that it is always ordered descending). Is this setting defined anywhere?

Thanks.

Hi @udniweca ,

The “Post Views Counter” does not put the stats values in the post_meta table. They are stored in wp_post_views instead. Unless you choose another view counter pluging, which stores the hit stat values in the meta table, I don’t think it is possible to use the Advanced OrderBy option to solve your problem.

What I do is creating a cron job php script which periodically clones the hit stats values from wp_post_views to the wp_postmeta table, and use shabti’s suggestion “Advanced OrderBy”. It seems to be working well. But — remember to pad 0’s before the hit value as this plugin sort the custom value alphabetically. As “Post Views Counter” stores unsigned BIGINT(20), I would make it 00000000000000000012 stored in the postmen table if the view count is 12.

Dear Plugin Author,

Just let you know that we use AWS EC2 – linux based environment and we also have this issue.

same here