Hello all,
I have been having the strangest issue with a login system. Its a login system with users, each having a user id. Everything works fine, but ONLY for certain Primary key “ID”'s.
Example:
#1 John
#2 Sam
#3 Mike
John and Mike can pull up their info on login. Sam cant. If I delete Sam and edit Dave as #2, Dave doesnt work. If I delete Mike and edit Dave to #3, Dave starts working. Then move back to #2, stops working. So its not specific to user or users data, its specific to ID. Only #1, #3, #5, #8, #10, #11 work. All others fail.
I have no code that excludes ID’s in any way shape or form. I would include code but there is too much and there is nothing in it to explain this issue. It defies logic really.
One thing to note, the ID’s that DO work were all INSERTED in mysql two months ago. So ultimately the issue is that only fields with IDs that were created two months ago work. New ID’s dont work. New entries changed to an old ID, it starts working. Change them back to a new ID, stopped working.
I am boggled and anyone with a hint on why this could happen would be great. Ive been using mysql for years so I dont think its a noob issue. Any help would be amazing!