Well, you don’t need the second $wpdb->prepare() and just do $wpdb->query( $query );. The reason is because the $query does not contain any placeholders just as stated in the notice; only the items in $values contain the placeholders, but you already prepared them in the foreach. Additionally, be sure to run the query() only if … Read more
That’s not what the $tables variable does, and there is no such thing as a registered custom table. These variables are an internal API not intended for plugin/theme developer use. The $wpdb->mytable pattern itself is just something someone did because they wanted to avoid prefixing manually that caught on in early WordPress articles. The reason … Read more
Use https://www.phpmyadmin.net/ or https://www.adminer.org/ (available on many web hosts or install yourself) and use the overall search function to search for an instance of the string domain.com/domain.com so you can the find the exact problem string, and also find which tables the ACF data is stored in. The strings might be in wp_posts, or wp_postmeta … Read more
page load is not affected […] and the //METADATA is echoed/displayed immediately? With your current setup, that is not possible. In order to display immediately, you need the data. To get the data, you need to wait. Possible solutions are: Fetch the data before (e.g. via Cron) and populate the DB with the info. -> … Read more
Short answer: You have a logical error in your code, this condition is wrong: if($wpdbupdate === 0) Replace it with: if($wpdbupdate >= 0) and it will work as expected. Long explanation: $wpdb->update method returns the number of rows updated, which is 1 in your case, so your code continues to the next block and status … Read more
It isn’t showing wp_posts.post_content LIKE ‘%test%’ because the wildcards (%) in the prepared statement are converted to placeholder escape strings (like the {a19f0a6c3d866f7270be0f3954cbb2600270400c15f488e112449a8a131701f0} in your post) when wpdb::prepare() calls wpdb::add_placeholder_escape() which “Adds a placeholder escape string, to escape anything that resembles a printf() placeholder“, i.e. a placeholder like %s. But those placeholder escape strings will … Read more
One possible solutions is use Queries in the joins instead of tables. so the query would look something like //read products with thumbnail and sku SELECT products.*, skus.sku, thumbs.thumbnail FROM `wp_posts` as products LEFT JOIN ( SELECT posts2.ID, pm1.meta_value as sku FROM `wp_posts` as posts2 LEFT JOIN `sf_postmeta` as pm1 ON posts2.ID = pm1.post_id WHERE … Read more
get_post_meta() with the 3rd parameter set to true will return a single item with the key specified in the 2nd parameter (_custom_field in your code). If this item is an array, it’ll return as the array. In your case, it appears that the data is: array( ‘video_url’ => ”, ) …which is why, when you … Read more
Placing widgets via a MySQL or something MySQL abstracted via the global variable $wpdb that is an instance of the WPDB class is not trivial. That’s not because MySQL is something complicated or because $wpdb is useless at all but this has do something with the way the widget configuration is stored inside the mysql … Read more
I would do the following: Create WP-Cron task (or just use daily wp_scheduled_delete one to tag along) and hook your function to it. In that function: fetch XML file; fetch all posts with meta_weight set, using get_posts(); loop through posts and save comparison result in another meta field for each.