Hi there,

Obviously the correct way is to create translated content is via the 'Translate' tab->'add Translation' link from the original version of the page. This way, we can track what has been translated and what has not using 'Translation Overview'.

But what happens if a few translated pages have been added via 'Create Content'->Page (for example) ?

Does anyone know of a way to find these incorrectly created pages and then link them up to the original nodes - besides obviously removing all translated content of a certain language and adding it again.

I've had a look through the database to see any column stands out, but can't see much.

Thanks for your help.

- Alex

Comments

brucepearson’s picture

brucepearson commented

The tnid column in the node table indicates the translation relationship. The tnid is set to the source node id. So if you want to find nodes that are not translations of another node then use nid = tnid

eg. If you want to find french content that is not set as a translation of another node:

SELECT * FROM node where nid = tnid and language = 'fr'

alexkb’s picture

alexkb commented
Status: Active » Fixed

Thank you bruce, that is a great help (not sure how I didn't see that!).

alexkb’s picture

alexkb commented

Just an update to this, it seems the sql to find non-translated might also need to include where the tnid is set to zero? So:

SELECT * FROM node where (nid = tnid OR tnid = '0') and language = 'fr'

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.