Delete user should remove menu / page security
Bug #879235 reported by
Dan Garner
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Xibo |
Fix Released
|
Low
|
Dan Garner | ||
Bug Description
Not able to delete a user. It says "this user has been active, you may only retire them".
The log says this:
Delete User Error Log:
<errormsg>This user has been active, you may only retire them.</errormsg>
<errornum>
<errortype>User Error</errortype>
<scriptname>
<scriptlinenum>
Delete Group Error Log:
<errormsg>The query [DELETE FROM `group` WHERE groupid = 4] failed to execute<br />MySQL error: Cannot delete or update a parent row: a foreign key constraint fails (`xibo`
<errornum>
<errortype>User Notice</errortype>
<scriptname>
<scriptlinenum>
Why can't I delete? I have no option to retire a user?
Related branches
lp://staging/~dangarner/xibo/server-132
- Xibo Maintainters: Pending requested
-
Diff: 1890 lines (+1072/-176)30 files modifiedserver/install/database/43.sql (+5/-0)
server/install/database/44.sql (+48/-0)
server/lib/app/helpmanager.class.php (+1/-1)
server/lib/data/display.data.class.php (+33/-3)
server/lib/data/layout.data.class.php (+51/-2)
server/lib/data/layoutgroupsecurity.data.class.php (+39/-0)
server/lib/data/layoutmediagroupsecurity.data.class.php (+88/-0)
server/lib/data/layoutregiongroupsecurity.data.class.php (+40/-0)
server/lib/data/media.data.class.php (+67/-0)
server/lib/data/usergroup.data.class.php (+57/-1)
server/lib/include.php (+3/-3)
server/lib/js/index.js (+71/-1)
server/lib/js/mediamanager.js (+8/-33)
server/lib/js/stats.js (+7/-2)
server/lib/modules/module.class.php (+74/-4)
server/lib/pages/admin.class.php (+12/-0)
server/lib/pages/content.class.php (+12/-2)
server/lib/pages/display.class.php (+1/-1)
server/lib/pages/displaygroup.class.php (+5/-7)
server/lib/pages/index.class.php (+42/-35)
server/lib/pages/layout.class.php (+11/-1)
server/lib/pages/mediamanager.class.php (+41/-1)
server/lib/pages/region.class.php (+19/-3)
server/lib/pages/stats.class.php (+246/-35)
server/lib/pages/user.class.php (+68/-38)
server/lib/service/xmdssoap.class.php (+3/-1)
server/locale/dbtranslate.php (+2/-0)
server/modules/module_db_mysql.php (+12/-0)
server/modules/module_user_general.php (+5/-1)
server/template/header.php (+1/-1)
lp://staging/~dangarner/xibo/server-133
- Xibo Maintainters: Pending requested
-
Diff: 15099 lines (+8047/-3854) (has conflicts)101 files modifiedserver/3rdparty/jQuery/css/jquery-ui.css (+565/-0)
server/3rdparty/jQuery/datePicker.css (+0/-136)
server/3rdparty/jQuery/jquery-ui.min.js (+356/-0)
server/3rdparty/jQuery/jquery-ui.packed.js (+0/-1012)
server/3rdparty/jQuery/jquery.bgiframe.min.js (+0/-10)
server/3rdparty/jQuery/jquery.min.js (+4/-154)
server/3rdparty/jQuery/ui-elements.css (+0/-404)
server/index.php (+1/-1)
server/install/database/45.sql (+212/-0)
server/install/database/46.php (+79/-0)
server/install/database/46.sql (+16/-0)
server/install/database/47.sql (+34/-0)
server/lib/app/helpmanager.class.php (+1/-4)
server/lib/app/kit.class.php (+4/-5)
server/lib/app/responsemanager.class.php (+1/-1)
server/lib/app/translationengine.class.php (+1/-1)
server/lib/data/campaign.data.class.php (+190/-0)
server/lib/data/campaignsecurity.data.class.php (+188/-0)
server/lib/data/data.class.php (+6/-2)
server/lib/data/display.data.class.php (+15/-7)
server/lib/data/displaygroup.data.class.php (+6/-0)
server/lib/data/displaygroupsecurity.data.class.php (+42/-9)
server/lib/data/help.data.class.php (+89/-0)
server/lib/data/layout.data.class.php (+74/-10)
server/lib/data/layoutgroupsecurity.data.class.php (+0/-188)
server/lib/data/maintenance.data.class.php (+73/-0)
server/lib/data/schedule.data.class.php (+37/-33)
server/lib/data/userdata.data.class.php (+88/-0)
server/lib/data/usergroup.data.class.php (+7/-0)
server/lib/include.php (+2/-2)
server/lib/js/campaign.js (+47/-0)
server/lib/js/core.js (+32/-6)
server/lib/js/display.js (+30/-1)
server/lib/js/functions.js (+0/-28)
server/lib/js/layout.js (+106/-50)
server/lib/modules/module.class.php (+93/-10)
server/lib/pages/admin.class.php (+172/-9)
server/lib/pages/campaign.class.php (+656/-0)
server/lib/pages/content.class.php (+166/-198)
server/lib/pages/dataset.class.php (+5/-5)
server/lib/pages/display.class.php (+240/-5)
server/lib/pages/displaygroup.class.php (+249/-228)
server/lib/pages/group.class.php (+8/-8)
server/lib/pages/help.class.php (+430/-95)
server/lib/pages/index.class.php (+2/-2)
server/lib/pages/layout.class.php (+388/-608)
server/lib/pages/license.class.php (+2/-2)
server/lib/pages/module.class.php (+241/-27)
server/lib/pages/oauth.class.php (+3/-3)
server/lib/pages/region.class.php (+66/-0)
server/lib/pages/schedule.class.php (+75/-50)
server/lib/pages/stats.class.php (+6/-2)
server/lib/pages/user.class.php (+170/-45)
server/lib/service/xmdssoap.class.php (+107/-17)
server/locale/dbtranslate.php (+13/-2)
server/modules/HtmlTemplate.htm (+0/-161)
server/modules/datasetview.module.php (+32/-4)
server/modules/embedded.module.php (+2/-8)
server/modules/image.module.php (+11/-0)
server/modules/module_db_mysql.php (+1/-1)
server/modules/module_user_general.php (+237/-103)
server/modules/preview/HtmlTemplate.htm (+40/-0)
server/modules/preview/HtmlTemplateForGetResource.html (+375/-0)
server/modules/preview/jquery-cycle.min.js (+6/-0)
server/modules/preview/jquery.fittext.js (+45/-0)
server/modules/preview/jquery.marquee.js (+156/-0)
server/modules/preview/jquery.min.js (+4/-0)
server/modules/preview/xibo-text-render.js (+119/-0)
server/modules/shellcommand.module.php (+263/-0)
server/modules/text.module.php (+116/-32)
server/modules/ticker.module.php (+148/-47)
server/modules/webpage.module.php (+66/-13)
server/template/css/forms.css (+2/-2)
server/template/css/links.css (+13/-0)
server/template/css/presentation.css (+21/-2)
server/template/css/timeline.css (+206/-0)
server/template/css/xibo.css (+21/-18)
server/template/footer.php (+1/-1)
server/template/header.php (+10/-44)
server/template/pages/campaign_view.php (+82/-0)
server/template/pages/content_view.php (+38/-9)
server/template/pages/dataset_view.php (+33/-1)
server/template/pages/display_view.php (+33/-2)
server/template/pages/displaygroup_view.php (+33/-1)
server/template/pages/fault_view.php (+34/-1)
server/template/pages/group_view.php (+32/-1)
server/template/pages/help_view.php (+49/-0)
server/template/pages/layout_edit.php (+3/-2)
server/template/pages/layout_view.php (+31/-1)
server/template/pages/license_view.php (+34/-3)
server/template/pages/log_view.php (+33/-1)
server/template/pages/login_box.php (+14/-7)
server/template/pages/module_view.php (+76/-0)
server/template/pages/oauth_view.php (+32/-1)
server/template/pages/resolution_view.php (+34/-2)
server/template/pages/schedule_view.php (+1/-1)
server/template/pages/sessions_view.php (+32/-1)
server/template/pages/settings_view.php (+33/-1)
server/template/pages/stats_view.php (+33/-1)
server/template/pages/template_view.php (+32/-1)
server/template/pages/user_view.php (+32/-1)
| Changed in xibo: | |
| milestone: | none → 1.3.2 |
Revision history for this message
| Dan Garner (dangarner) wrote | #1 |
| Changed in xibo: | |
| status: | New → In Progress |
| assignee: | nobody → Dan Garner (dangarner) |
| importance: | Undecided → Low |
| Changed in xibo: | |
| milestone: | 1.3.2 → 1.3.3 |
| Changed in xibo: | |
| status: | In Progress → Fix Committed |
| Changed in xibo: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
Work in progress... lots of things to consider when deleting a user. Started by correctly detecting everything that will prevent a clean delete - before we start the delete process.