Dolibarr ERP & CRM » Bugs » bug #872
Erreur sur page Accueil Commerciale avec pgsql (3.4-beta)Latest modifications
Answer now
Snapshot| Details |
| Submitted by: | damien clochard (daamien) | | Submitted on: | 2013-05-03 11:43 |
| Last Modified On: | 2013-05-03 14:18 | |
| Summary: | Erreur sur page Accueil Commerciale avec pgsql (3.4-beta) |
| Description: | Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic:
Date: 20130503114119
Dolibarr: 3.4.0-beta
Niveau de fonctionnalités: 0
PHP: 5.3.3-7+squeeze15
Server: Apache/2.2.16 (Debian)
Url sollicitée: /comm/index.php?mainmenu=commercial&leftmenu=
Referer: https://laboerp.dalibo.info/comm/propal.php?id=393&action="">
Gestionnaire de menu: eldy_menu.php
Type gestionnaire de base de données: pgsql
Requête dernier accès en base en erreur: SELECT a.id, a.percent, a.datep as da, a.datep2 as da2, a.fk_user_author, a.label, c.code, c.libelle, s.rowid, s.nom as sname, s.client FROM llx_c_actioncomm as c, llx_actioncomm as a, llx_societe_commerciaux as sc LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid WHERE c.id = a.fk_action AND a.entity = 1 AND (a.percent >= 100 OR (a.percent = -1 AND a.datep2 <= '2013-05-03 11:41:19')) AND s.rowid = sc.fk_soc AND sc.fk_user = 2 ORDER BY a.datep2 DESC LIMIT 3
Code retour dernier accès en base en erreur: DB_ERROR_NOSUCHTABLE
Information sur le dernier accès en base en erreur: ERROR: 42P01: invalid reference to FROM-clause entry for table "a" LINE 1: ...e_commerciaux as sc LEFT JOIN llx_societe as s ON a.fk_soc =... ^ HINT: There is an entry for table "a", but it cannot be referenced from this part of the query. LOCATION: errorMissingRTE, parse_relation.c:2492
Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic:
Date: 20130503114119
Dolibarr: 3.4.0-beta
Niveau de fonctionnalités: 0
PHP: 5.3.3-7+squeeze15
Server: Apache/2.2.16 (Debian)
Url sollicitée: /comm/index.php?mainmenu=commercial&leftmenu=
Referer: https://laboerp.dalibo.info/comm/propal.php?id=393&action="">
Gestionnaire de menu: eldy_menu.php
Type gestionnaire de base de données: pgsql
Requête dernier accès en base en erreur: SELECT a.id, a.label, a.datep as dp, a.datep2 as dp2, a.fk_user_author, a.percent, c.code, c.libelle, s.nom as sname, s.rowid, s.client FROM llx_c_actioncomm as c, llx_actioncomm as a, llx_societe_commerciaux as sc LEFT JOIN llx_societe as s ON a.fk_soc = s.rowid WHERE c.id = a.fk_action AND a.entity = 1 AND ((a.percent >= 0 AND a.percent < 100) OR (a.percent = -1 AND a.datep2 > '2013-05-03 11:41:19')) AND s.rowid = sc.fk_soc AND sc.fk_user = 2 ORDER BY a.datep DESC, a.id DESC LIMIT 10
Code retour dernier accès en base en erreur: DB_ERROR_NOSUCHTABLE
Information sur le dernier accès en base en erreur: ERROR: 42P01: invalid reference to FROM-clause entry for table "a" LINE 1: ...e_commerciaux as sc LEFT JOIN llx_societe as s ON a.fk_soc =... ^ HINT: There is an entry for table "a", but it cannot be referenced from this part of the query. LOCATION: errorMissingRTE, parse_relation.c:2492 |
| Step to reproduce bug: | |
| Version: | develop | | Category: | Other |
| Severity: | 5 - Major | | OS Type/Version: | |
| PHP version: | | | Database type and version: | |
| Status |
| Status: | Open | | Assigned to: | None |
| Resolution: | Fixed | |
Comments- Laurent Destailleur 2013-05-03 18:35
- The bug has been corrected inside GIT sources
(http://www.github.com/Dolibarr/dolibarr).
So fix should be available with next stable release. - damien clochard 2013-05-03 14:18
Bug corrigé en même temps que le bug #871
voir le patch https://github.com/Dolibarr/dolibarr/commit/c850d413f4bf87e63e9fb9a5b8dccbb026c0e7bb
|
|
(http://www.github.com/Dolibarr/dolibarr).
So fix should be available with next stable release.
None→ Fixed