TYPO3 Not able anymore to translate CE's to other languages

Question

Is there a way to 'reset' or db entries to delete or something else without deleting all content already translated... (and would that solve the issue?)

In the first go all translation went well, I chose a 'one tree' setup pressing translate rather then copy, but adding and modifying the content over time certain elements where not available for translation anymore ...

at one point the second step in translation asked for the origin language (if I recall well) and trying to resolve I chose another language than the default, now I do not have the choice anymore and the record summary proposes elements from german rather than from my default language (italian) which might be the problem since I can only introduce new content in the default language.

if I try to localize from the list view clicking the language flag, in the language selection field I get [INVALID VALUE("1")] and as only option (Default) [0] to select ...

I use TYPO3 V7.6.13, EXT:gridelements and EXT:t3sbootstrap (the nested CE's where the first to show trouble)

content of my database table sys_language: (my default lang is italian)

uid | pid | tstamp | hidden | title   | flag |
 1     0    ...        0      English    gb
 2     0    ...        0      German     de

does anyone know good reference or a solution to this problem ?

Answer 1

first check (as suggested by bernd) if your language setup is valid:

• do you have a sys_language record for every added language in your root-page ? (you can control the sys_language table with phpMyAdmin)
• is the page translated ?

in my case that was all fine but I needed a thorough cleanup:

• I deleted all hidden records in the backend
• I activated the system extension 'recycler' and deleted all in the list (from root-page recursive)
• I then checked with phpMyAdmin which records in tt_content where hidden (and did not show in the backend) and deleted those manually

once I did that the translate request answered perfectly and I could restore the missing CE's translations

note: I still had gridelements showing up in wrong sequence for the translation in the backend but correctly in the frontend, the nested CE's seem though, and of course 'CLEAR CASH FREQUENTLY' to avoid surprises ...