Mikey

I’ve just sent an e-mail.

Thank you.

Hi @hailite,

As I’ve said, this issue doesn’t happen with version 2.9.7.1 (which I am currently reverted to for this matter). It only happens from 2.9.8 onwards.

And yes, the %need_pull% option is autoloaded in my wp_options.

Given that the issues were gone, I decided to update again to 2.9.8 (latest).

The issue with optimization versions in Media is still there, same as the other topic opened on the support forum: https://www.ads-software.com/support/topic/image-optimization-urgent/

I think I will get back to 2.9.7 in the meantime.

Oh, I had Maintenance Mode activated, because I have been doing some changes to my website (including updates).

This was causing the issues indeed. I’m sorry, I wasn’t aware of that.

Do I still need to have those Litespeed IPs in Admin IPs Debug?

Well, the request didn’t succeed (the images where not being pulled as they should have) so I tried again by cleaning unfinished, resetting IAPI and trying Optimization Request…aaand -> the initial errors are back.

(I also added those IPs in Wordfence whitelist.)

Losing the optimized images may be re-made, but I am worried if the rest of Litespeed works well (the caching, tuning, etc.) ?

I actually added all those IPs in LiteSpeed Cache Settings -> Debug -> Admin IPs.

And I tried to Send Optimization Request and it no longer threw errors, and it seems to be working, but…it started from scratch? I at level 1 and it just requested optimization for 8 images.

I don’t get it…because all my images seem to be already optimized in the Media (and also as you can see in my printscreen above).

Oh man, this is what happened after the Clean Up Unfinished Data and Reset IAPI Key above: https://prntscr.com/o29oo4

Did I just lose all my optimized images and credits with Litespeed?

I think it requires a classic IP address, because I get this error: https://prntscr.com/o29nn1

No, I haven’t.

I am using Wordfence for security and I also updated to their latest version today. But I’ve never changed any of its default settings.

Just for the sake of giving it a try, I deactivated Wordfence, and it seemed that Cleaning up unfinished Data and reseting IAPI key worked well, but image optimization request threw the same errors, even with Wordfence deactivated.

bxxxx4.oxxxxxxx.com is indeed the server where my website is hosted.

What else?

Hi @stanleylitespeed,

Just tried it, when I clicked on Clean Up Unfinished Data I got this: https://prntscr.com/o295tg

Still not working.

What’s up with this hash doesn't match and no_auth_key? I’ve never experienced anything like it.

I just updated to the lastest version of LiteSpeed and I have the same issue. In Media there is no longer displayed the information regarding the optimized versions, as it used to.

I reverted to 2.9.7 and it’s fine.

• This reply was modified 5 years, 9 months ago by Mikey.

Hi Jamie,

When I started this topic, every order was basically duplicated as a vendor order in wp_postmeta table.

However, I’ve just noticed (and further tested with a few orders) that there are no more ~40 rows stored for the vendor id.

For example, all the customer billing and shipping details from the parent order are not stored anymore – which were totally useless anyway imo, thus keeping it to a minimum, which is ideal.

Did something change in v 2.1.9 in this sense? Or maybe is it because of WC 3.6+ ?

I can’t figure it out. At first I thought that maybe I did some changes in the plugin’s files, but I’ve just tried it with the fresh, untouched plugin and it’s the same.

What am I missing?

(I just want to make sure that everything is working properly.)

Many thanks,
Mikey

Hi @priyankajagtap,

Thank you for your answer.

Oh. I have the “Automatically Delete Abandoned Orders after X days” option set up, but somehow it seemed to me that all-time abandoned products remain forever in Product Reports, just adding up in time.

I’ve made some further checks now, it seems that they indeed get deleted, once the respective abandoned order is deleted.

My bad.

Thanks again.
Mikey

Some other checks later, I’ve learnt that for every WC Order, which records ~45 rows in wp_postmeta, there are also “duplicates” of all those rows…for EVERY Vendor in that respective Order.

So let’s say I have one order for 5 products belonging to 5 different Vendors: that would be ~225 rows created simultaneously in the table. For just 1 order!

I think that should be a good reason for not wanting to keep orders in WC admin (and even more not wanting duplicates of those orders remaining in the database without any use).

Just throwing out thoughts here. I really hope you come up with that clean up code.

Oh, we sure keep all the records for fiscal purposes and whatnot! But we save and keep them on printed paper (required by our fiscal authority) and also on digital mediums (hardware/server – for our own business records).

What I meant was that there is no reason for us to keep the orders inside our platform’s Woocommerce admin for a long time. I hope it makes more sense now and also as to why scrubbing all sub order info would benefit the wp database.