Hello, i would appreciate any resolution or help on that because it is creating a massive issue that brings the whose e-shop down. Any more information you need i can provide.
Plugin Support
Alex
(@alexcozmoslabs)
Hi,
Could you please check the size of this table?
Also, try the Optimize TranslatePress database tables tool from TP Settings –> Advanced tab –> Debug section. See if that helps.
Yes the size of this table is 176 MB. It has 985.000 rows. I have tried the Optimize option many times. The problem keeps on happening once in a while.
The main issue here is that this table does not contain a column for meta_value. Only original, translated, status, block_type and original_id.
So how is this query supposed to find what it needs?
SELECT meta_value FROM wp_trp_dictionary_el_en_gb LIMIT 0, 25
MySQL said: #1054 - Unknown column 'meta_value' in 'field list'
Could this be an old query forgotten in the translatepress plugin code somewhere? Or is meta_value some kind of alias?
Either way it is creating a big mess when this query is invoked.
Plugin Support
Alex
(@alexcozmoslabs)
The meta_value column you’re seeing in that query is not part of the current TranslatePress table structure. It looks like an old query or leftover reference from a previous version, or possibly from a generic WP convention (WordPress stores post meta in meta_value, but our _trp_* tables have a different structure).
In the current TranslatePress database, the dictionary tables contain only these columns: original, translated, status, block_type, and original_id. There is no meta_value column, so any query referencing it will fail.
This is not part of normal TranslatePress operations, and it may be coming from a custom script, outdated plugin code, or a leftover cache/tool trying to access translations in a WordPress-standard way. You can safely ignore queries that reference meta_value in _trp_* tables, but if they are being triggered automatically, it’s worth checking for old code snippets or plugins that might be making these calls.
