View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
09334Bug reportsAuthenticationpublic2015-12-08 17:06
Reporterwolki Assigned Toc_schmitz  
PrioritylowSeverityminor 
Status closedResolutionunable to reproduce 
Product Version2.05+ 
Summary09334: "Admin"-user without menu-items after some error.
Description

After an error while duplicating a survey the main menu for "admin" is not populated fully. Most top menu items are missing after this error occurred and I would like to have them back.

As only the "admin"-account was destroyed and all other users still work I have no pressure having this solved.
But if I would need to add more users I would get into troubles as the buttons for this disappeared.

Steps To Reproduce

I logged in as "admin".
I duplicated a survey (see .lss attached). The original name was MASELTOV and I duplicated it as MASELTOV00.
After clicking on MASELTOV00 from the home-list of surveys I ran into an error. I am so sorry, I tried to reproduce the error but was not able to do it (I duplicated again - no error occured).
Since the error happened, when logging in as "admin" users most of the upper menu is gone. Only the home-button, list surveys, logout and help are here.
All the rest (user administration, groups, global settings,.....) has gone when logged in as "admin".
Before I did all this I added other users as admins - they still all have the correct menu; only the "admin" one (where the error occurred while duplication) is still broken.

Additional Information

I run lime-survey on a ubuntu 14.04LTS. The only updates installed automatically are security-updates.

TagsNo tags attached.
Attached Files
LimesurveyMissingMenu.PNG (7,660 bytes)   
LimesurveyMissingMenu.PNG (7,660 bytes)   
Bug heat8
Complete LimeSurvey version number (& build)140612
I will donate to the project if issue is resolvedNo
BrowserFirefox Aurora 35.0a2
Database type & versionMySQL 5.5.40
Server OS (if known)Ubuntu 14.04
Webserver software & version (if known)Apache 2.4.9
PHP Version2.5.0

Users monitoring this issue

wolki

Activities

wolki

wolki

2014-10-28 12:08

reporter   ~30879

The attached screenshot shows where "admin" is still missing the menu.

c_schmitz

c_schmitz

2014-10-29 19:22

administrator   ~30883

I doubt that you 'lost' permissions on the admin. Most likely this is a caching error. Do you still have the missing entries when loggged in as admin?

Anyway, without a full dump of your database it is just a guessing game. Can you provide this?

wolki

wolki

2014-10-30 12:51

reporter   ~30895

Q: I doubt that you 'lost' permissions on the admin. Most likely this is a caching error. Do you still have the missing entries when loggged in as admin?

A: I also doubt i really "lost" permissions; the problem is just that I still have the missing entries when logged in as admin - but not as other users with admin-rights; they work well.

Q: Anyway, without a full dump of your database it is just a guessing game. Can you provide this?

A: The database holds a lot of data for projects where we signed NDAs so I am not allowed by security policies to give this away - sorry for that.

c_schmitz

c_schmitz

2014-11-22 18:26

administrator   ~31051

Have you checked the permissions on the main admin using another superadmin?

wolki

wolki

2014-11-24 11:46

reporter   ~31078

I have a user with admin rights (I see no way making it a super-admin). I re-set the admin password by using the second admin user, which did not change anything.
Then I had a look at MySQLAdmin at the "permissions" table - I set the zeros to ones for superadmin - but also no effect on the problem.

wolki

wolki

2014-11-24 11:47

reporter   ~31079

I uploaded a screenshot of MySQLAdmin and the table where I changed the 0 to 1:
LimesurveyAdminProblem.png

c_schmitz

c_schmitz

2014-11-24 16:42

administrator   ~31084

Setting the readp permission to get superadmin permissions should be enough - the table looks okay, but you painted over the user ID so you should check if the user ID is the right one.
I cannot reproduce the issue here. If you want me to take a closer look I would need a dump of the user table and the permission table. You can send it to carsten.schmitz@limesurvey.org if you like - all data will be treated confidentially.

moreover47

moreover47

2015-02-28 01:46

reporter   ~31734

i've just experienced this too. More serious for me as I only have one user... oops. Will email c_schmitz with my sql dump.

moreover47

moreover47

2015-02-28 05:42

reporter   ~31735

actually, just recovered my admin permissions by recreating a global superadmin permission record. But will avoid survey copying from now on

c_schmitz

c_schmitz

2015-05-12 15:49

administrator   ~32190

Last edited: 2015-05-12 15:49

Moreover47, thank you for the dump but I was not able to find out by it what is wrong or why it happpened. I vetted the code for places but did not find anything where the deletion might occur. Helpful would be a database dump from right before the incident but I suppose it does not exist. It seems to happen only under very specific circumstances which I can't find out.

Can you try to backup your database, copy a survey again and see if you have the error, again?

c_schmitz

c_schmitz

2015-12-08 17:06

administrator   ~33761

Closed due to missing feedback.

Issue History

Date Modified Username Field Change
2014-10-27 16:46 wolki New Issue
2014-10-27 16:46 wolki File Added: limesurvey_survey_946675.lss
2014-10-28 12:07 wolki Issue Monitored: wolki
2014-10-28 12:08 wolki File Added: LimesurveyMissingMenu.PNG
2014-10-28 12:08 wolki Note Added: 30879
2014-10-29 19:22 c_schmitz Note Added: 30883
2014-10-29 19:22 c_schmitz Assigned To => c_schmitz
2014-10-29 19:22 c_schmitz Status new => feedback
2014-10-30 12:51 wolki Note Added: 30895
2014-10-30 12:51 wolki Status feedback => assigned
2014-11-22 18:26 c_schmitz Note Added: 31051
2014-11-22 18:26 c_schmitz Status assigned => feedback
2014-11-24 11:46 wolki Note Added: 31078
2014-11-24 11:46 wolki Status feedback => assigned
2014-11-24 11:46 wolki File Added: LimesurveyAdminProblem.png
2014-11-24 11:47 wolki Note Added: 31079
2014-11-24 16:42 c_schmitz Note Added: 31084
2014-11-24 16:42 c_schmitz Status assigned => feedback
2014-12-09 13:56 c_schmitz Status feedback => closed
2014-12-09 13:56 c_schmitz Resolution open => unable to reproduce
2014-12-09 14:15 c_schmitz Status closed => assigned
2015-02-28 01:46 moreover47 Note Added: 31734
2015-02-28 05:42 moreover47 Note Added: 31735
2015-05-12 15:49 c_schmitz Note Added: 32190
2015-05-12 15:49 c_schmitz Status assigned => feedback
2015-05-12 15:49 c_schmitz Note Edited: 32190
2015-12-08 17:06 c_schmitz Note Added: 33761
2015-12-08 17:06 c_schmitz Status feedback => closed
2021-08-03 21:16 guest Bug heat 6 => 8