View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
08241Bug reportsLimeSurvey Websitepublic2013-10-07 08:53
Reporterelisanderk Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Summary08241: Property "User.superadmin" is not defined
Description

I cannot access the backend of limeSurvey. When I try to log-in with my username and pw I get this message:

Internal Server Error
Property "User.superadmin" is not defined.
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

The Problem appeared after using the automated update mechanism.

I have activate the debug mode in my /application/config/config.php and added the detailed error dump. I have looked at the debug report, but I cannot figure out what to do to correct the error. Hope someone can help me.

TagsNo tags attached.
Attached Files
Bug heat4
Complete LimeSurvey version number (& build)build 130923
I will donate to the project if issue is resolvedNo
BrowserGoogle Crome
Database type & versionMySQL ver.5.1.66
Server OS (if known)WWW.one.com - dont know
Webserver software & version (if known)Apache/2.2.16(debian)
PHP VersionVersion information: 3.5.8.1
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-10-06 19:01

administrator   ~26547

What was the previous version before you updated?

elisanderk

elisanderk

2013-10-06 20:04

reporter   ~26548

I installed version 2.00+ build 130802 on the 25th August (as far as I remember).
I updated automatically from LimeSurvey as the system said "Update available: 2.00+ (130929).

c_schmitz

c_schmitz

2013-10-06 20:41

administrator   ~26549

Can you use a MySQL tool like myAdmin and check if there is a superadmin column in the users table?

elisanderk

elisanderk

2013-10-06 20:56

reporter   ~26550

There is. See attached file.

c_schmitz

c_schmitz

2013-10-06 21:12

administrator   ~26551

The PDF is cut off but I take your word for it ;).

c_schmitz

c_schmitz

2013-10-06 21:15

administrator   ~26552

Between line 240 and 241 of limesurvey/application/controllers/AdminController.php
insert the following line:

var_dump($user);die();

Then try to login again.
Post the resulting output please (best as HTML source).

elisanderk

elisanderk

2013-10-06 21:32

reporter   ~26553

OK. I have found the file using my FileZila but when I try to edit I get a mass downloaded to my notebook. I tried to download and open the file with MS word. It works well except for line numbers. There is none.

elisanderk

elisanderk

2013-10-06 21:46

reporter   ~26554

I have attached the file.

elisanderk

elisanderk

2013-10-06 22:18

reporter   ~26555

I have put in the line as above. LimeSurvey returned a lot - see link: http://www.elisanderk.dk/limesurvey/index.php/admin/authentication/sa/login

elisanderk

elisanderk

2013-10-06 22:21

reporter   ~26556

I also include a copy of the screen after putting in the new line.

c_schmitz

c_schmitz

2013-10-06 22:52

administrator   ~26557

Can you post the phpMyAdmin excerpt of the table again but complete, please?

c_schmitz

c_schmitz

2013-10-06 22:54

administrator   ~26558

Also let me know what PHP version you are using (NOT phpMyAdmin version)

elisanderk

elisanderk

2013-10-06 23:24

reporter   ~26559

About One.com:
PHP

Current PHP version: 5.3.27
safe_mode = OFF
memory_limit = 128MB
upload_max_filesize = 96MB
post_max_size = 96MB
max_execution_time = 50 sec
For image processing we offer GD2, but not ImageMagick.
Full details on One.com's PHP configuration: http://www.one-docs.com/php5.

Be aware that you cannot change the PHP configuration, except for display_errors which is deactivated per default, but can be activated in the control panel.

MySQL

MySQL version = 5.1.66-0+squeeze1
MySQL driver version: mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $
max_user_connections = 24
max_allowed_packet = 16 MB
Further details on MySQL variables: http://www.one-docs.com/mysql

elisanderk

elisanderk

2013-10-06 23:32

reporter   ~26560

About " phpMyAdmin excerpt of the table" I'm not quite sure what you mean. I have attache a file shoing what I get when I use Select from the user-tabel.

c_schmitz

c_schmitz

2013-10-06 23:49

administrator   ~26561

Well if you look at the Select you did you can see that the superadmin field is missing.
Did you maybe install a newer version of LimeSUrvey like 2.05 at the same time using the same database and/or then went back to 2.0? That would be the only explanation for the missing fields as the database was being upgraded and it is impossible to go back from 2.05 to 2.0.

elisanderk

elisanderk

2013-10-07 06:47

reporter   ~26564

I am not aware that I have done so, but I can not rule it out.
However, is it possible to solve the problem?
Can you show me a way to do it?

c_schmitz

c_schmitz

2013-10-07 08:53

administrator   ~26566

Either you have a backup of your database you can go back to from before whenever this happened or you update your version manually to 2.05. Version 2.05 generally works, just might have a couple bugs here and there.

Issue History

Date Modified Username Field Change
2013-10-06 16:59 elisanderk New Issue
2013-10-06 16:59 elisanderk Status new => assigned
2013-10-06 16:59 elisanderk Assigned To => c_schmitz
2013-10-06 16:59 elisanderk File Added: debug_report_20131006.odt
2013-10-06 19:01 c_schmitz Note Added: 26547
2013-10-06 19:01 c_schmitz Status assigned => feedback
2013-10-06 20:04 elisanderk Note Added: 26548
2013-10-06 20:04 elisanderk Status feedback => assigned
2013-10-06 20:41 c_schmitz Note Added: 26549
2013-10-06 20:42 c_schmitz Status assigned => feedback
2013-10-06 20:56 elisanderk File Added: dbadmin.one.com _ 10.246.16.24 _ elisanderk_dk _ lime_users _ phpMyAdmin 3.5.8.pdf
2013-10-06 20:56 elisanderk Note Added: 26550
2013-10-06 20:56 elisanderk Status feedback => assigned
2013-10-06 21:12 c_schmitz Note Added: 26551
2013-10-06 21:15 c_schmitz Note Added: 26552
2013-10-06 21:32 elisanderk Note Added: 26553
2013-10-06 21:46 elisanderk File Added: AdminController.php
2013-10-06 21:46 elisanderk Note Added: 26554
2013-10-06 22:18 elisanderk Note Added: 26555
2013-10-06 22:20 elisanderk File Added: Screendump after putting in the new line.odt
2013-10-06 22:21 elisanderk Note Added: 26556
2013-10-06 22:52 c_schmitz Note Added: 26557
2013-10-06 22:53 c_schmitz File Deleted: AdminController.php
2013-10-06 22:54 c_schmitz Note Added: 26558
2013-10-06 23:24 elisanderk Note Added: 26559
2013-10-06 23:32 elisanderk Note Added: 26560
2013-10-06 23:33 elisanderk File Added: Selict_from_line_users.odt
2013-10-06 23:49 c_schmitz Note Added: 26561
2013-10-06 23:50 c_schmitz File Deleted: Screendump after putting in the new line.odt
2013-10-07 00:04 c_schmitz Status assigned => resolved
2013-10-07 00:04 c_schmitz Resolution open => unable to reproduce
2013-10-07 06:47 elisanderk Note Added: 26564
2013-10-07 08:53 c_schmitz Note Added: 26566
2013-10-07 08:53 c_schmitz Status resolved => closed