Delete User Group doesn't delete associated permissions.
Bug #1390200 reported by
Dan Garner
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Xibo |
Fix Committed
|
Undecided
|
Dan Garner | ||
| 1.6 |
Triaged
|
Undecided
|
Dan Garner | ||
| 1.7 |
Fix Committed
|
Undecided
|
Dan Garner | ||
Bug Description
I run version 1.6.4
When I try to delete a User group I get:
"Unable to delete User Group"
Here's what i get in the error log:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`xibo`
I notice the word Campaign in this error message... however I don't have/use campaigns.
This problem, or something like this as I recall, was also present in version 1.6.1/2 and was supposedly fixed in 1.6.3.
Can someone please help as to why this happens and how I can resolve it?
Thanks!
Related branches
lp:~dangarner/xibo/server-170-beta
- Xibo Maintainters: Pending requested
-
Diff: 58361 lines (+29355/-21813)360 files modified.bzrignore (+1/-0)
Vagrantfile (+1/-0)
manual/generate.php (+170/-0)
manual/libraries/bootstrap/css/bootstrap-theme.css (+459/-0)
manual/libraries/bootstrap/css/bootstrap-theme.min.css (+9/-0)
manual/libraries/bootstrap/css/bootstrap.css (+7098/-0)
manual/libraries/bootstrap/css/bootstrap.min.css (+9/-0)
manual/libraries/bootstrap/fonts/glyphicons-halflings-regular.svg (+229/-0)
manual/libraries/bootstrap/js/bootstrap.js (+2002/-0)
manual/libraries/bootstrap/js/bootstrap.min.js (+9/-0)
manual/libraries/jquery/jquery-1.9.1.js (+5/-0)
manual/libraries/parsedown/parsedown.php (+1426/-0)
manual/source/en/advanced.md (+1/-0)
manual/source/en/advanced_contributing.md (+192/-143)
manual/source/en/advanced_database_model.md (+4/-25)
manual/source/en/advanced_modules.md (+256/-0)
manual/source/en/advanced_pyclient_libbrowsernode_build.md (+99/-0)
manual/source/en/advanced_theme.md (+25/-45)
manual/source/en/api.md (+2/-0)
manual/source/en/api_datasets.md (+277/-204)
manual/source/en/api_displaygroups.md (+18/-11)
manual/source/en/api_displays.md (+9/-8)
manual/source/en/api_layouts.md (+349/-253)
manual/source/en/api_library.md (+179/-132)
manual/source/en/api_methods.md (+45/-55)
manual/source/en/api_misc.md (+11/-10)
manual/source/en/api_modules.md (+20/-18)
manual/source/en/api_oauth.md (+68/-88)
manual/source/en/api_resolution.md (+3/-3)
manual/source/en/api_schedule.md (+10/-7)
manual/source/en/api_template.md (+22/-21)
manual/source/en/cms_maintenance.md (+183/-0)
manual/source/en/cms_settings.md (+108/-0)
manual/source/en/displays.md (+154/-0)
manual/source/en/displays_fileassociations.md (+12/-0)
manual/source/en/displays_groups.md (+15/-0)
manual/source/en/displays_metrics.md (+22/-0)
manual/source/en/displays_settings.md (+32/-0)
manual/source/en/displays_wakeonlan.md (+17/-0)
manual/source/en/faq_reset_admin_password.md (+11/-0)
manual/source/en/index.md (+48/-0)
manual/source/en/install_cms.md (+107/-0)
manual/source/en/install_environment.md (+133/-121)
manual/source/en/install_python_client.md (+197/-0)
manual/source/en/install_windows_client.md (+132/-0)
manual/source/en/install_windows_client_multiple.md (+13/-0)
manual/source/en/install_windows_client_screensaver.md (+15/-0)
manual/source/en/install_windows_client_watchdog.md (+63/-0)
manual/source/en/layouts.md (+44/-0)
manual/source/en/layouts_campaigns.md (+18/-0)
manual/source/en/layouts_designer.md (+55/-0)
manual/source/en/layouts_playlists.md (+47/-0)
manual/source/en/layouts_previewing.md (+13/-0)
manual/source/en/layouts_regions.md (+56/-0)
manual/source/en/layouts_resolutions.md (+17/-0)
manual/source/en/layouts_templates.md (+13/-0)
manual/source/en/layouts_transitions.md (+30/-57)
manual/source/en/licence_information.md (+43/-0)
manual/source/en/media.md (+38/-0)
manual/source/en/media_datasets.md (+98/-125)
manual/source/en/media_library.md (+26/-0)
manual/source/en/media_module_clock.md (+20/-0)
manual/source/en/media_module_counter.md (+40/-0)
manual/source/en/media_module_dataset_view.md (+128/-0)
manual/source/en/media_module_embedded.md (+37/-0)
manual/source/en/media_module_flash.md (+15/-0)
manual/source/en/media_module_font.md (+27/-0)
manual/source/en/media_module_genericfile.md (+13/-0)
manual/source/en/media_module_image.md (+16/-0)
manual/source/en/media_module_localvideo.md (+20/-0)
manual/source/en/media_module_powerpoint.md (+43/-0)
manual/source/en/media_module_shellcommand.md (+51/-0)
manual/source/en/media_module_text.md (+20/-0)
manual/source/en/media_module_ticker.md (+122/-0)
manual/source/en/media_module_video.md (+14/-0)
manual/source/en/media_module_weather.md (+77/-0)
manual/source/en/media_module_webpage.md (+34/-0)
manual/source/en/media_modules.md (+26/-83)
manual/source/en/python_client_hardware.md (+109/-0)
manual/source/en/release_notes.md (+58/-0)
manual/source/en/release_notes_1.0.0.md (+1/-22)
manual/source/en/release_notes_1.0.1.md (+1/-22)
manual/source/en/release_notes_1.0.2.md (+1/-22)
manual/source/en/release_notes_1.0.3.md (+1/-22)
manual/source/en/release_notes_1.0.4.md (+1/-22)
manual/source/en/release_notes_1.0.5.md (+1/-22)
manual/source/en/release_notes_1.0.6.md (+1/-22)
manual/source/en/release_notes_1.0.7.md (+1/-22)
manual/source/en/release_notes_1.0.8.md (+1/-22)
manual/source/en/release_notes_1.1.0.md (+3/-24)
manual/source/en/release_notes_1.1.1.md (+3/-24)
manual/source/en/release_notes_1.2.0.md (+3/-24)
manual/source/en/release_notes_1.2.0rc1.md (+3/-24)
manual/source/en/release_notes_1.2.0rc2.md (+3/-24)
manual/source/en/release_notes_1.2.1.md (+3/-24)
manual/source/en/release_notes_1.2.2.md (+3/-24)
manual/source/en/release_notes_1.2.3.md (+3/-24)
manual/source/en/release_notes_1.3.0.md (+3/-24)
manual/source/en/release_notes_1.3.1.md (+3/-24)
manual/source/en/release_notes_1.3.2.md (+3/-24)
manual/source/en/release_notes_1.3.3.md (+3/-24)
manual/source/en/release_notes_1.4.0.md (+3/-24)
manual/source/en/release_notes_1.4.0rc1.md (+3/-24)
manual/source/en/release_notes_1.4.1.md (+3/-24)
manual/source/en/release_notes_1.4.2.md (+3/-24)
manual/source/en/release_notes_1.5.0.md (+3/-24)
manual/source/en/release_notes_1.5.1.md (+3/-24)
manual/source/en/release_notes_1.5.2.md (+3/-24)
manual/source/en/release_notes_1.6.0-rc1.md (+6/-29)
manual/source/en/release_notes_1.6.0-rc2.md (+6/-29)
manual/source/en/release_notes_1.6.0.md (+53/-82)
manual/source/en/release_notes_1.6.1.md (+49/-78)
manual/source/en/release_notes_1.6.2.md (+55/-83)
manual/source/en/release_notes_1.6.3.md (+55/-83)
manual/source/en/release_notes_1.7.0-alpha.md (+55/-82)
manual/source/en/release_notes_1.7.0-alpha2.md (+56/-84)
manual/source/en/release_notes_1.7.0-beta.md (+57/-0)
manual/source/en/release_notes_clonedb.md (+91/-81)
manual/source/en/scheduling.md (+14/-0)
manual/source/en/scheduling_calendar.md (+35/-0)
manual/source/en/scheduling_events.md (+25/-0)
manual/source/en/scheduling_now.md (+15/-0)
manual/source/en/toc/advanced.md (+7/-0)
manual/source/en/toc/api.md (+12/-0)
manual/source/en/toc/displays.md (+6/-0)
manual/source/en/toc/getting_started.md (+9/-0)
manual/source/en/toc/layouts.md (+9/-0)
manual/source/en/toc/media.md (+20/-0)
manual/source/en/toc/nav_bar.html (+8/-0)
manual/source/en/toc/scheduling.md (+4/-0)
manual/source/en/toc/tour.md (+9/-0)
manual/source/en/toc/users.md (+5/-0)
manual/source/en/tour.md (+65/-0)
manual/source/en/tour_forms.md (+26/-0)
manual/source/en/tour_grids.md (+31/-0)
manual/source/en/tour_guides.md (+14/-0)
manual/source/en/tour_icon_dashboard.md (+9/-0)
manual/source/en/tour_login.md (+26/-0)
manual/source/en/tour_media_dashboard.md (+7/-0)
manual/source/en/tour_navigation.md (+46/-0)
manual/source/en/tour_status_dashboard.md (+7/-0)
manual/source/en/troubleshooting.md (+9/-0)
manual/source/en/users.md (+14/-0)
manual/source/en/users_administration.md (+27/-0)
manual/source/en/users_groups.md (+20/-0)
manual/source/en/users_permissions.md (+57/-0)
manual/source/en/users_user_types.md (+26/-0)
manual/source/fr/advanced_contributing.md (+197/-140)
manual/source/fr/index.md (+48/-0)
manual/source/fr/install_cms.md (+107/-0)
manual/source/fr/install_windows_client.md (+122/-0)
manual/template/footer.html (+55/-0)
manual/template/header.html (+56/-0)
manual/template/index.html (+12/-0)
manual/template/manual.css (+142/-0)
manual/template/template.php (+15/-0)
server/3rdparty/parsedown/parsedown.php (+1426/-0)
server/3rdparty/simplepie/library/SimplePie/File.php (+6/-3)
server/config/client.config.php (+12/-12)
server/config/config.class.php (+20/-0)
server/install.php (+14/-5)
server/install/database/22.sql (+0/-1)
server/install/database/23.sql (+0/-3)
server/install/database/3.sql (+0/-16)
server/install/database/42.sql (+0/-1)
server/install/database/80.sql (+54/-54)
server/install/database/81.sql (+1/-1)
server/install/database/82.sql (+253/-0)
server/install/master/data.sql (+98/-111)
server/install/master/structure.sql (+23/-38)
server/lib/app/cache.class.php (+78/-32)
server/lib/app/datemanager.class.php (+34/-30)
server/lib/app/debug.class.php (+58/-16)
server/lib/app/formmanager.class.php (+2/-2)
server/lib/app/helpmanager.class.php (+37/-71)
server/lib/app/kit.class.php (+28/-0)
server/lib/app/pagemanager.class.php (+14/-0)
server/lib/app/pdoconnect.class.php (+51/-44)
server/lib/app/translationengine.class.php (+1/-1)
server/lib/data/dataset.data.class.php (+153/-133)
server/lib/data/display.data.class.php (+40/-3)
server/lib/data/displayprofile.data.class.php (+6/-4)
server/lib/data/layout.data.class.php (+690/-140)
server/lib/data/media.data.class.php (+472/-23)
server/lib/data/region.data.class.php (+657/-634)
server/lib/data/schedule.data.class.php (+1/-1)
server/lib/data/tag.data.class.php (+57/-0)
server/lib/data/template.data.class.php (+0/-156)
server/lib/data/templategroupsecurity.data.class.php (+0/-132)
server/lib/data/usergroup.data.class.php (+24/-6)
server/lib/include.php (+15/-2)
server/lib/modules/module.class.php (+127/-66)
server/lib/oauth.inc.php (+1/-1)
server/lib/pages/admin.class.php (+4/-19)
server/lib/pages/campaign.class.php (+28/-23)
server/lib/pages/clock.class.php (+36/-40)
server/lib/pages/content.class.php (+12/-4)
server/lib/pages/display.class.php (+2/-3)
server/lib/pages/displaygroup.class.php (+3/-3)
server/lib/pages/help.class.php (+0/-59)
server/lib/pages/install.class.php (+10/-1)
server/lib/pages/layout.class.php (+207/-37)
server/lib/pages/log.class.php (+21/-5)
server/lib/pages/mediamanager.class.php (+10/-1)
server/lib/pages/module.class.php (+72/-1)
server/lib/pages/preview.class.php (+12/-28)
server/lib/pages/schedule.class.php (+9/-13)
server/lib/pages/statusdashboard.class.php (+12/-4)
server/lib/pages/template.class.php (+167/-198)
server/lib/pages/timeline.class.php (+11/-4)
server/lib/pages/upgrade.class.php (+3/-0)
server/lib/service/rest.class.php (+5/-7)
server/lib/service/service_v3.wsdl (+253/-0)
server/lib/service/service_v4.wsdl (+0/-11)
server/lib/service/serviceresponse.class.php (+3/-3)
server/lib/service/xmdssoap3.class.php (+1237/-0)
server/lib/service/xmdssoap4.class.php (+29/-96)
server/lib/xmds.inc.php (+13/-1)
server/locale/dbtranslate.php (+9/-2)
server/maintenance.php (+14/-1)
server/manual/content/admin/advanced.php (+0/-44)
server/manual/content/admin/api_overview.php (+0/-25)
server/manual/content/admin/blueprints.php (+0/-24)
server/manual/content/admin/display_wakeonlan.php (+0/-78)
server/manual/content/admin/displaygroups.php (+0/-53)
server/manual/content/admin/displayprofiles.php (+0/-47)
server/manual/content/admin/displays.php (+0/-163)
server/manual/content/admin/displaystats.php (+0/-44)
server/manual/content/admin/fileassociations.php (+0/-33)
server/manual/content/admin/module_overview.php (+0/-41)
server/manual/content/admin/module_template.php (+0/-229)
server/manual/content/admin/overview.php (+0/-24)
server/manual/content/admin/pyclient_libbrowsernode_build.php (+0/-98)
server/manual/content/admin/release_notes.php (+0/-23)
server/manual/content/admin/settings.php (+0/-120)
server/manual/content/admin/settings_maintenance.php (+0/-187)
server/manual/content/content/adding.php (+0/-37)
server/manual/content/content/content_flash.php (+0/-24)
server/manual/content/content/content_genericfile.php (+0/-25)
server/manual/content/content/content_image.php (+0/-32)
server/manual/content/content/content_powerpoint.php (+0/-40)
server/manual/content/content/content_video.php (+0/-24)
server/manual/content/content/deleting.php (+0/-28)
server/manual/content/content/editing.php (+0/-32)
server/manual/content/content/overview.php (+0/-126)
server/manual/content/coreconcepts/dashboard.php (+0/-58)
server/manual/content/coreconcepts/login.php (+0/-33)
server/manual/content/coreconcepts/navbar.php (+0/-77)
server/manual/content/coreconcepts/overview.php (+0/-86)
server/manual/content/error.php (+0/-23)
server/manual/content/install/install_client.php (+0/-212)
server/manual/content/install/install_python_client.php (+0/-196)
server/manual/content/install/install_server.php (+0/-155)
server/manual/content/install/offline_download_client.php (+0/-79)
server/manual/content/install/prerequisites.php (+0/-43)
server/manual/content/install/python_client_hardware.php (+0/-128)
server/manual/content/install/troubleshooting.php (+0/-7)
server/manual/content/intro.php (+0/-68)
server/manual/content/layout/addregion.php (+0/-86)
server/manual/content/layout/assigncontent.php (+0/-60)
server/manual/content/layout/campaign_layout.php (+0/-71)
server/manual/content/layout/content_counter.php (+0/-68)
server/manual/content/layout/content_datasetview.php (+0/-160)
server/manual/content/layout/content_embedded.php (+0/-84)
server/manual/content/layout/content_shellcommand.php (+0/-72)
server/manual/content/layout/content_text.php (+0/-56)
server/manual/content/layout/content_ticker.php (+0/-157)
server/manual/content/layout/content_webpage.php (+0/-60)
server/manual/content/layout/layoutdesigner.php (+0/-98)
server/manual/content/layout/overview.php (+0/-154)
server/manual/content/layout/region_preview_timeline.php (+0/-26)
server/manual/content/license/licenses.php (+0/-68)
server/manual/content/routes.php (+0/-167)
server/manual/content/schedule/changedisplay.php (+0/-24)
server/manual/content/schedule/overview.php (+0/-50)
server/manual/content/schedule/schedule_event.php (+0/-44)
server/manual/content/schedule/schedule_now.php (+0/-53)
server/manual/content/templates/overview.php (+0/-36)
server/manual/content/templates/template_resolution.php (+0/-75)
server/manual/content/toc_app_overview.php (+0/-6)
server/manual/content/toc_developer.php (+0/-12)
server/manual/content/toc_developer_api.php (+0/-19)
server/manual/content/toc_developer_module.php (+0/-5)
server/manual/content/toc_developer_releasenotes.php (+0/-68)
server/manual/content/toc_error.php (+0/-23)
server/manual/content/toc_getting_started.php (+0/-16)
server/manual/content/toc_layouts.php (+0/-18)
server/manual/content/toc_library.php (+0/-13)
server/manual/content/toc_scheduling.php (+0/-5)
server/manual/content/toc_user_and_display.php (+0/-14)
server/manual/content/users/groups.php (+0/-86)
server/manual/content/users/menu_page_security.php (+0/-74)
server/manual/content/users/overview.php (+0/-28)
server/manual/content/users/user_permissions.php (+0/-53)
server/manual/content/users/user_types.php (+0/-35)
server/manual/content/users/users.php (+0/-101)
server/manual/css/manual.css (+0/-124)
server/manual/img/jquery.treeview.css (+0/-47)
server/manual/index.php (+0/-143)
server/manual/lib/bootstrap/css/bootstrap-theme.css (+0/-459)
server/manual/lib/bootstrap/css/bootstrap-theme.min.css (+0/-9)
server/manual/lib/bootstrap/css/bootstrap.css (+0/-7098)
server/manual/lib/bootstrap/css/bootstrap.min.css (+0/-9)
server/manual/lib/bootstrap/fonts/glyphicons-halflings-regular.svg (+0/-229)
server/manual/lib/bootstrap/js/bootstrap.js (+0/-2002)
server/manual/lib/bootstrap/js/bootstrap.min.js (+0/-9)
server/manual/lib/jquery/jquery-1.9.1.js (+0/-5)
server/manual/single.php (+0/-94)
server/manual/template.php (+0/-29)
server/modules/3rdparty/emoji.php (+2082/-0)
server/modules/clock.module.php (+27/-15)
server/modules/counter.module.php (+4/-0)
server/modules/datasetview.module.php (+49/-38)
server/modules/embedded.module.php (+8/-7)
server/modules/font.module.php (+1/-4)
server/modules/forecastio.module.php (+318/-96)
server/modules/image.module.php (+52/-41)
server/modules/localvideo.module.php (+4/-0)
server/modules/microblog.module.php (+0/-295)
server/modules/module_template.php (+14/-3)
server/modules/module_user_general.php (+70/-339)
server/modules/preview/HtmlTemplate.html (+6/-0)
server/modules/preview/fonts.css (+0/-11)
server/modules/preview/html-preview.js (+3/-2)
server/modules/preview/vendor/jquery-cycle-2.1.6.min.js (+15/-0)
server/modules/preview/xibo-text-render.js (+68/-28)
server/modules/preview/xibo-webpage-render.js (+12/-12)
server/modules/shellcommand.module.php (+4/-0)
server/modules/text.module.php (+157/-84)
server/modules/theme/twitter/emoji.css (+721/-0)
server/modules/ticker.module.php (+261/-98)
server/modules/twitter.module.php (+880/-0)
server/modules/video.module.php (+23/-1)
server/modules/webpage.module.php (+15/-14)
server/services.php (+16/-11)
server/theme/default/css/calendar.css (+4/-0)
server/theme/default/html/about_text.php (+13/-28)
server/theme/default/html/campaign_form_layout_assign.php (+1/-1)
server/theme/default/html/footer.php (+6/-2)
server/theme/default/html/form_render.php (+5/-1)
server/theme/default/html/grid_pager.php (+3/-0)
server/theme/default/html/header.php (+2/-1)
server/theme/default/html/homepage_mediamanager_grid.php (+0/-69)
server/theme/default/html/layout_designer.php (+12/-0)
server/theme/default/html/library_form_assign_list.php (+4/-3)
server/theme/default/html/media_form_ticker_edit.php (+1/-1)
server/theme/default/html/new_user_welcome.php (+6/-6)
server/theme/default/html/status_dashboard.php (+1/-1)
server/theme/default/html/table_render.php (+2/-2)
server/theme/default/html/usergroup_form_menusecurity_grid.php (+3/-3)
server/theme/default/html/usergroup_form_pagesecurity_grid.php (+2/-2)
server/theme/default/js/xibo-cms.js (+86/-120)
server/theme/default/js/xibo-forms.js (+112/-5)
server/theme/default/js/xibo-layout-designer.js (+80/-56)
server/theme/default/libraries/bootstrap-datetimepicker/js/bootstrap-datetimepicker.min.js (+1/-0)
server/theme/default/libraries/calendar/js/calendar.js (+2/-2)
server/theme/default/libraries/ckeditor/config.js (+2/-2)
server/theme/default/libraries/ckeditor/contents.css (+1/-1)
server/theme/default/libraries/colors/colors.min.js (+20/-0)
server/theme/default/libraries/jquery-tablesorter/css/theme.bootstrap.css (+38/-0)
To post a comment you must log in.
