Unable to delete user
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Xibo |
Fix Released
|
Medium
|
Dan Garner | ||
Bug Description
I'm on 1.6.1
I can create new Users fine, but when i try to delete a User i get:
"Unable to delete User Group"
I don't have any user groups setup!
Here's what i get in the error log:
11886 2014-07-28 18:36:55 user
<errormsg>Unable to delete User Group.</errormsg>
<errornum>
<errortype>User Error</errortype>
<scriptname>
<scriptlinenum>
11885 2014-07-28 18:36:55 user
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`xibo`
11884 2014-07-28 18:36:55 user
<errormsg>Undefined variable: userID</errormsg>
<errornum>
<errortype>
<scriptname>
<scriptlinenum>
Can someone please help as to why this happens and how can i resolve it?
Thanks!
Related branches
- Xibo Maintainters: Pending requested
-
Diff: 608 lines (+196/-85)21 files modifiedserver/lib/app/kit.class.php (+1/-1)
server/lib/data/dataset.data.class.php (+1/-2)
server/lib/data/datasetdata.data.class.php (+1/-1)
server/lib/data/displaygroup.data.class.php (+9/-5)
server/lib/data/region.data.class.php (+8/-4)
server/lib/data/userdata.data.class.php (+28/-0)
server/lib/data/usergroup.data.class.php (+1/-1)
server/lib/modules/module.class.php (+8/-5)
server/lib/pages/admin.class.php (+7/-7)
server/lib/pages/content.class.php (+1/-1)
server/lib/pages/display.class.php (+7/-5)
server/lib/pages/displaygroup.class.php (+1/-1)
server/lib/pages/schedule.class.php (+17/-12)
server/lib/pages/statusdashboard.class.php (+1/-1)
server/lib/pages/timeline.class.php (+6/-0)
server/lib/pages/user.class.php (+5/-17)
server/lib/service/xmdssoap.class.php (+3/-2)
server/locale/dbtranslate.php (+43/-0)
server/manual/content/admin/api_layouts.php (+39/-16)
server/modules/preview/xibo-webpage-render.js (+6/-1)
server/theme/default/html/status_dashboard.php (+3/-3)
| Dan Garner (dangarner) wrote | #1 |
| Changed in xibo: | |
| milestone: | none → 1.6.3 |
| assignee: | nobody → Dan Garner (dangarner) |
| status: | New → Fix Committed |
| importance: | Undecided → Medium |
| tags: | added: cms |
| Dan Garner (dangarner) wrote | #2 |
| Dan Garner (dangarner) wrote | #3 |
| Dan Garner (dangarner) wrote | #4 |
| Changed in xibo: | |
| status: | Fix Committed → Fix Released |
There are 3 files that will need replacing in a 1.6.2 installation to fix this issue. They are attached.