SQL query equivalent to WP User Query
SQL query equivalent to WP User Query
mysql
wpdb Custom Meta Data with 2 conditions
I found my error in the above query. There still may be a better way to do this, thank you kaiser, and I will update once I’ve done more study. What I forgot to do was GROUP_CONCAT another meta_value so i could pull out different bits. It still seems longer than it needs to be, … Read more
#1115 – Unknown character set: ‘utf8mb4’
WordPress does not support MySQL 4 : To run WordPress your host just needs a couple of things: MySQL version 5.0 or greater (recommended: MySQL 5.5 or greater) https://wordpress.org/about/requirements/ While the utf8mb4 encoding is recent change and you might work around it, overall you still need compatible MySQL version.
Too many datadabse connections – upper ceiling mysql
This by no means will be a definitive answer, but I had some tips that were longer than the comments would allow. That high max execution time concerns me. The root of your problem probably has nothing to do with the number of connections to the DB and more to do with the amount of … Read more
How can I list only sites that use a particular theme or plugin?
[*] WP CLI is the easiest option here. First, we want an array/list we can store the desired sites in: results=() Then, we get a list of all sites as a variable, and loop over them: blogs=$(wp site list –fields=”blog_id” –format=”csv”) for entry in $blogs do if [ “${entry}” == “blog_id” ]; then continue # … Read more
Fulltext search in posts sorted by relevancy
You may want to check the Sphinx search engine http://sphinxsearch.com/ It took me about one day to set it up and learn how to use, but it does really good job with sorting by relevancy and grammar stemming. Also it is faster than fulltext search for big data sets thanks to indexing.
Is It Possible to Restore Accidentally Deleted Widgets?
You have to search the wp_options database table for option_name‘s that contains widget. That search results in: Using the values of your backups, you’ll then proceed to restore the option_value of the missing widgets. And also the value of the option of sidebars_widgets. Goes without saying that backing up before doing this modifications is essential.
Query meta field using between
Your problem is this: CAST(wp_postmeta.meta_value AS SIGNED) Run a simple SQL query (command line or PhpMyAdmin, whatever you like) like SELECT CAST(‘1.2’ as SIGNED) and you will see that the value returned is 1. What causes that cast is ‘type’ => ‘NUMERIC’,. You can pass DECIMAL to meta_query instead of NUMERIC but I don’t see … Read more
Why does dbDelta() not catch MysqlErrors?
As @Charleston Software Associates mentioned, the DESCRIBE query should not be executed if the table doesn’t exist. The best solution, as he pointed out, is to prevent the error from occurring in the first place. To do so, patch wp-admin/includes/upgrade.php as follows: Change the following line from dbDelta(): $tablefields = $wpdb->get_results(“DESCRIBE {$table};”); to: //Begin core … Read more
Gaining Login Access via the Database
There are 5 options 1) Ask The Client You haven’t been given what you need to do your work, so you should request it rather than hacking in to the clients site. This would be the Professional and ethical thing to do 2) Reset Password link Using the standard password reset link should do the … Read more