Dolibarr ERP & CRM » Bugs » bug #1773 SQL error when listing stock movementsLatest modifications
Answer now
Snapshot| Details |
| Submitted by: | Marcos García (marcosgdf) | | Submitted on: | 2014-12-26 00:51 |
| Last Modified On: | 2014-12-26 00:51 | |
| Summary: | SQL error when listing stock movements |
| Description: | ( ! ) Xdebug: user triggered in /var/www/htdocs/core/lib/functions.lib.php on line 2480
Call Stack
# Time Memory Function Location
1 0.0103 243704 {main}( ) ../mouvement.php:0
2 0.1894 1601704 dol_print_error( ) ../mouvement.php:564
3 0.1938 1642648 xdebug_print_function_stack ( ) ../functions.lib.php:2480
Dolibarr has detected a technical error.
This is information that can help diagnostic:
Date: 20141225233506
Dolibarr: 3.7.0-beta
Level of features: 0
PHP: 5.5.20-1~dotdeb.1
Server: Apache/2.4.10 (Debian)
Requested Url: /product/stock/mouvement.php
Referer: http://dev.dolibarr.org/product/stock/list.php
Menu manager: eldy_menu.php
Database type manager: mysqli
Request for last database access in error: SELECT p.rowid, p.ref as product_ref, p.label as produit, p.fk_product_type as type, e.label as stock, e.rowid as entrepot_id, m.rowid as mid, m.value, m.datem, m.fk_user_author, m.label, m.fk_origin, m.origintype, u.login FROM (llx_entrepot as e, llx_product as p, llx_stock_mouvement as m) LEFT JOIN llx_user as u ON m.fk_user_author = u.rowid WHERE m.fk_product = p.rowid AND m.fk_entrepot = e.rowid AND e.entity = 1 AND p.fk_product_type = 0 ORDER BY m.datem DESC LIMIT 26
Return code for last database access in error: DB_ERROR_NOSUCHFIELD
Information for last database access in error: Unknown column 'm.fk_origin' in 'field list'
XDebug informations:
File: /var/www/htdocs/product/stock/mouvement.php
Line: 564
Function: {main}
|
| Step to reproduce bug: | |
| Detected in version: | 3.7.0 | | Category: | Module: Stocks |
| Severity: | 6 | | OS Type/Version: | |
| PHP version: | | | Database type and version: | |
| Status |
| Status: | Closed | | Assigned to: | None |
| Resolution: | Works for me | |
|
|
Open→ ClosedNone→ Works for me