[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Dolibarr-dev] 3.0.0-rc1 et Postgres : erreur SQL sur les rapports TVA
From: |
Antoine Delvaux |
Subject: |
[Dolibarr-dev] 3.0.0-rc1 et Postgres : erreur SQL sur les rapports TVA |
Date: |
Fri, 4 Mar 2011 18:03:29 +0000 |
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] 3.0.0-rc1 et Postgres : erreur SQL sur les rapports TVA,
Antoine Delvaux <=