SQL error: Unknown column...

6 years 8 months ago #81563 by pes130

I'm having a database problem.

When a user with only 'Create enquiry' permission checked tries to link 'Create/Edit Users' in the main menu, he gets the following message:

Unknown column 'users.parent_id' in 'where clause': SELECT * from `lime_users` where uid in ( SELECT uid from `lime_user_in_groups` where ugid in ( SELECT ugid from `lime_user_in_groups` where uid=24 ) ) UNION SELECT * from `lime_users` where users.parent_id=24

It also happens when he clicks the option 'Modify security options in the enquiry' inside an enquiry. The message is exactly the same.

Why is this? Any clue to solve the problem?

We are using Versión 1.90+ Build 9130.

Thanks in advance.

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!