.. ==================================================
.. FOR YOUR INFORMATION
.. --------------------------------------------------
.. -*- coding: utf-8 -*- with BOM.

.. _upgrades_1000000000_database_manually:


.. note::

  Das **MUSST** Du vorher erledigen:

  * Update der EXT:start auf Version 10.3
  
  * Update der Datenbank wie im Handbuch beschrieben https://docs.typo3.org/p/netzmacher/start/main/en-us/

  * Siehe Kapitel Upgrade


Manuelles Update (nicht empfohlen)
==================================

So gehst Du vor:

#. Prüfen, ob "überholte" Backend-Layouts verwendet worden sind
#. "Überholte" Backend-Layouts aktualisieren
#. Cache leeren


1. Verwende ich "überholte" Backend-Layouts?
'''''''''''''''''''''''''''''''''''''''''''' 

.. code:: sql

  -- Count all deprecated backend layouts
  SELECT
    COUNT(backend_layout) AS qty,
    backend_layout
  FROM
    `pages`
  WHERE
    backend_layout LIKE 'start__slim%'
  GROUP BY
    backend_layout
  ORDER BY
    backend_layout;

  -- Count all deprecated next level backend layouts
  SELECT
    COUNT(backend_layout_next_level) AS qty,
    backend_layout_next_level
  FROM
    `pages`
  WHERE
    backend_layout_next_level LIKE 'start__slim%'
  GROUP BY
    backend_layout_next_level
  ORDER BY
    backend_layout_next_level;


2. Update "überholter" Backend-Layouts
''''''''''''''''''''''''''''''''''''''

.. note::

  Mache unnedingt eine Kopie Deiner Tabelle `pages`


.. code:: sql

  -- Update deprecated backend layouts
  UPDATE `pages` SET `backend_layout` = 'start__mixed_05' WHERE `backend_layout` = 'start__slim_01';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_05_02_r' WHERE `backend_layout` = 'start__slim_02';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_09_gcms' WHERE `backend_layout` = 'start__slim_02_gcms';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_05_03_l' WHERE `backend_layout` = 'start__slim_03';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_05_01_lr' WHERE `backend_layout` = 'start__slim_04';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_01' WHERE `backend_layout` = 'start__slim_extended_04';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_02' WHERE `backend_layout` = 'start__slim_extended_05';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_02' WHERE `backend_layout` = 'start__slim_extended_06';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_01_01_lr' WHERE `backend_layout` = 'start__slim_extended_07';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_01_02_r' WHERE `backend_layout` = 'start__slim_extended_08';
  UPDATE `pages` SET `backend_layout` = 'start__mixed_01_03_l' WHERE `backend_layout` = 'start__slim_extended_09';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_05' WHERE `backend_layout_next_level` = 'start__slim_01';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_05_02_r' WHERE `backend_layout_next_level` = 'start__slim_02';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_09_gcms' WHERE `backend_layout` = 'start__slim_02_gcms';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_05_03_l' WHERE `backend_layout_next_level` = 'start__slim_03';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_05_01_lr' WHERE `backend_layout_next_level` = 'start__slim_04';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_01' WHERE `backend_layout_next_level` = 'start__slim_extended_04';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_02' WHERE `backend_layout_next_level` = 'start__slim_extended_05';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_02' WHERE `backend_layout_next_level` = 'start__slim_extended_06';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_01_01_lr' WHERE `backend_layout_next_level` = 'start__slim_extended_07';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_01_02_r' WHERE `backend_layout_next_level` = 'start__slim_extended_08';
  UPDATE `pages` SET `backend_layout_next_level` = 'start__mixed_01_03_l' WHERE `backend_layout_next_level` = 'start__slim_extended_09';


3. Cache leeren
'''''''''''''''

TYPO3-Frontend-Cache leeren