Fixed db for multi-lingual plug-in "Transposh"

⌛Time it takes to read this article: 2 minutes

update Last updated: July 31, 2026 at 5:46 PM

This site was originally built as a multilingual site based on the WordPress translation plugin "Transposh".
However, when I switched to a language other than Japanese and English using the Transposh widget, my name "Chisato" was written as "Chisato" instead of "Senri" in the title.

Therefore, in order to solve this problem, I decided to directly modify the Transposh DB.
Because the structure of the table was unexpectedly easy, i was able to fix it easily.

*For your information, we will show you how to fix it.

Transposh DB modification

(1) As a precaution, you need to back up your DB.

(2) Start phpMyAdmin on the server
From the search menu, search for the original title sentence from Transhposh's translation table "wpxxx_translations". ⇒ wpxxx_translations – Table Search

(3) Select the record you want to correct
Click the Edit button for the record you want to modify ⇒ wpxxx_translations – Table Editing

(4) Correct translation words
Modify the field "translated text" ⇒ wpxxx_translations Table Editing 2-3

(5) DB changes
Click the Run button to change the DB ⇒ wpxxx_translations Table Modified

*April 12
With the end of the service of the free version of google translation engine "Google Translate API v1", Google's translation function has been stopped now.
On Transposh, it is strange that Google Translate was somehow moving so far ...
Therefore, in transposh settings, the translation engine is set to Bing, which supports the Microsoft Translator API.

Actually, as I learned from the FAQ below, you can edit the title tag conversion at the end of the page. If it's just the title tag, there seems to be no need to forcefully modify the DB.

https://transposh.org/ja/faq/ ⇒ "I want to translate title tags (or any other meta tags)"

*August 26
In Transposh Translation Filter version 0.9.7.2, Google's translation feature has been revived, so the site is currently setting the translation engine to "Google".

2026.07.31 Added

Grid modification in SQL

The title gallery is the SQL execution screen in phpMyAdmin provided by the core server.

At the time of writing this additional article, the latest Transposh version 1.0.11 does not have a primary key set, so phpMyAdmin is disabled to edit the grid in the table, and columns cannot be modified.

Setting a primary key on a table allows you to modify the grid, etc., but Transposh cannot be used for the following reasons.Do not perform operations that change the table structure (add primary keys).

Transposh has its own database structure, and when a plugin inserts data, it strictly handles the number and format of columns. Therefore, if you add an extra "ID (primary key)" column to the table,There is a very high risk that saving automatic translations and loading translation data will not work completely, and in the worst case, the translations of the site will not be displayed.Is.

Therefore, in this example, we will modify the grid by executing the following SQL to change the columns in the translation table.

SQL when you want to change the English (en) translation

Sql
UPDATE `wpxxx_translations` 
SET `translated` = '新しく設定したい英語のテキスト' 
WHERE `original` = '千里のポータルサイト' AND `lang` = 'en';

SQL when you want to change the French (fr) translation

Sql
UPDATE `wpxxx_translations` 
SET `translated` = '新しく設定したいフランス語のテキスト' 
WHERE `original` = '千里のポータルサイト' AND `lang` = 'fr';

Leave a Reply