[wp-trac] [WordPress Trac] #41240: Changing database table prefix confused logins

[WordPress Trac]

#41240: Changing database table prefix confused logins
------------------------------+----------------------
 Reporter:  frankieandshadow  |       Owner:
     Type:  defect (bug)      |      Status:  closed
 Priority:  normal            |   Milestone:
Component:  General           |     Version:
 Severity:  normal            |  Resolution:  invalid
 Keywords:                    |     Focuses:
------------------------------+----------------------
Changes (by knutsp):

 * version:  4.8 =>


Comment:

 Related: #20152

 There are two tables in question:
 1. `options` (see the related ticket and my comment 15 months ago, and
 please add your comment, as this is fixable)
 2. `usermeta`

 Then for `usermeta` you would have to either reopen and turn this ticket
 into an enhancement request or, probably better, create a new enhancement
 request ticket here. But, for it to have any chance of getting some
 attention and interest, you should provide an alternative, a suggestion on
 '''how''' it could be fixed or made simpler.

 Database migration is not supported by WordPress. There are imports and
 exports for that task. But it's possible, and I do a lot of it myself, and
 there are tools and plugins that may automate the process, along with
 human experts. And all things are documented and described on the web, for
 those who can search, read and understand technical things on this level.
 Making things less complicated for WP engineers who want to do things like
 this are very rarely a priority for the core development team, unless
 there are obvious benefits in it for the end users.

 Also remember that the `users` and `usermeta` tables are global for a
 WordPress network or collection of networks (Multisite), or it may be
 ''common'' to several single installations. If the capabilities key is not
 to be prefixed with the table prefix of the site it's valid for, how could
 it be stored discrete?

--
Ticket URL: <https://core.trac.wordpress.org/ticket/41240#comment:4>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform