Xibo

Unable to Remove Empty and Unassigned Display Group

Asked by Colin Slaughter

Upgrade from version 1.6.1 -> 1.62. (Not sure if the problem existed before or not)

I have a Display Group that I cannot delete. I have the correct permissions, it has no displays assigned to it, and now has no files assigned after using this workaround:

https://bugs.launchpad.net/xibo/+bug/1351884

When I try to remove a Display Group I get this message:

Unable to delete Display Group.

A little more information about why would be great, because as far as I can tell I should be able to delete it.

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
Dan Garner
Solved:
Last query:
Last reply:
Revision history for this message
Dan Garner (dangarner) said : 		#1

Getting caught at every turn!

Can you run a report fault wizard so we can see if there are any additional error messages?

Revision history for this message
Colin Slaughter (cslaughter) said : 		#2

Here you go:

--------------------------------------
Environment Checks
--------------------------------------
<div class="checks"><img src="install/dot_green.gif"> PHP Version<br /><img src="install/dot_green.gif"> Filesystem Permissions<br /><img src="install/dot_green.gif"> MySQL database (PHP MySql)<br /><img src="install/dot_green.gif"> MySQL database (PDO MySql)<br /><img src="install/dot_green.gif"> JSON Extension<br /><img src="install/dot_green.gif"> SOAP Extension<br /><img src="install/dot_green.gif"> GD Extension<br /><img src="install/dot_green.gif"> Session<br /><img src="install/dot_green.gif"> FileInfo<br /><img src="install/dot_green.gif"> PCRE<br /><img src="install/dot_green.gif"> Gettext<br /><img src="install/dot_green.gif"> Calendar Extension<br /><img src="install/dot_green.gif"> DOM Extension<br /><img src="install/dot_green.gif"> DOM XML Extension<br /><img src="install/dot_green.gif"> Mcrypt Extension<br /><img src="install/dot_green.gif"> Allow PHP to open external URLs<br /><img src="install/dot_green.gif"> DateTimeZone<br /><img src="install/dot_green.gif"> Large File Uploads<br /></div>
--------------------------------------
LOG Dump
--------------------------------------
Date,Page,Function,Message
"2014-08-07 17:28:33","","","SELECT user.UserID, user.UserName, user.usertypeid, user.loggedin, user.lastaccessed, user.email, user.homepage FROM `user` WHERE 1 = 1 ORDER by UserName"
"2014-08-07 17:28:29","DisplayGroup","Delete","IN"
"2014-08-07 17:28:29","DisplayGroup","DeleteScheduleForDisplayGroup","IN"
"2014-08-07 17:28:29","DisplayGroup","TidyScheduleTable","IN"
"2014-08-07 17:28:29","DisplayGroup","DeleteScheduleForDisplayGroup","OUT"
"2014-08-07 17:28:29","displaygroup","","SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`xibo`.`lkdisplaygroupgroup`, CONSTRAINT `lkdisplaygroupgroup_ibfk_2` FOREIGN KEY (`DisplayGroupID`) REFERENCES `displaygroup` (`DisplayGroupID`))"
"2014-08-07 17:28:29","Data Module","SetError","Data Class: Error Number [25015] Error Message [Unable to delete Display Group.]"
"2014-08-07 17:28:29","displaygroup","","<errormsg>Unable to delete Display Group.</errormsg>
<errornum>256</errornum>
<errortype>User Error</errortype>
<scriptname>/var/www/html/xibo/lib/pages/displaygroup.class.php</scriptname>
<scriptlinenum>407</scriptlinenum>
"
"2014-08-07 17:28:29","displaygroup","","Creating a Response Manager to deal with the HALT Error."
"2014-08-07 17:28:24","","","Retreiving list of displaygroups for <REPLACED_USER_ID> with SQL: SELECT displaygroup.DisplayGroupID, displaygroup.DisplayGroup, displaygroup.IsDisplaySpecific, displaygroup.Description FROM displaygroup WHERE 1 = 1 AND displaygroup.IsDisplaySpecific = 0 ORDER BY displaygroup.DisplayGroup "
"2014-08-07 17:28:22","display","","LastAccessed = 1407293964, Timeout = 12 for displayId 6"
"2014-08-07 17:28:22","display","","LastAccessed = 1407444109, Timeout = 12 for displayId 7"
"2014-08-07 17:28:22","display","","Retreiving list of displaygroups for <REPLACED_USER_ID> with SQL: SELECT displaygroup.DisplayGroupID, displaygroup.DisplayGroup, displaygroup.IsDisplaySpecific, displaygroup.Description FROM displaygroup WHERE 1 = 1 AND displaygroup.IsDisplaySpecific = 0 ORDER BY displaygroup.DisplayGroup "
"2014-08-07 17:28:22","","","LastAccessed = 1407293964, Timeout = 12 for displayId 6"
"2014-08-07 17:28:22","","","LastAccessed = 1407444109, Timeout = 12 for displayId 7"
"2014-08-07 17:27:51","displaygroup","","SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`xibo`.`lkdisplaygroupgroup`, CONSTRAINT `lkdisplaygroupgroup_ibfk_2` FOREIGN KEY (`DisplayGroupID`) REFERENCES `displaygroup` (`DisplayGroupID`))"
"2014-08-07 17:27:51","displaygroup","","<errormsg>Unable to delete Display Group.</errormsg>
<errornum>256</errornum>
<errortype>User Error</errortype>
<scriptname>/var/www/html/xibo/lib/pages/displaygroup.class.php</scriptname>
<scriptlinenum>407</scriptlinenum>
"
"2014-08-07 17:26:46","clock","","SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'pbtt2sp1vh7pm3sb77sppt1ef5' for key 'PRIMARY'"

--------------------------------------
Display Dump
--------------------------------------
DisplayID: 4
Display: Proto1
Default Layout: Wali Logo Only
Logged In: 1
Last Accessed: 1407457673
Interleave: 0
Licensed: 1

DisplayID: 6
Display: Bosco
Default Layout: Wali Logo Only
Logged In: 0
Last Accessed: 1407293964
Interleave: 0
Licensed: 1

DisplayID: 7
Display: Greg
Default Layout: Wali Logo Only
Logged In: 0
Last Accessed: 1407444109
Interleave: 0
Licensed: 1

--------------------------------------
Settings Dump
--------------------------------------
Setting: MEDIA_DEFAULT - Value: private

Setting: LAYOUT_DEFAULT - Value: private

Setting: defaultUsertype - Value: User

Setting: debug - Value: On

Setting: userModule - Value: module_user_general.php

Setting: adminMessage - Value:

Setting: defaultTimezone - Value: America/Los_Angeles

Setting: mail_to - Value: <REPLACED_EMAIL_ADDRESS>

Setting: mail_from - Value: <REPLACED_EMAIL_ADDRESS>

Setting: BASE_URL - Value: http://localhost/xibo/

Setting: jpg_length - Value: 15

Setting: ppt_width - Value: 1024

Setting: ppt_height - Value: 768

Setting: ppt_length - Value: 120

Setting: swf_length - Value: 60

Setting: audit - Value: On

Setting: LIBRARY_LOCATION - Value: /var/www/html/xibo-library/

Setting: HELP_BASE - Value: http://www.xibo.org.uk/manual/

Setting: PHONE_HOME - Value: Off

Setting: PHONE_HOME_URL - Value: http://www.xibo.org.uk/stats/track.php

Setting: PHONE_HOME_DATE - Value: 0

Setting: SERVER_MODE - Value: Production

Setting: MAINTENANCE_ENABLED - Value: Off

Setting: MAINTENANCE_EMAIL_ALERTS - Value: On

Setting: MAINTENANCE_KEY - Value: changeme

Setting: MAINTENANCE_LOG_MAXAGE - Value: 30

Setting: MAINTENANCE_STAT_MAXAGE - Value: 30

Setting: MAINTENANCE_ALERT_TOUT - Value: 12

Setting: SHOW_DISPLAY_AS_VNCLINK - Value:

Setting: SHOW_DISPLAY_AS_VNC_TGT - Value: _top

Setting: MAINTENANCE_ALWAYS_ALERT - Value: Off

Setting: SCHEDULE_LOOKAHEAD - Value: On

Setting: REQUIRED_FILES_LOOKAHEAD - Value: 172800

Setting: REGION_OPTIONS_COLOURING - Value: Media Colouring

Setting: LAYOUT_COPY_MEDIA_CHECKB - Value: Unchecked

Setting: MAX_LICENSED_DISPLAYS - Value: 0

Setting: LIBRARY_MEDIA_UPDATEINALL_CHECKB - Value: Unchecked

Setting: USER_PASSWORD_POLICY - Value:

Setting: USER_PASSWORD_ERROR - Value:

Setting: MODULE_CONFIG_LOCKED_CHECKB - Value: Unchecked

Setting: LIBRARY_SIZE_LIMIT_KB - Value: 0

Setting: MONTHLY_XMDS_TRANSFER_LIMIT_KB - Value: 0

Setting: DEFAULT_LANGUAGE - Value: en_US

Setting: TRANSITION_CONFIG_LOCKED_CHECKB - Value: Unchecked

Setting: GLOBAL_THEME_NAME - Value: default

Setting: DEFAULT_LAT - Value: 51.504

Setting: DEFAULT_LONG - Value: -0.104

Setting: SCHEDULE_WITH_VIEW_PERMISSION - Value: No

Setting: SETTING_IMPORT_ENABLED - Value: Off

Setting: SETTING_LIBRARY_TIDY_ENABLED - Value: Off

Setting: SENDFILE_MODE - Value: Off

Setting: EMBEDDED_STATUS_WIDGET - Value:

Setting: PROXY_HOST - Value:

Setting: PROXY_PORT - Value:

Setting: PROXY_AUTH - Value:

--------------------------------------
Sessions Dump
--------------------------------------
UserAgent: Mozilla/5.0 (X11; Linux i686) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36
RemoteAddress: 10.0.1.7
Session Data
pagename|s:5:"fault";token|s:32:"8e84046b64631762a60af48a2d374977";token_timeout|i:1407457716;message|s:0:"";userid|s:1:"2";username|s:10:"<REPLACED_USERNAME>";usertype|s:1:"1";log|a:7:{s:6:"Filter";i:0;s:11:"filter_type";s:1:"0";s:15:"filter_function";s:1:"0";s:11:"filter_page";s:1:"0";s:13:"filter_fromdt";s:0:"";s:14:"filter_display";i:0;s:14:"filter_seconds";s:3:"120";}display|a:3:{s:14:"filter_display";s:0:"";s:19:"filter_displaygroup";i:0;s:13:"DisplayFilter";i:0;}user_admin|a:3:{s:15:"filter_username";s:0:"";s:17:"filter_usertypeid";i:0;s:6:"Filter";i:0;}
----

Revision history for this message
Best Dan Garner (dangarner) said : 		#3

Ah, its permissions - they should really be deleted automatically. Ill file a bug and provide a patch.

Thanks for your help.

Revision history for this message
Colin Slaughter (cslaughter) said : 		#4

Thanks Dan Garner, that solved my question.