[TYPO3] Switch default FE language

[Pascal Cramer]

Hi Florian,

I guess you want/need to switch the default/English with the German language 
versions?
I don't know if there is an easy way for this, I did it once by updating the 
database manually:

  UPDATE pages_language_overlay SET sys_language_uid = 2 WHERE sys_language_uid=0
  UPDATE tt_content SET sys_language_uid = 2 WHERE sys_language_uid=0
  UPDATE pages_language_overlay SET sys_language_uid = 0 WHERE sys_language_uid=1
  UPDATE tt_content SET sys_language_uid = 0 WHERE sys_language_uid=1

Where:
   0 is the current default
   1 is the current alternative language
   2 is the new alternative language

Of course you'll need to add the new -non-default- language to your site and 
adjust your TS and delete language where uid=1.

Please perform/test this action on a development/backup environment since I 
cannot guarantee the correctness of this action!!!!!

'I'll repeat myself at the risc of being crude':
Please perform/test this action on a development/backup environment since I 
cannot guarantee the correctness of this action!!!!!
:-)

Hope this helps.

Pascal
-RogueSheep-

Florian Schupp | FORMER 03 GmbH wrote:
> Hi guys,
> 
> the site we're working on has two lanuages right now. German as default 
> language and English. Now our customer has realized, that the default 
> language should be English.
> 
> What do you think must be done to switch the two languages, meaning that 
> German becomes a alternative page language?
> 
> Thanks a lot in advance, I've got my difficulties to estimate the cost 
> for this action.
> 
> Cheers Florian