View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
05589Bug reportsAuthenticationpublic2011-11-21 09:562012-03-14 21:08
Reporteruser16048Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.91+ 
Fixed in Version1.91+ 
Summary05589: Cannot delete own user account
Description

I tried to delete my own user account (not "admin") and got an SQL error.

Steps To Reproduce
  • Login as "admin"
  • Add user "test1" (all rights expect super admin)
  • Login as "test1"
  • Add user "test2"
  • Delete user "test1" using his own account (delete button)
  • Get SQL error
  • User "test1" was deleted correctly
Additional Information

URL: http://.../umfragen/admin/admin.php?action=deluser
SQL error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and permission='survey' and read_p=1) order by active DESC, surveyls_title' at line 1: SELECT a.*, surveyls_title, surveyls_description, surveyls_welcometext, surveyls_url FROM lime_surveys AS a INNER JOIN lime_surveys_languagesettings on (surveyls_survey_id=a.sid and surveyls_language=a.language) WHERE a.sid in (select sid from lime_survey_permissions where uid= and permission='survey' and read_p=1) order by active DESC, surveyls_title

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)11343
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL Community Server 5.5.8
Server OS (if known)Windows Server 2008 R2 Standard
Webserver software & version (if known)Apache 2.2.17
PHP Version5.2.17

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2011-12-29 19:11

administrator   ~16760

Actually users should never be able to delete their own accounts.
c_schmitz

c_schmitz

2012-02-06 14:26

administrator   ~17251

New 1.91+ version released.

Related Changesets

LimeSurvey: Yii 9522b78b

2012-01-30 16:32:52

c_schmitz

Details Diff 		Fixed issue 05589: Error messages when user deletes himself

git-svn-id: file:///Users/Shitiz/Downloads/lssvn/source/limesurvey_yii@12261 b72ed6b6-b9f8-46b5-92b4-906544132732		 Affected Issues
05589
mod - application/controllers/admin/useraction.php Diff File

Issue History

Date Modified Username Field Change
2011-11-21 09:56 user16048 New Issue
2011-12-29 19:10 c_schmitz Assigned To => c_schmitz
2011-12-29 19:10 c_schmitz Status new => assigned
2011-12-29 19:11 c_schmitz Note Added: 16760
2012-01-31 01:30 c_schmitz Status assigned => resolved
2012-01-31 01:30 c_schmitz Fixed in Version => 1.91+
2012-01-31 01:30 c_schmitz Resolution open => fixed
2012-02-06 14:26 c_schmitz Note Added: 17251
2012-02-06 14:26 c_schmitz Status resolved => closed
2012-03-14 21:08 c_schmitz Changeset attached => Import 2012-03-09 13:30:34 Yii 9522b78b