Xibo

Delete the media within copied layout error?

Asked by waertf

server version v1.2.2
step:
1. copy 1 layout name "a" to "a2"
2.try to delete image media in "a2" layout
result:
1.show error message:Database error deleting this media record.
2.after refresh webpage , media have been delete
comment:
there is like the same result in ver 1.4.1

question is that if the behavior is normal?

Question information

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

The media will still be there for the other layout. I haven't seen the behaviour you describe in 1.4.1

Revision history for this message
waertf (waertf-register) said : 		#2

Database error retiring this media record.->ver. 1.4.1
so is the error message just delete the link to the media if any other layout still hold it?
with this error msg , I thought that the media will be still in the layout.

Revision history for this message
Best Alex Harrington (alexharrington) said : 		#3

The message means that when it tried to delete the central media record, it couldn't as it was in use elsewhere, so only the link on the current layout has been removed.

If you look at your original layout - the one you copied from, you'll see the media wasn't removed there (because it was in use).

Alex

Revision history for this message
waertf (waertf-register) said : 		#4

Thanks Alex Harrington, that solved my question.

Revision history for this message
Jonas Hunziker (jonas-hunziker) said : 		#5

Am I allowed to ask a question about this or is this frowned upon?

Because I have this exact issue with 1.4.2 but the layout that was initially copied has been retired, so the image we're deleting should not be flagged as "in use" on any layouts any longer. We're scared that being unable to permanently remove content will eventually lead to bloat in the database.

Thanks!

Revision history for this message
Alex Harrington (alexharrington) said : 		#6

If the layout is retired not deleted then the media still is in use. You
need to completely delete the layout.

Revision history for this message
Jonas Hunziker (jonas-hunziker) said : 		#7

Wow, kudos on the speed, that's the fastest response I've ever received!!

I am unable to delete any retired layouts. As soon as I click "DELETE" button, it tells me "Sorry, unable to delete this layout. Retire this layout instead?" and that's that. I thought that might be by design, but now I know there must be a problem. I am the server admin, so I'm guessing I should have that access right.

Any logs I can/should check to figure out why deleting is not possible?

Thanks for a great product and your swift support!!

Revision history for this message
Alex Harrington (alexharrington) said : 		#8

It's probably scheduled in that case

Revision history for this message
Jonas Hunziker (jonas-hunziker) said : 		#9

Alex, that was indeed the problem.

However, the schedule was in the past and I had to go back and delete 6 months worth of schedules. Is that the designed functionality? I was falsely assuming that once the schedule had expired, the layout and its content were fair game for deletion, provided that the content was not being used on any other layout(s).

Thanks for the assistance!

Revision history for this message
Alex Harrington (alexharrington) said : 		#10

That's exactly right. If a layout is in use then all you can do is retire it

Alex