[wp-trac] [WordPress Trac] #44440: Case sensitive/insensitive bug

[WordPress Trac]

#44440: Case sensitive/insensitive bug
--------------------------+-----------------------------
 Reporter:  dingdang      |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Database      |    Version:  4.9.6
 Severity:  normal        |   Keywords:  needs-patch
  Focuses:                |
--------------------------+-----------------------------
 This has been discovered while migrating a site from a Windows server to
 Linux server. The key to the bug is to have a table prefix with capital
 letters, for example pReFiX.
 On the Windows server (however unknown database server/version) this end
 in LOWER CASE table prefixes while at the same time several table cells
 still keep the UPPER CASE version of the value "pReFiX":
 - one - in table "prefix_options" called "pReFiX_user_roles"
 - several - in table "prefix_usermeta" like "pReFiX_capabilities",
 "pReFiX_user_level" etc
 In wp-config.php the prefix is lowercase.

 1. This somehow works on the Windows server
 2. When such a site is migrated to a Linux server, a user can log in but
 then because of the credentials mismatch it loses its role and access is
 forbidden.

 To fix this one must manually replace all occurrences of UPPERCASE prefix
 to LOWERCASE.

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