Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

One user can not log -- how to debug?

  • Jmantysalo
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
2 years 5 months ago #221402 by Jmantysalo
One user can not log -- how to debug? was created by Jmantysalo
I have made a custom plugin that glues shibboleth with LS. Now one use can not log in, he gets "500: Internal Server Error CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'full_name' cannot be null"

He has tried two different browsers, also in private mode. In a test page on the same server SB attribute displayName is shown as it should, i.e. data from SB login goes to PHP $_SERVER. Other people have no problem logging in. Any hints about how to debug this?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 5 months ago #221544 by DenisChenu
Replied by DenisChenu on topic One user can not log -- how to debug?
Put anything on full_name

return message is clear enough : full_name cannot be null

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • Jmantysalo
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
2 years 5 months ago #221552 by Jmantysalo
Replied by Jmantysalo on topic One user can not log -- how to debug?
Just 20 minutes before your message I got this to work.

There was a non-empty name. For some reason the system failed after my plugin said setAuthSuccess($oUser). I deleted the user account and then the used logged in again (via shibboleth) and now everything works. I suppose that something very weird has happened in some version of LimeSurvey. I looked at DB also, and lime_users seemed to be OK. I still do not understand what happened.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 5 months ago #221553 by DenisChenu
Replied by DenisChenu on topic One user can not log -- how to debug?
Existing user ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • Jmantysalo
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
2 years 5 months ago #221554 by Jmantysalo
Replied by Jmantysalo on topic One user can not log -- how to debug?
Yep. The user had been using the system for more than a year. About a week ago it just stopped to work; I suppose it happened after we had upgraded to 5.1.16+211020.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 5 months ago #221564 by DenisChenu
Replied by DenisChenu on topic One user can not log -- how to debug?
Sometghing related to plugin code , no ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • Jmantysalo
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
2 years 5 months ago #221572 by Jmantysalo
Replied by Jmantysalo on topic One user can not log -- how to debug?
Hard to say. The plugin is quite simple and works for everyone else.
The following user(s) said Thank You: DenisChenu
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose