nestormarius

I agree with @miata2, the plugin should remove all the data when uninstalled, including the database tables. Please fix this!

@ajay I did nothing since we last talk. The Today’s View column in Posts continues to record views from the beginning of the reinstallation. That being said, the views aren’t reset at midnight or the next day, which is fine with me ?? The widget works well, I can’t complain there.

The Total Views is still stuck at 1 for all new posts, but I don’t care if Today’s View shows what I want to see. Thanks again for your time and support and for creating this great plugin!

Cheers.

• This reply was modified 2 months ago by nestormarius.

Hello again @tamirat22 I did just that. I deactivated Jetpack Boost, I deleted it, then I manually removed the /boost-cache directory, and I’ve reinstalled Jetpack Boost. Guess what? My server’s file count went from 95K to 65K after I deleted the /boost-cache directory.

My /boost-cache/cache directory contained 5 (five) cached instances of my website, two without www prefix (e.g. exemple.com and exemple.com.) – notice the dot before the second folder – and two with www prefix (e.g. www.exemple.com and www.exemple.com.) – again, notice the dot at the end of the second folder – and one with mail prefix (e.g. mail.exemple.com).

After I reinstalled the plugin, there’s now only a single cached entry of my site (e.g. exemple.com) in the /boost-cache/cache directory.

Hello @tamirat22 and thank you for your reply. I have already read the troubleshooting guide for caching while searching for a solution to my problem before posting this thread ?? But the troubleshooting guide does not say anything if manually deleting the cache folder is safe.

Yes, the /boost-cache and /boost-cache/cache folders are both set to 755 by default, and the config.php file inside /boost-cache is set to 644.

My issue remains. If I disable Cache, the /boost-cache/cache directory has multiple folders of my website with and without www and they all contain cached files. I was using the Cache feature when it was on beta testing, so maybe that’s the problem.

I think I will delete the plugin, remove the /boost-cache folder, and reinstall. What do you think?

Hi @petredobrescu Thank you, I didn’t know about that option.

@ajay I have a little over 3000 posts on the site, I don’t think it’s that big ?? But I’m using Top 10 since March 2021 and never did any maintenance on it… so I guess that’s why is that big.

I’ve looked again in the database backup and I have a backup of both tables (top_ten and top_ten_daily) in a single SQL file. The top_ten table has a few entries, while the top_ten_daily table has millions of entries dating from March 2021. I made the backup before uninstalling the plugin.

Let me know when you will be able to take a look at the debug log. Thank you and have a good trip!

• This reply was modified 2 months ago by nestormarius.

Ok, I understand, Thank you. I won’t use the Overall option because I prefer showing popular posts over 7 days rather than since the beginning of time ??

However, the issue isn’t resolved with the Total Views option. Even if I enable the “Overall” option, the count is stuck at 1 on new posts since reinstalling the plugin, while previous posts are stuck at the number of views before uninstalling the plugin. So no new views have been added to any post.

What will happen exaclty if I recreate the tables in the database? Also, I have a backup of the top_ten table of 145MB containing millions of entries. I tried importing it but it failed.

Maybe I should reinstall the plugin again?

• This reply was modified 2 months ago by nestormarius.

@mdibrahimk48 thank you for replying. I don’t think that’s a normal use case, just saying. I completely understand your point, but you should rather implement an option to Import/Export the settings instead of leaving trash behind.

Consider this, as a new WordPress user I am trying various plugins until I find the right one for my needs. Let’s say that I try about 20 plugins and they all leave orphaned tables behind… the result? My database is full of unused tables. I ended up with 250+ tables in my database at a size of 300MB+.

After I cleaned up the orphaned tables, my small site had only 40 tables and a size of 14MB.

So please consider implementing an option to Import/Export the settings for those who want to reinstall the plugin and not lose the data. Thank you for understanding!

@ajay thank you for your reply. The “Overall” option was enabled and it stayed enabled when I reinstalled the plugin. However, I have now disable it. So, the Total Views count depends exclusively on the “Overall” option being enabled?

@wpmansour thanks for confirming. Yes, I’ve installed WP Optimze about a year or two ago, but only now I have found the orphaned database tables. Glad to see that the issue has been resolved. Thanks for your support!

You’re welcome!

Nevermind, I found the “Enable scheduled maintenance” option in settings.

Hello @wfphil

Thank you for the quick reply. I’ve installed Wordfence Assistant and it successfully deleted all the Wordfence tables from my database, except one called wfls_role_counts that I had to manually drop (it was empty btw). It’s all good now, thanks for your support!

Hey! Ah, ok, thanks for clarifying. I’m not using WooCommerce, so there must be another plugin using Action Scheduler. Thank you for your time!

Hello, I have the same issue. I thought that you addressed this bug in the latest version of the plugin, but reinstalling it, activating the option in Advanced settings to delete all the plugin data, and uninstalling it ended up adding more orphaned tables to my database.

Now I have aioseo_cache aioseo_crawl_cleanup_blocked_args aioseo_crawl_cleanup_logs aioseo_notifications and aioseo_posts left behind in the WordPress database after uninstalling the plugin.

Is it safe to remove these tables via PhpMyAdmin? Thanks!

• This reply was modified 2 months, 1 week ago by nestormarius.