[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        |  Resolution:
 Keywords:  needs-patch   |     Focuses:
--------------------------+------------------------------

Comment (by dingdang):

 In Windows also prefix setting in wp-config.php is lowered case, while in
 Linux it s mixed ("pReFiX_"). Thus after a migration (copy of the files
 and database from Windows to Linux) everyhing would work on the frontend
 as the prefix would match (lower case), the only problem is that in
 options and usersmeta tables it is in uppercase. After a successful login
 an error message "You don't have access to that page" appears (even with
 correct login/password).
 Manual fix of the prefix case in these two tables fixes the problem.

 The bug is in Windows environment - as the table prefix is converted to
 lower case (as well in wp-config.php), the values in the two mentioned
 tables should be lower case as well.

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