[wp-trac] [WordPress Trac] #39470: Login page redirects back to login page. Cause: wp_users table - ID column is case-sensitive

[WordPress Trac]

#39470: Login page redirects back to login page. Cause: wp_users table - ID column
is case-sensitive
------------------------------------+------------------------------
 Reporter:  icanhazpython           |       Owner:
     Type:  defect (bug)            |      Status:  new
 Priority:  normal                  |   Milestone:  Awaiting Review
Component:  Login and Registration  |     Version:  4.1
 Severity:  normal                  |  Resolution:
 Keywords:                          |     Focuses:
------------------------------------+------------------------------

Comment (by icanhazpython):

 I found some additional fields in another site's db which cause issues as
 well (when adding a new post, there is no editor box!):
 wp_comments.comment_id -> comment_ID
 wp_posts.id -> ID

 I think I'm seeing a pattern emerge. These sites are running v4.7 and
 db_version 38590, but it seems that maybe these fields failed to be
 migrated. I have not checked migration source code so not sure but that's
 my guess. Since I've seen this issue on v4.1 as well, it could be that
 these changes were supposed to be made many versions ago, and were not for
 some reason.

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