Get site URL from config instead of the database

[mhmdyassin07]

a big problem is facing everyone trying to move a site between two hosting or between two environments like (staging and production )
the most frequent problem is the site URL and the internal links
and if you have extensive databases it will be your nightmare
so it creates issues and limits our flexibility

so what I suggest is to set the site and home URLs from the wp-config.php file
like
define( 'SITEURL', 'https://mywebsite.com' );

I know it is not very simple, especially with multi-sites but it deserves

I also tried

define( 'WP_HOME', 'http://example.com' );
define( 'WP_SITEURL', 'http://example.com' );

but if you don't have 'siteurl' option on your site it will give you
'Error establishing a database connection' in the front end
and
'One or more database tables are unavailable. The database may need to be repaired.'

which even not the clear error message
die to
wp-includes/functions.php => function is_blog_installed

I can work on this point but before I spend time, I need approval from the WordPress team that they will accept such modification or that not be accepted

[sabernhardt]

Hi and thanks for the report!

I think this is the same issue as #55607 and very similar to #33909. We probably should close this ticket as a duplicate of one of those.

Changeset [14517] intentionally removed URL filters in multisite to correct the admin URL, and reinstating them probably could break other things now.

[mhmdyassin07]

But I need to make it in a normal site not a multisite @sabernhardt

[SergeyBiryukov]

Replying to mhmdyassin07:

But I need to make it in a normal site not a multisite

Thanks for the follow-up! Renaming the ticket accordingly.

In that case, this sounds like the issue previously reported in #23487 and #29794.

While the siteurl database option is indeed required for the is_blog_installed() function to work, the WP_HOME and WP_SITEURL constants do override the respective database options, so it's not quite clear to me what is the exact issue or suggestion here.

For easier migrations or creating a test environment, a snippet like in comment:2:ticket:36737 for replacing internal links in content on the fly might be helpful.

[sabernhardt]

But I need to make it in a normal site not a multisite

Oops. The description says especially with multi-sites (not only). Thanks for correcting it!