sql - Read For Learn

updating user in custom wordpress table

There are 2 main issues in your code: Your $wpdb->get_row($prepare) will return either an object or a null, so you can’t do if(count($users) > 0) because $users is not an array. To fix that, just use if ( $users ). There’s a typo here: SET fnmme=%s — the field name should be fname. So you … Read more

SQL phpmyadmin remove posts from cat id exclude condition

finally I find right code with helping by ChatGPT DELETE p FROM wp_posts p INNER JOIN wp_term_relationships tr1 ON (p.ID = tr1.object_id AND tr1.term_taxonomy_id = 2) LEFT JOIN wp_term_relationships tr2 ON (p.ID = tr2.object_id AND tr2.term_taxonomy_id = 20) WHERE p.post_type=”post” AND p.post_status=”publish” AND DATEDIFF(NOW(), p.post_date) > 180 AND tr2.term_taxonomy_id IS NULL; Lets try another way … Read more

Change comments ordering by custom value

#1067 – Invalid default value for ‘post_date’ when trying to create a new column

This may not be the best solution. I am not an expert. But the following helped solve my problem and I can add columns using the PhpMyAdmin without getting any errors. I went over to the SQL tab and then I ran the following query show variables like ‘sql_mode’; Then in order to remove i … Read more

How to correctly cleaning wordpress options table

How to address an invalid “NOT IN ()” query?

I have resolved it eventually. I suspect this was an injection attack on the system by a bot that managed to create a user account for itself. One lesson learned is to govern user creation more strictly. But it’s still not fully clear what/how the intruder acted, so if somebody has a clue, share in … Read more

Where is WooCommerce order shipping methods stored

Here’s a sample SQL query that demonstrates this approach: SELECT MONTH(p.post_date) AS month, pm.meta_value AS shipping_method, COUNT(*) AS order_count FROM wp_posts p JOIN wp_postmeta pm ON p.ID = pm.post_id JOIN wp_woocommerce_order_items oi ON p.ID = oi.order_id WHERE p.post_type=”shop_order” AND pm.meta_key = ‘_shipping_method’ AND p.post_date >= ‘2021-01-01’ AND p.post_date < ‘2022-01-01’ GROUP BY month, shipping_method Replace … Read more