Dolibarr ERP & CRM » Bugs » bug #1819 SQL error when searching for an invoice paymentSnapshot| Details |
| Last Modified On: | 2015-02-01 12:39 | | Submitted by: | Marcos García (marcosgdf) |
| Submitted on: | 2015-02-01 12:39 | |
| Summary: | SQL error when searching for an invoice payment |
| Description: | ( ! ) Xdebug: user triggered in /var/www/dolibarr/htdocs/core/lib/functions.lib.php on line 2371
Call Stack
# Time Memory Function Location
1 0.0021 244816 {main}( ) ../liste.php:0
2 0.0928 1688968 dol_print_error( ) ../liste.php:236
3 0.0978 1732264 xdebug_print_function_stack ( ) ../functions.lib.php:2371
Dolibarr ha detectado un error técnico.
He aquí la información que podrá ayudar al diagnóstico:
Fecha: 20150201113836
Dolibarr: 3.6.3
Nivel de funciones: 0
PHP: 5.5.20-1~dotdeb.1
Servidor: Apache/2.4.10 (Debian)
URL solicitada: /compta/paiement/liste.php?search_ref=FA1501-0001&search_company=&search_paymenttype=LIQ&search_amount=3.63&button_search.x=0&button_search.y=0&button_search=Buscar
Referer: http://dolibarr.local/compta/paiement/liste.php?search_ref=&search_company=&search_paymenttype=LIQ&search_amount=3.63&button_search.x=0&button_search.y=0&button_search=Buscar
Gestor de menú: eldy_menu.php
Tipo de gestor de base de datos: mysqli
Petición último acceso a la base de datos erróneo: SELECT DISTINCT p.rowid, p.datep as dp, p.amount, p.statut, p.num_paiement, c.code as paiement_code, ba.rowid as bid, ba.label, s.rowid as socid, s.nom FROM (llx_c_paiement as c, llx_paiement as p) LEFT JOIN llx_bank as b ON p.fk_bank = b.rowid LEFT JOIN llx_bank_account as ba ON b.fk_account = ba.rowid LEFT JOIN llx_paiement_facture as pf ON p.rowid = pf.fk_paiement LEFT JOIN llx_facture as f ON pf.fk_facture = f.rowid LEFT JOIN llx_societe as s ON f.fk_soc = s.rowid WHERE p.fk_paiement = c.id AND p.entity = 1 AND p.rowid= AND c.code='LIQ' AND p.amount=3.63 ORDER BY p.rowid DESC LIMIT 26
Código devuelto último acceso a la base de datos erróneo: DB_ERROR_SYNTAX
Información sobre el último acceso a la base de datos erróneo: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.code='LIQ' AND p.amount=3.63 ORDER BY p.rowid DESC LIMIT 26' at line 1
XDebug informations:
File: /var/www/dolibarr/htdocs/compta/paiement/liste.php
Line: 236
Function: {main}
Reported by a dolibarr.es forum user at http://www.dolibarr.es/foro/viewtopic.php?f=18&t=2034 |
| Step to reproduce bug: | |
| Detected in version: | 3.6.2 | | Category: | Module: Customer Invoices |
| Severity: | 6 | | OS Type/Version: | |
| PHP version: | | | Database type and version: | MySQL |
| Status |
| Status: | Open | | Assigned to: | None |
| Resolution: | None | |
Answer now
|
|