[Dolibarr-dev] 3.0.0-rc1 et Postgres : erreur SQL sur les rapports TVA

[Antoine Delvaux]

Bonjour à tous,

Dans la 3.0.0-rc1 (beta du 25/2), sur les pages de TVA, avec PostgreSQL, j'ai 
plusieurs erreurs de ces types :

Date: 20110304173811
Dolibarr: 3.0.0-rc1
Niveau de fonctionnalités: 0
PHP: 5.3.2-1ubuntu4.7
Server: Apache/2.2.14 (Ubuntu)

Url sollicitée: /crm/compta/tva/index.php?leftmenu=tax_vat&mainmenu=accountancy
Referer: 
https://eshango.com/crm/compta/charges/index.php?leftmenu=tax_social&mainmenu=accountancy&mode=sconly
Gestionnaire de menu: eldy_backoffice.php

Type gestionnaire de base de données: pgsql
Requête dernier accès en base en erreur: SELECT d.rowid, d.product_type as 
dtype, d.fk_facture as facid, d.tva_tx as rate, d.total_ht as total_ht, 
d.total_ttc as total_ttc, d.total_tva as total_vat, d.description as descr, 
d.date_start as date_start, d.date_end as date_end, f.facnumber as facnum, 
f.type, f.total_ttc as ftotal_ttc, p.rowid as pid, p.ref as pref, 
p.fk_product_type as ptype, 0 as payment_id, 0 as payment_amount FROM 
llx_facture as f, llx_facturedet as d LEFT JOIN llx_product as p on 
d.fk_product = p.rowid WHERE f.fk_statut in (1,2) AND (f.type = 0 OR f.type = 1 
OR f.type = 2) AND f.rowid = d.fk_facture AND f.datef >= '20110101000000' AND 
f.datef <= '20111231235959' AND (date_format(f.datef,'%m') > 0 AND 
date_format(f.datef,'%m') <= 1) AND (d.product_type = 0 AND d.date_start is 
null AND d.date_end IS NULL) ORDER BY d.rowid, d.fk_facture
Code retour dernier accès en base en erreur: DB_ERROR_22007
Information sur le dernier accès en base en erreur: ERROR: 22007: invalid input 
syntax for type date: "20110101000000" LINE 1: ...pe = 2) AND f.rowid = 
d.fk_facture AND f.datef >= '201101010... ^ LOCATION: DateTimeParseError, 
datetime.c:3557


Date: 20110304180225
Dolibarr: 3.0.0-rc1
Niveau de fonctionnalités: 0
PHP: 5.3.2-1ubuntu4.7
Server: Apache/2.2.14 (Ubuntu)

Url sollicitée: /crm/compta/tva/index.php?leftmenu=tax_vat&mainmenu=accountancy
Referer: 
https://eshango.com/crm/compta/tva/index.php?leftmenu=tax_vat&mainmenu=accountancy
Gestionnaire de menu: eldy_backoffice.php

Type gestionnaire de base de données: pgsql
Requête dernier accès en base en erreur: SELECT d.rowid, d.product_type as 
dtype, d.fk_facture as facid, d.tva_tx as rate, d.total_ht as total_ht, 
d.total_ttc as total_ttc, d.total_tva as total_vat, d.description as descr, 
d.date_start as date_start, d.date_end as date_end, f.facnumber as facnum, 
f.type, f.total_ttc as ftotal_ttc, p.rowid as pid, p.ref as pref, 
p.fk_product_type as ptype, pf.fk_paiement as payment_id, pf.amount as 
payment_amount FROM llx_facture as f, llx_paiement_facture as pf, llx_paiement 
as pa, llx_facturedet as d LEFT JOIN llx_product as p on d.fk_product = p.rowid 
WHERE f.fk_statut in (1,2) AND (f.type = 0 OR f.type = 1 OR f.type = 2) AND 
f.rowid = d.fk_facture AND pf.fk_facture = f.rowid AND pa.rowid = 
pf.fk_paiement AND pa.datep >= '20110101' AND pa.datep <= '20111231' AND 
(date_format(pa.datep,'%m') > 0 AND date_format(pa.datep,'%m') <= 1) AND 
(d.product_type = 1 OR d.date_start is NOT null OR d.date_end IS NOT NULL) 
ORDER BY d.rowid, d.fk_facture, pf.rowid
Code retour dernier accès en base en erreur: DB_ERROR_42883
Information sur le dernier accès en base en erreur: ERROR: 42883: operator does 
not exist: text > integer LINE 1: ...tep <= '20111231' AND 
(date_format(pa.datep,'%m') > 0 AND da... ^ HINT: No operator matches the given 
name and argument type(s). You might need to add explicit type casts. LOCATION: 
op_error, parse_oper.c:766

Antoine.