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. _______________________________________________ Dolibarr-dev mailing list [email protected] http://lists.nongnu.org/mailman/listinfo/dolibarr-dev
