This question has been discussed several times on the WordPress Hackers email list, I’d recommend Googling something like wp-hackers absolute relative to get an overview of the various lively debates that have taken place over the years. Personally I use the searchreplacedb2 script whenever I migrate a database between URLs, e.g. from live to local/test/dev.
What you posted will work fine for all links that are generated by WordPress: permalinks, script/style enqueues for local files, featured images, etc. I tend to define my Site URL and Home URL dynamically like this: <?php define(‘WP_HOME’, ‘http://’ . $_SERVER[‘HTTP_HOST’]); define(‘WP_SITEURL’, WP_HOME . ‘/wp’); Note: HTTP_HOST isn’t always present, use with caution As far … Read more
Try to replace: AND meta_value LIKE %s with AND meta_value LIKE ‘%%%s%%’ so your SQL will become: AND meta_value LIKE ‘%The%’ instead of: AND meta_value LIKE ‘The’
Okay, this always seems to happen to me. I spend ages looking for an answer and finally decide to give up and post here and then one more search finds enough to solve it. Anyway, this is what worked for me: update wp_posts set post_content = replace(post_content, ‘[/tab] [tab title=”1024×576″] <table class=”screenshot-table”>’, ‘[tabby title=”1024 x … Read more
You can use posts_groupby filter: add_filter( ‘posts_groupby’, function( $groupby ) { return ”; } ); If you want to apply to remove the GROUP BY only to main query and in the frontend, you could do something like this: add_filter( ‘posts_groupby’, function( $groupby ) { if( ! is_admin() && is_main_query() ) { $groupby = ”; … Read more
WordPress was forked (2003) from b2 that used PHP/MySQL, to generate pages dynamically – So I think that’s the why part. https://codex.wordpress.org/History
Alright! I understand that there is a custom wordpress login url. Also you need to login to a user’s profile. If that’s the case, I suggest a simple hack(If you legally have rights to access/modify the database). Try this: Go to cpanel and login to phpmyadmin and open the database for your website/blog. Find ‘wp_options’ … Read more
Try putting the table name inside quotes, like this SELECT * FROM `sparte-bogensport` Edit More info on why this happens: http://dev.mysql.com/doc/refman/5.7/en/identifiers.html
I agree with @Tom J Nowell: I’d suggest you remove it, or better yet just say “all rights reserved”. But in the quest for answers, here’s a suggestion using an option field to cache the years: /** * Get year range for posts. * * @return str */ function wpse_226627_get_copyright() { if ( ! $years … Read more
I have setup WP instance with 2 different database, one for read only and other for admin purpose. But once the admin make the changes, then the ADMIN-DB should be copied and added to SLAVE-DB server. // check if url contains wp-login or wp-admin and then create DB configuration for Master DB else Slave DB. … Read more