Dolibarr ERP & CRM » Bugs » bug #1153 SQL Error on the VAT main screen (with pgsql)État| Détails |
| Last Modified On: | 26/11/2013 15:56 | | Submitted by: | damien clochard (daamien) |
| Submitted on: | 26/11/2013 15:56 | |
| Summary: | SQL Error on the VAT main screen (with pgsql) |
| Description: |
Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic:
Date: 20131126155401
Dolibarr: 3.5.0-alpha
Niveau de fonctionnalités: 0
PHP: 5.4.4-14+deb7u5
Server: Apache/2.2.22 (Debian)
Url sollicitée: /compta/tva/index.php?leftmenu=tax_vat&mainmenu=accountancy
Referer: https://validerp.dalibo.info/compta/tva/clients.php?leftmenu=tax_vat
Gestionnaire de menu: eldy_menu.php
Type gestionnaire de base de données: pgsql
Requête dernier accès en base en erreur: SELECT SUM(amount) as mm, date_format(f.datev,'%Y-%m') as dm FROM llx_tva as f WHERE f.entity = 1 AND f.datev >= '2013-01-01 00:00:00' AND f.datev <= '2013-12-31 23:59:59' GROUP BY dm ASC
Code retour dernier accès en base en erreur: DB_ERROR_SYNTAX
Information sur le dernier accès en base en erreur: ERROR: 42601: syntax error at or near "ASC" LINE 1: ...:00:00' AND f.datev <= '2013-12-31 23:59:59' GROUP BY dm ASC ^ LOCATION: scanner_yyerror, scan.l:1002 |
| Step to reproduce bug: |
go to :
https://.../compta/tva/index.php?leftmenu=tax_vat&mainmenu=accountancy |
| Detected in version: | 3.5.0 | | Category: | Other |
| Severity: | 5 - Major | | OS Type/Version: | |
| PHP version: | | | Database type and version: | pgsql |
| Etat |
| Status: | Open | | Assigned to: | Aucun |
| Resolution: | Aucun | |
Répondre
|
|