db_error=Unknown column 'alle' in 'where clause' since Update to Maintainance 19.0.2

[tschupo]

Bug

While changing Connected Project in Invoice the following Error comes up:

2024-05-10 21:05:50 ERR 95.90.199.52 DoliDBMysqli::query Exception in query instead of returning an error: Unknown column 'alle' in 'where clause'
2024-05-10 21:05:50 ERR 95.90.199.52 DoliDBMysqli::query SQL Error query: SELECT p.rowid, p.ref, p.title, p.fk_soc, p.fk_statut, p.public, s.nom as name, s.name_alias FROM llx_projet as p LEFT JOIN llx_societe as s ON s.rowid = p.fk_soc WHERE p.entity IN (1) AND (p.fk_soc IN (6,alle) OR p.fk_soc IS NULL) ORDER BY p.ref ASC
2024-05-10 21:05:50 ERR 95.90.199.52 DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHFIELD Unknown column 'alle' in 'where clause'
2024-05-10 21:05:50 ERR 95.90.199.52 Error url=/compta/facture/card.php?action=classify&token=b8369ad819581682014adfcee21ef070&id=296, query_string=action=classify&token=b8369ad819581682014adfcee21ef070&id=296, sql=SELECT p.rowid, p.ref, p.title, p.fk_soc, p.fk_statut, p.public, s.nom as name, s.name_alias FROM llx_projet as p LEFT JOIN llx_societe as s ON s.rowid = p.fk_soc WHERE p.entity IN (1) AND (p.fk_soc IN (6,alle) OR p.fk_soc IS NULL) ORDER BY p.ref ASC, db_error=Unknown column 'alle' in 'where clause'

The Error appears in duplicated/Prov invoices and also in live invoices.

Dolibarr Version

19.0.2

Environment PHP

8.1.27

Environment Database

MySQL or MariaDB 10.11.4-MariaDB-1:10.11.4+maria~deb11-log

Steps to reproduce the behavior and expected behavior

In Tab Invoices, Customer-Invoices
Headlines just under Customer, the connected project click "pencil", then the Error appears

Attached files

dolibarr.log

[frederic34]

@tschupo what is your projetc module setup ?

[atm-florianm]

I think this is a translation problem. The German translation reads:

AllowToLinkFromOtherCompany=Element mit einem Projekt einer anderen Firma verknüpfen <br> <br> <u> Unterstützte Werte: </u> <br>- Leer lassen: Kann Elemente mit beliebigen Projekten in derselben Firma verknüpfen (Standard) <br>- "alle": Verknüpfung mit allen Projekten, auch denen anderer Unternehmen <br>- Eine durch Kommas getrennte Liste von Drittanbieter-IDs: kann Elemente mit beliebigen Projekten dieser Drittanbieter verknüpfen (Beispiel: 123,4795,53)

all should have been kept as is and not translated, but I'm not blaming the translators because this is not obvious.

German is not the only language where all was translated (I sampled some of the langs files: es_CU and sw_SW have it too, I didn't look at all of them but it is very likely that more translation files have this issue).

[tschupo]

@tschupo what is your projetc module setup ?

That was exactly the Problem. 😀
Thanks a lot for your quick help!!

[tschupo]

I think this is a translation problem. The German translation reads:

AllowToLinkFromOtherCompany=Element mit einem Projekt einer anderen Firma verknüpfen <br> <br> <u> Unterstützte Werte: </u> <br>- Leer lassen: Kann Elemente mit beliebigen Projekten in derselben Firma verknüpfen (Standard) <br>- "alle": Verknüpfung mit allen Projekten, auch denen anderer Unternehmen <br>- Eine durch Kommas getrennte Liste von Drittanbieter-IDs: kann Elemente mit beliebigen Projekten dieser Drittanbieter verknüpfen (Beispiel: 123,4795,53)

all should have been kept as is and not translated, but I'm not blaming the translators because this is not obvious.

German is not the only language where all was translated (I sampled some of the langs files: es_CU and sw_SW have it too, I didn't look at all of them but it is very likely that more translation files have this issue).

Yes! With "all" filled in the form field it works perfect again.
Thanks für your Help, too! 😀