[wp-trac] [WordPress Trac] #40366: WordPress Address (URL) and Site Address (URL) cross wired into wp_options table in DB

[WordPress Trac]

#40366: WordPress Address (URL) and Site Address (URL) cross wired into wp_options
table in DB
--------------------------+-----------------------------
 Reporter:  rgmenon       |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:  4.7.3
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 Reporting on Version: 4.7.3, Linux

 In wp-admin->Settings->General, the "WordPress Address (URL)"  and "Site
 Address (URL)" fields are cross wired into the database wp_options table.
 What you fill in "WordPress Address (URL)" is going into option_name
 siteurl and what you fill in "Site Address (URL)" is going into
 option_name home:

 mysql> select * from wp_options where option_name = 'home';
 +-----------+-------------+----------------------------------+----------+
 | option_id | option_name | option_value                     | autoload |
 +-----------+-------------+----------------------------------+----------+
 |        33 | home        | < value set in Site Address (URL)> | yes
 |
 +-----------+-------------+----------------------------------+----------+
 1 row in set (0.00 sec)

 mysql> select * from wp_options where option_name = 'siteurl';
 +-----------+-------------+---------------------------------------+----------+
 | option_id | option_name | option_value                          |
 autoload |
 +-----------+-------------+---------------------------------------+----------+
 |         1 | siteurl     | <value set in WordPress Address (URL) field> |
 yes      |
 +-----------+-------------+---------------------------------------+----------+

 Workaround of setting the fields directly in the DB works correctly.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/40366>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform