Clean Up
You should remove all records from the table tx_gridelements_backend_layout. Otherwise, users can still select the outdated grid elements.
Backup
Before you start: backup your tables:
- pages
- tx_gridelements_backend_layout
List configured grid elements
-- Get all folders
SELECT *
FROM pages
WHERE doktype = 254
AND uid IN (
SELECT `pid`
FROM `tx_gridelements_backend_layout`
GROUP BY `pid`
ORDER BY `pid`
);
-- Get all configuration records
SELECT `uid`, `pid`, `title`
FROM `tx_gridelements_backend_layout`;
Copied!
Remove configured grid elements
-- First: delete pages
DELETE FROM pages
WHERE doktype = 254
AND uid IN (
SELECT `pid`
FROM `tx_gridelements_backend_layout`
GROUP BY `pid`
ORDER BY `pid`
);
-- Second: delete records
DELETE FROM `tx_gridelements_backend_layout`;
Copied!