Post by Dutch Pride Code » Sun Sep 19, 2021 4:36 pm

I'm trying to remove a layout that has no modules, but it keeps telling me it cannot be deleted because 1 information page is using the layout. With way too many information pages to check manually, how do I find out which page is using the layout?

Version 3.0.3.2
Default theme
Last edited by Dutch Pride Code on Mon Sep 20, 2021 4:16 am, edited 1 time in total.

User avatar
Active Member

Posts

Joined
Sun Jan 26, 2020 9:46 pm

Post by thekrotek » Sun Sep 19, 2021 5:04 pm

The easiest way is to look right into the database.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by Dutch Pride Code » Sun Sep 19, 2021 6:14 pm

thekrotek wrote:
Sun Sep 19, 2021 5:04 pm
The easiest way is to look right into the database.
Many thanks. But what table do I have to look at?
Because oc_layout only tells me the ID and the name of the layout.

User avatar
Active Member

Posts

Joined
Sun Jan 26, 2020 9:46 pm

Post by pprmkr » Sun Sep 19, 2021 7:16 pm

Code: Select all

SELECT oiot.layout_id, ol.name, oiot.information_id, oid.title FROM `oc_information_to_layout` oiot left join `oc_information_description` oid on(oid.information_id = oiot.information_id) left join `oc_layout` ol on(ol.layout_id = oiot.layout_id) where oiot.layout_id > 0;
- Replace prefix oc with your prefix.

User avatar
Active Member
Online

Posts

Joined
Sat Jan 08, 2011 11:05 pm
Location - Netherlands

Post by Dutch Pride Code » Mon Sep 20, 2021 4:15 am

pprmkr wrote:
Sun Sep 19, 2021 7:16 pm

Code: Select all

SELECT oiot.layout_id, ol.name, oiot.information_id, oid.title FROM `oc_information_to_layout` oiot left join `oc_information_description` oid on(oid.information_id = oiot.information_id) left join `oc_layout` ol on(ol.layout_id = oiot.layout_id) where oiot.layout_id > 0;
- Replace prefix oc with your prefix.
Many thanks, I appreciate your help!

User avatar
Active Member

Posts

Joined
Sun Jan 26, 2020 9:46 pm

Post by straightlight » Mon Sep 20, 2021 8:10 am

EMGX wrote:
Mon Sep 20, 2021 4:15 am
pprmkr wrote:
Sun Sep 19, 2021 7:16 pm

Code: Select all

SELECT oiot.layout_id, ol.name, oiot.information_id, oid.title FROM `oc_information_to_layout` oiot left join `oc_information_description` oid on(oid.information_id = oiot.information_id) left join `oc_layout` ol on(ol.layout_id = oiot.layout_id) where oiot.layout_id > 0;
- Replace prefix oc with your prefix.
Many thanks, I appreciate your help!
Now that the issue has been solved, please add: [SOLVED] at the beginning of the subject on your first post.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: Bing [Bot] and 104 guests