Dolibarr ERP & CRM » Bugs » bug #1153 SQL Error on the VAT main screen (with pgsql)Dernières modifications
Répondre
État Détails |
Submitted by: | damien clochard (daamien) | | Submitted on: | 26/11/2013 15:56 |
Last Modified On: | 27/11/2013 22:50 | |
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: | HENRY Florian (fhenry) |
Resolution: | Fixed | |
Commentaires- HENRY Florian 27/11/2013 22:51
- https://github.com/Dolibarr/dolibarr/pull/1325
- HENRY Florian 27/11/2013 22:50
- The bug has been corrected. Pull request send inside GIT sources
(http://www.github.com/Dolibarr/dolibarr) and waiting to merge
into develop branch. |
|