Dolibarr ERP & CRM » Bugs » bug #1163 SQL Error when searching for supplier ordersLatest modifications
Answer now
Snapshot| Details |
| Submitted by: | Marcos García (marcosgdf) | | Submitted on: | 2013-12-01 15:28 |
| Last Modified On: | 2013-12-01 15:34 | |
| Summary: | SQL Error when searching for supplier orders |
| Description: | ( ! ) Xdebug: user triggered in /Users/marcos/dev/dolibarr/htdocs/core/lib/functions.lib.php on line 2258
Call Stack
# Time Memory Function Location
1 0.0002 233696 {main}( ) ../liste.php:0
2 0.0633 1426592 dol_print_error( ) ../liste.php:208
3 0.1531 1464768 xdebug_print_function_stack ( ) ../functions.lib.php:2258
Dolibarr ha detectado un error técnico.
He aquí la información que podrá ayudar al diagnóstico:
Fecha: 20131201152702
Dolibarr: 3.4.1
Nivel de funciones: 0
PHP: 5.5.3
Server: Apache/2.2.25 (Unix) mod_ssl/2.2.25 OpenSSL/0.9.8y DAV/2 PHP/5.5.3
Url solicitada: /fourn/commande/liste.php
Referer: http://dolibarr.local/fourn/commande/index.php?leftmenu=orders_suppliers
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 s.rowid as socid, s.nom, cf.date_commande as dc, cf.rowid,cf.ref, cf.fk_statut, cf.total_ttc, cf.fk_user_author, u.login FROM (llx_societe as s, llx_commande_fournisseur as cf) LEFT JOIN llx_user as u ON cf.fk_user_author = u.rowid WHERE cf.fk_soc = s.rowid AND cf.entity = 1 AND (cf.ref LIKE '%d%' OR cf.note LIKE '%d%') ORDER BY cf.date_creation DESC LIMIT 26
Código devuelto último acceso a la base de datos erróneo: DB_ERROR_NOSUCHFIELD
Información sobre el último acceso a la base de datos erróneo: Unknown column 'cf.note' in 'where clause'
XDebug informations:
File: /Users/marcos/dev/dolibarr/htdocs/fourn/commande/liste.php
Line: 208
Function: {main}
Reported by a dolibarr.es user: http://www.dolibarr.es/index.php/foro/7-bugs-versiones-estables/3730-error-al-buscar-en-pedidos-proveedores#3730 |
| Step to reproduce bug: | 1. Clean install of 3.4.1
2. Enable suppliers
3. Go to commercial > supplier orders
4. Type anything in "Other" search box |
| Detected in version: | 3.4.1 | | Category: | Module: Supplier Order |
| Severity: | 8 | | OS Type/Version: | |
| PHP version: | | | Database type and version: | |
| Status |
| Status: | Open | | Assigned to: | Laurent Destailleur (eldy) |
| Resolution: | Fixed | |
Comments- Laurent Destailleur 2013-12-01 16:18
- The bug has been corrected inside GIT sources
(http://www.github.com/Dolibarr/dolibarr).
So fix should be available with next stable release.
|
|
(http://www.github.com/Dolibarr/dolibarr).
So fix should be available with next stable release.
None→ Laurent Destailleur (eldy)None→ Fixed