Possible SQL injection. How to locate and fix?
Possible SQL injection. How to locate and fix?
MySQL
Batch Replace URLs in WordPress Database
No because you’re running the command on the posts table, and only on the content column, but ACF fields aka post meta are stored in the post meta table, not the content column of the posts table so no search replacing is occurring. You can tell WP CLI to perform the search replace with PHP … Read more
How to find source of these strange SQL queries?
They’re from WordPress. They come from the wp_old_slug_redirect() function which is run whenever there is a 404. The purpose is to check if the requested URL was the old URL for a post so that it can redirect to the new URL. If you’re seeing a lot of these then it means you’re getting a … Read more
SQL get last entry of a specific gravity form
SQL get last entry of a specific gravity form
Initialization of table in database using ‘CREATE … IF NOT EXISTS’
Initialization of table in database using ‘CREATE … IF NOT EXISTS’
remove wordpress post links
remove wordpress post links
Where other than wp-config can database access details be defined?
A quick way to disable all plugins is to rename the wp-content\plugins folder. You’ll get some complaints on the wp-admin pages about missing plugins getting disabled, but you knew that. Database access details are in the wp-config.php file in the root of your WP installation. Usually plugins are the main cause of weirdness. Error logs … Read more
Need SQL query to find&replace image URL
If you don’t have WPCLI installed, but still have commandline access or access via PHPMyAdmin, run: UPDATE wp_posts SET post_content = REPLACE(post_content,'<old URL>’,'<new URL>’); UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'<old URL>’,'<new URL>’);
Why can’t I connect to imported WP DB on local MAMP?
Why can’t I connect to imported WP DB on local MAMP?
WP_Query with LIKE returns strange query
You can’t use LIKE to compare arrays. LIKE is used to check if a string matches, or partially matches, a value in the database. IN is used to check if a value in the database is in a given set of values. They are not interchangeable. The correct comparison to use in your case depends … Read more