See Changing The Site URL « WordPress Codex for recovery instructions on how to reset the URLs without database access, i.e. by editing either the wp-config.php file or the theme’s functions.php file with FTP: 1) by adding lines to wp-config.php (which can be left in place): define(‘WP_HOME’,’http://example.com’); define(‘WP_SITEURL’,’http://example.com’); 2) or the theme’s functions.php file (but … Read more
The Problems You risk SQL injection, with your current setup: $wpdb->users.display_name LIKE ‘$ltr%’ The following could also be a problematic part in your SQL query: AND $wpdb->usermeta.meta_value = %artist% i.e. using = instead of LIKE. You’re also missing the quotes: %\”artist\”%, to exclude e.g. bartist or fartist 😉 But you don’t need to construct this … Read more
I would use the filter_var() function. It has some predefined filters that you can use depending on what kind of data you are expecting such as string, number, etc. So to sanitize for a number: $sanitizedNum = filter_var($yourVar, FILTER_SANITIZE_NUMBER_INT); For a string you would just change “_NUM_INT” to “_STRING”. Wrap those in a custom function … Read more
Try this SQL query: UPDATE wp_terms SET name=LOWER(name);
Look at this Bulk post type conversion, there are listed SQL/WP ways to do that. Try to do that yourself first with a db copy. In phpMyAdmin there is a box to run queries, called “SQL”. You can see a demo here http://demo.phpmyadmin.net/master-config/
This is actually not that hard, but you will have to excuse me for keeping it high level because this is just a stupid thing to do as all things which are security by obscurity. All you need to do is write your WPDB driver, which inherits the WPDB class. Place it in /wp-content/db.php file … Read more
It is totally essential to use utf8mb4 for your site to be secure and bug free in all wordpress versions since 4.2 and probably before that. You need to upgrade your mysql software to a newer version, or change whatever is need in its configuration to support it.
Check out this thread wp_options is GB in size My wp_options table dropped from 670GB to 13.5MB after running the optimization commands they outlined
I would advise using wp_insert_post() and putting you text files into a CSV CSV Post Title,Post Content, “title”, “content”, “title”, “content”… PHP $path = “/posts.csv”; //require __DIR__ . “$path”; $file = fopen(__DIR__ . $path, ‘r’); while (($line = fgetcsv($file)) !== FALSE) { //$line is an array of the csv elements $post[“id”] = wp_insert_post( array( “post_title” … Read more
Error is from the last command wp search-replace “${domain}” “test” –allow-root. Your WordPress site is not yet installed and you want to execute command which require WordPress to be installed. Earlier in script you are dropping test database and creating new one, but you have to fill it with WordPress tables. Without this tables WordPress … Read more