mysql - Read For Learn

Notice: Uninitialized string offset: 0 in social sharing mu-plugin

Your custom get_the_post_thumbnail_src() function returns a string and not an array, hence in the following code, $sb_thumb is not an array: $sb_thumb = get_the_post_thumbnail_src(get_the_post_thumbnail()); So the PHP notice in question occurred because you used $sb_thumb[0] in the following code, which appears twice in your wpvkp_social_buttons() function: $pinterestURL = ‘https://pinterest.com/pin/create/button/?url=”.$sb_url.”&media=”.$sb_thumb[0].”&description=’.$sb_title; And to get rid of the … Read more

Are these WordPress tables safe to add indexes to?

These tables aren’t indexed These tables are indexed For example, the post meta table has these indexes: https://codex.wordpress.org/Database_Description#Indexes_5 You’re more likely to cause issues or reduce performance through bad indexing by adding new indexes. WP already specifies indexes for tables “dbmain” “wp_mf_post_meta” “post_id” “Not indexed” “dbmain” “wp_mf_custom_fields” “custom_group_id” “Not indexed” Those are not WordPress tables, … Read more

Mass SQL WordPress Meta Key deletion

First, make sure you back up your database. 🙂 If you’re wanting to run a SQL command directly – perhaps using phpMyAdmin – the query would be DELETE FROM wp_postmeta WHERE meta_key = ‘kksr_fingerprint_default’

600k of option_name “c_facebook_background_product_sync_job”

Use phpmyadmin to make a backup of the wp_options table. Then run the same command again, but replace SELECT COUNT(*) with DELETE

Cannot get wpdb data (Error in a simple fuction) [closed]

What about changing BTC to a string <?php get_coin_price(‘BTC’); ?>

WordPress(wpdb class) and mysql stored procedures

wpdb detects the type of query and returns the result if it starts with select, else the affected rows. Since yours starts by call, it’s probably mistaking it for an insert, update, delete, etc. statement. Try this (might trick wpdb into thinking it’s a select statement: /* select */ call …; Or this (not sure … Read more

Have working sql query… trying to adjust it to use $wpdb

Your error message means that $wpdb in your code is currently pointing to a null pointer. Either WP is not loaded, or you’re missing a simple global $wpdb; statement, or both. If you need to load WP, include wp-load.php. Or better, in your JS, use ajaxurl: url = ajaxurl + ‘?action=youraction’ alongside (assuming the above … Read more

Speeding SQL queries for a large database?

Your log shows that MySQL is performing a linear scan of all table records to get the necessary row – this is because there is no index for guid Assuming wp_rb_posts is just the normal posts table with a slightly modified prefix, then you can just add an index for that field, and you’ll see … Read more

Find out how many times the user has logged in

I don’t think so. You will need to do something like this (untested): add_action(“wp_login”, “my_login_function”); function my_login_function($username){ $userdata = get_user_by(‘login’, $username); $n = get_user_meta($userdata->ID, “my_login_counter”, true); if (! is_numeric($n)) $n = 0; $n = intval($n) + 1; update_user_meta($userdata->ID, “my_login_counter”, $n); }

Query to delete all featured images and remove post meta?

A MYSQL Query cannot delete the files themselves. You will have to use wp_delete_attachment(). The following is a proof-of-concept for you to alter how you please. The featured image is stored in postmeta as _thumbnail_id. wp_delete_attachment() does the rest for you. <?php /* Plugin Name: Delete All Featured Images Description: Delete all featured images by … Read more

+ More