Change Image Url structure | WordPress.org

Hello, we had a problem with WP Offload Media and Amazon S3, we had to re-upload all images to the S3 server. In the process, the timestamps in the url structure of the images changed. All image urls in our database and media library have been automatically adjusted so that we have no problems with missing images – except with the product configurators. To prevent this in the future, we have deactivated the timestamp url schema option so that all images are now located in a folder in an S3 bucket.

The following problem. In the Woocommerce products, most of the images are missing when I open a product configurator in the admin area on the product page. There is only the question mark symbol and behind it the old link. In the database in _mkl_product_configurator_content meta_value the old image links are also stored. In the frontend on the product page, however, all images are displayed correctly in the configurator with the new link. Strangely enough, there are also some images in the configurator settings in the admin area that are displayed and also have the new link.

Due to the timestamp that is stored in the old image urls in _mkl_product_configurator_content meta_value, we cannot perform mass editing, e.g. using the Better Search & Replace plugin. So I tried it directly manually in the database. As soon as I change / correct a link in the database entry _mkl_product_configurator_content, I can no longer see any content in the admin area under Configurator settings > Content. All are set to 0 content. I don’t understand this because I only correct the image url and everything else stays 100% the same.

Since we have several thousand images for configurator content, reselecting the images via the media library is not an option for us. How can I correct the urls in the database?

A solution using tools to repair images does not work either. It is reported that 0 images were found.