joomla/Component-Builder
42
28 Fork 13
Code Issues 56 Pull Requests Projects Wiki Activity

[BUG]: Language translation filters not working correctly. #1309

New Issue
Open
opened 2026-05-19 09:47:29 +00:00 by Tom van der Laan · 4 comments
Tom van der Laan commented 2026-05-19 09:47:29 +00:00
Member
Copy link
Copy source

What Happened?

When i filter on my own (Dutch) language in the translation admin view it does not filter correctly. When i remove 'Not translated in' filter i see lots of strings not translated. But when i select Dutch from the options list it only shows a couple. I've had this problem for ages already but have always been too lazy to open an issue for it.

Steps to reproduce the Bug

not sure but this is a custom language i've added. Maybe that is the reason it is not working correctly.

Which Joomla version are you compiling in?

6.1.0

Which PHP version are you compiling in?

8.4

Which Joomla versions are you targeting?

6

Which PHP version are you targeting?

8.4

Which Web server is JCB running on?

apache/nginx

Which Relational Database is JCB running on?

mariadb 11.4

Which OS is JCB running on?

centos

Which JCB version are you using?

6.1.6 rc-1

Where in JCB did this issue occur?

Language Translations(admin_views)

On which browsers did you encounter the issue?

Firefox, Safari

Additional Comments

No response

### What Happened? When i filter on my own (Dutch) language in the translation admin view it does not filter correctly. When i remove 'Not translated in' filter i see lots of strings not translated. But when i select Dutch from the options list it only shows a couple. I've had this problem for ages already but have always been too lazy to open an issue for it. ### Steps to reproduce the Bug not sure but this is a custom language i've added. Maybe that is the reason it is not working correctly. ### Which Joomla version are you compiling in? 6.1.0 ### Which PHP version are you compiling in? 8.4 ### Which Joomla versions are you targeting? 6 ### Which PHP version are you targeting? 8.4 ### Which Web server is JCB running on? apache/nginx ### Which Relational Database is JCB running on? mariadb 11.4 ### Which OS is JCB running on? centos ### Which JCB version are you using? 6.1.6 rc-1 ### Where in JCB did this issue occur? Language Translations(admin_views) ### On which browsers did you encounter the issue? Firefox, Safari ### Additional Comments _No response_
Scherm­afbeelding 2026-05-19 om 11.45.28.png
174 KiB
Scherm­afbeelding 2026-05-19 om 11.45.17.png
312 KiB
Scherm­afbeelding 2026-05-19 om 11.45.28.png Scherm­afbeelding 2026-05-19 om 11.45.17.png
Tom van der Laan added the Bug label 2026-05-19 09:47:29 +00:00
Tom van der Laan commented 2026-06-01 22:55:23 +00:00
Author
Member
Copy link
Copy source

Hi it's been two weeks without a response? 😅

Hi it's been two weeks without a response? 😅
Lemuel commented 2026-06-02 05:45:29 +00:00
Owner
Copy link
Copy source

Hi @TLWebdesign,
Thanks for reporting this issue. l’m still working to get to the root of the matter. As soon as I have a fix, I’ll let you know here in the issue.

Thanks once again for your patience and for taking time to report this issue.

Hi @TLWebdesign, Thanks for reporting this issue. l’m still working to get to the root of the matter. As soon as I have a fix, I’ll let you know here in the issue. Thanks once again for your patience and for taking time to report this issue.
Tom van der Laan commented 2026-06-02 10:20:36 +00:00
Author
Member
Copy link
Copy source

Yeah no worries it's a low priority bug anyway. Was just curious if you were able to reproduce it.

Yeah no worries it's a low priority bug anyway. Was just curious if you were able to reproduce it.
Lemuel commented 2026-06-03 12:19:56 +00:00
Owner
Copy link
Copy source

@TLWebdesign, I found a temporary workaround for the issue. If you have access to your database, you can resolve it by updating the language_translations table so that any NULL values in the translation column are changed to an empty JSON object {}.

At the moment, records that have not been changed or saved at least once has NULL in this column, but the filter expects an empty JSON value in order to work correctly. Updating those values should allow the filter to behave as expected.

Please run the following SQL query on your Component Builder language translations table:

UPDATE `tableprefix_componentbuilder_language_translation`
SET `translation` = '{}'
WHERE `translation` IS NULL;

This is only a temporary fix. We will be implementing a more global and secure solution so that this works correctly for both fresh installations and existing setups going forward. But once the query has been applied, the filter should behave correctly.

@TLWebdesign, I found a temporary workaround for the issue. If you have access to your database, you can resolve it by updating the `language_translations` table so that any `NULL` values in the `translation` column are changed to an empty JSON object `{}`. At the moment, records that have not been changed or saved at least once has `NULL` in this column, but the filter expects an empty JSON value in order to work correctly. Updating those values should allow the filter to behave as expected. Please run the following SQL query on your Component Builder language translations table: ```sql UPDATE `tableprefix_componentbuilder_language_translation` SET `translation` = '{}' WHERE `translation` IS NULL; ``` This is only a temporary fix. We will be implementing a more global and secure solution so that this works correctly for both fresh installations and existing setups going forward. But once the query has been applied, the filter should behave correctly.
Sign in to join this conversation.
No Branch/Tag Specified
Labels
Clear labels
Beta
Issues related to the a beta release
 Bug
Documentation
URGENT
enhancement
help wanted
invalid
joomla
Joomla related changes
 question
wontfix
No labels Bug
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
aamigo Eunice Hannah Jeff Lemuel Llewellyn Malachi Roline vistamedia Martin (Martin Kopp) aB0t (Robot) ro-ot (root) TLWebdesign (Tom van der Laan)
No Assignees
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: joomla/Component-Builder#1309