Solved: SQL change all products to virtual / not virtual in WooCommerce via phpMyAdmin

Might you need to bulk edit products to assign them all virtual or not virtual the best way is to do it via the database. I had for my customer over 5000 products in WooCommerce all marked “virtual” by mistake from import. Yes, I tried bulk editing tools like WP Sheet Editor and Bulk Table […]

Huge 2GB table “wp_pcachewpr” in WordPress database after site was hacked

A website was blocked by webhosting because it had been compromised. It contained web shells and a lot of activity was being performed on it by crooks. wp_pcachewpr table in database with size over 2GB was one of the symptoms. When the owner contacted me and I started to clean the site I saw a […]

scl_string_tables over a million rows

Solved: wp_icl_string_pages huge table in database, hundreds of MB, WPML to blame

I discovered a huge table in a customer WordPress when performing a backup with Duplicator before starting to update the site and plugins. Database was huge and boasted a hundred-thousand-row table named prefix_+ icl_string_pages. What the heck and phuck? So but it seems that it was not a new topic. Many have already faced this […]