Hello, v4 translations are not working in v5 and i need to translate myself, maybe with the help of AI tools (open for suggestion)

I tried to download the default english lang file but its not xml as before, its kind of page code, very complicated to search words one-by-one into code ..

I didnt find any solution for this, if you have idea please share here.

I tried with ChatGPT, Gemini, Deepl and so on... But the translation quality was terrible.
I did it for myself (German Language) with a multistep database migration.

• Make a Backup for the v5 Table, in case you did something wrong.

• Copy the old table from v4 into v5 Database --> IMPORTANT to rename it with _old or something else. Here's my script for an example...

• Update the v5 Table with all entries from the v4 Table which word_key is excat the same

UPDATE `dev`.`core_sys_lang_words` V5 
JOIN (
    SELECT word_key, MAX(word_custom) AS word_custom
    FROM `dev.`core_sys_lang_words-v4` 
    WHERE word_custom IS NOT NULL
    GROUP BY word_key
) V4 
ON V5.word_key = V4.word_key 
SET V5.word_custom = V4.word_custom;

• And voila... it works... so you have most of the strings translated.

• If you have a problem with opening some topics it could be that you have ols strings that causes an error
  

Thanks a lot for the tip !

Which table i need to importe to v5 database and excute the script ?

I imported from v4 to my v5 databse the lang table that a renamed to dev-core_sys_lang_words. The v5 table is core_sys_lang_words thats the default name.

So i have only one data base, in your script i can see two DB v4 and v5.

How i can adapt it to my case ?

Finaly excuted the code that update the table but it seems that some terms lead some pages to 500 error ..

okay, then you can use this query

SELECT * 
FROM core_sys_lang_words
WHERE word_key LIKE '%promote_manage%' 
   OR word_default LIKE '%promote_manage%' 
   OR word_custom LIKE '%promote_manage%';

If you have any entries with these strings, you can delete them.
I had two of them.

Thanks, whats wrong with the "%promote_manage%" ?

I have many !

Awesome that resolved my 500 error pages !

I have made some adjustments for 5.0.1 which will hopefully catch some of these issues where deprecated FURL keys would break everything.

 

Awesome that resolved my 500 error pages

Perfect... So have fun.
Did you upgraded directly from v4 to v5 or did you use the converter.
My failure is, that a intermediate migration from 4.7.20 to 4.7.20 (clean installation) reorder the forum_ids.
So i'll try again to migrate directly from v4 to v5 to keep the same structure.

@Janyour

But you have to check some strings...

It seems that some of them are not valid...

Be careful editing databases in order to change the language strings.

I'm surprised that nobody else has warned this, usually everything related to database isn't wise to recommend and is discouraged. There's got to be a safer means to edit the language strings?