Upgrade

Backup tt_content

Before you start: backup your table tt_content.

List configured grid elements

SELECT `uid`, `pid`, `title`
FROM `tx_gridelements_backend_layout`

Create the SQL UPDATE-queries

Assign the uids form the query above to the uid-lables like in the table below.

If you would like to receive the UPDATE queries automatically, please use this file:

Grid Element

Uid

Uid-Label

SQL Statement

Start: Columns 1

1

startCol01

UPDATE tt_content SET tx_gridelements_backend_layout = 'startCol01' WHERE tx_gridelements_backend_layout = '1';

Start: Columns 2

2

startCol02

UPDATE tt_content SET tx_gridelements_backend_layout = 'startCol02' WHERE tx_gridelements_backend_layout = '2';

Start: Columns 3

3

startCol03

UPDATE tt_content SET tx_gridelements_backend_layout = 'startCol03' WHERE tx_gridelements_backend_layout = '3';

Start: Columns 4

4

startCol04

UPDATE tt_content SET tx_gridelements_backend_layout = 'startCol04' WHERE tx_gridelements_backend_layout = '4';

Start: Columns 5

5

startCol05

UPDATE tt_content SET tx_gridelements_backend_layout = 'startCol05' WHERE tx_gridelements_backend_layout = '5';

Start: Columns 6

6

startCol06

UPDATE tt_content SET tx_gridelements_backend_layout = 'startCol06' WHERE tx_gridelements_backend_layout = '6';

Start: Accordion & Tabs

11

startAccordion

UPDATE tt_content SET tx_gridelements_backend_layout = 'startAccordion' WHERE tx_gridelements_backend_layout = '11' AND pi_flexform LIKE '%accordion%';

Start: Accordion & Tabs

11

startTab

UPDATE tt_content SET tx_gridelements_backend_layout = 'startTab' WHERE tx_gridelements_backend_layout = '11' AND pi_flexform NOT LIKE '%accordion%';

Copy the SQL statements and paste it into your PhpMyAdmin application or into your SQL CLI.

Hide Headers

Headings and titles of elements within the grid are shown as labels in the accordions, tabs and also in the content. This is a new behavior.

If you don't like to display headers in the content, you can set the headers to hidden by executing the UPDATE-query from below.

-- Display all elements, which are part of an accordion or a tab
SELECT t1.uid, t1.pid, t1.header, t1.header_layout
FROM  tt_content t1
INNER JOIN tt_content t2
ON t1.tx_gridelements_container = t2.uid
AND t2.CType LIKE 'gridelements_pi1'
AND (t2.tx_gridelements_backend_layout = 'startTab' OR t2.tx_gridelements_backend_layout = 'startAccordion')
-- AND t1.pid = 11710

-- Set header to hidden by all elements, which are part of an accordion or a tab
UPDATE tt_content t1
INNER JOIN tt_content t2
ON t1.tx_gridelements_container = t2.uid
AND t2.CType LIKE 'gridelements_pi1'
AND (t2.tx_gridelements_backend_layout = 'startTab' OR t2.tx_gridelements_backend_layout = 'startAccordion')
-- AND t1.pid = 11710
SET t1.header_layout = 100

Clean Up

Don't forget to clean up the Grid Elements. See next section