MSSQL issue for Admin login... Weird issue in Moodle3.7

MSSQL issue for Admin login... Weird issue in Moodle3.7

by Niranjan eAbyas -
Number of replies: 1
Hello all.. 

I'm facing issue with admin login in moodle 3.7. Admin user is not able to login to portal, 
When I try  select * from mdl_user where id=2  directly in MSSQL server it is not displaying any records.. The console showing executing but it never completes.. Except admin, i am able to login with all other users.  Even 

I tried purge cache, MSsql restart, Delete user preferences, deleted session table.  Even select * from mdl_user where id>3 also fetches record, but select * from mdl_user where id=2 is not working. 

Also observed that  Select id from mdl_user where id=2 is working but select id,username,firstname from mdl_user where id=2 is not working
it is totally weird and we are not able to find what is happening with DB..

Any suggestions will really help me in identifying the issue. 

Average of ratings: -
In reply to Niranjan eAbyas

Re: MSSQL issue for Admin login... Weird issue in Moodle3.7

by William Lu -
Picture of Particularly helpful Moodlers
Moving to the General Help Forum....