Xibo

Deleted Layouts Still Displayed in Schedule

Asked by Eric Bauer

Hello,

I have recently deleted several layouts, but when I go to schedule one of the remaining layouts, all of the previously deleted layouts are still being displayed on the drop-down list. I tried to fix the problem by re-creating one of the deleted layouts and then deleting it again, but that did not work. Now I have several layouts in the drop-down list with the same name. How do I remove these deleted layouts from that drop-down list in the scheduler?

Thanks,

Eric

Question information

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

It's a known bug in 1.4.1. It's fixed in 1.4.2

Revision history for this message
Eric Bauer (eric-bauer) said : 		#2

On your suggesting, I upgraded from version 1.4.0 to 1.4.2, but the problem remains.

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

Can you try deleting a layout now. You'll find it deletes correctly

Revision history for this message
Eric Bauer (eric-bauer) said : 		#4

I can create and delete new layouts now, but the layouts that I deleted back in version 1.4.0 are still on the drop-down menu in the scheduler. If I create a new layout again with the same name as one of the old ones I am trying to get rid of and then delete it again, the new layout deletes correctly, but it leaves the old one with the same name.

Eric

Revision history for this message
Mike H (s-mike-s) said : 		#5

Alex, I have the same. It retires them. when I select delete after retire i get popup window "Sorry, unable to delete this layout.

Retire this layout instead?" The retired one show up in our Schedule.
later

Revision history for this message
Mike H (s-mike-s) said : 		#6

Funny, I just stop making new layout and renamed them.

Revision history for this message
Eric Bauer (eric-bauer) said : 		#7

Is there a way to manually edit the database to remove these layouts, or do I have to do a complete reinstall of the server and re-create all of the layouts and content? I can't leave it the way it is, it is very confusing for the users.

Thanks,

Eric

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

Hi Eric

You'd need the ID for each layout you want to delete. You can get that by
editing it in the layout designer and then looking at the page URL in your
browser. It'll look something like:

http://my.server/index.php?p=layout&modify=true&layoutid=30

The number we need is the one after layoutid= - so in this case '30'

Then in the database, take a full backup before you begin, then execute:

DELETE FROM layout WHERE layoutID=30 LIMIT 1;

That should remove the layouts for you.

Alex

Revision history for this message
Eric Bauer (eric-bauer) said : 		#9

Hello Alex,

First I would like to say THANKS! for helping me out with this problem. I really do appreciate all your help.

Your answer above got me pointed in the right direction, but was not the ultimate fix. As is turns out, all of the layouts had been deleted from the layout table as they should have been. However, there were still references to these deleted layouts in the 'campaign' table and the 'lkcampaigngroup' table. I am using the MySQL GUI interface in Webmin to administer the database, so by opening the campaign table in the GUI, I was able to see the names of the campaigns that needed to be deleted and their corresponding campaignID numbers. Having determined the campaignID, I had to go into the lkcampaigngroup table and delete those rows out of the table with these campaignID numbers. Then I went back to the campaign table and deleted them from there as well.

Problem Solved, I think :)

Thanks again for all the help. Hopefully this will help someone else out as well.

Best Regards,

Eric