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
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
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;
Many thanks, I appreciate your help!pprmkr wrote: ↑Sun Sep 19, 2021 7:16 pm- Replace prefix oc with your prefix.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;
Now that the issue has been solved, please add: [SOLVED] at the beginning of the subject on your first post.EMGX wrote: ↑Mon Sep 20, 2021 4:15 amMany thanks, I appreciate your help!pprmkr wrote: ↑Sun Sep 19, 2021 7:16 pm- Replace prefix oc with your prefix.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;
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Who is online
Users browsing this forum: No registered users and 39 guests