View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000197 | MOB-PROX | ERP Dolibarr | public | 2025-12-20 11:13 | 2025-12-20 11:27 |
| Reporter | jurij.acalinovic | Assigned To | jurij.acalinovic | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 22.0.X.4 | ||||
| Target Version | 22.0.X.4 | Fixed in Version | 22.0.X.4 | ||
| Summary | 0000197: Erreur sql sur modif fiche tier | ||||
| Description | lors du clic sur bouton "MODIFIER" de la fiche tier : Error in request SELECT code as rowid, libelle FROM llx_c_input_method WHERE Filter error - Bad syntax of the search string ORDER BY libelle ASC LIMIT 1000 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'error - Bad syntax of the search string ORDER BY libelle ASC LIMIT 1000' at line 1. Check setup of extra parameters. Error in request SELECT code as rowid, libelle FROM llx_c_input_method WHERE Filter error - Bad syntax of the search string ORDER BY libelle You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'error - Bad syntax of the search string ORDER BY libelle' at line 1. Check setup of extra parameters. Error in request SELECT code as rowid, libelle FROM llx_c_input_method WHERE Filter error - Bad syntax of the search string ORDER BY libelle You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'error - Bad syntax of the search string ORDER BY libelle' at line 1. Check setup of extra parameters. | ||||
| Tags | No tags attached. | ||||
|
|
c_input_method:libelle:code::code like 'ZO_%' AND active=1 devient c_input_method:libelle:code::(code:LIKE:ZO_%) AND (active:=:1) pour les trois champs liste à partir d'une table |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-12-20 11:13 | jurij.acalinovic | New Issue | |
| 2025-12-20 11:13 | jurij.acalinovic | Status | new => assigned |
| 2025-12-20 11:13 | jurij.acalinovic | Assigned To | => jurij.acalinovic |
| 2025-12-20 11:27 | jurij.acalinovic | Status | assigned => resolved |
| 2025-12-20 11:27 | jurij.acalinovic | Resolution | open => fixed |
| 2025-12-20 11:27 | jurij.acalinovic | Fixed in Version | => 22.0.X.4 |
| 2025-12-20 11:27 | jurij.acalinovic | Note Added: 0000056 |
