Esto no ocurre si se trata de acceder desde la opción [FINANCIERA]>[FACTURAS DE PROVEEDORES]>[LISTADO]>[PENDIENTES DE PAGO]Dolibarr ha detectado un error técnico.
Esta información puede ser útil para el diagnóstico:
Fecha: 20180105203506
Dolibarr: 6.0.1
Nivel de funciones: 0
PHP: 5.6.32
Server: Apache
OS: Linux info 3.0 #1337 SMP Tue Jan 01 00:00:00 CEST 2000 all GNU/Linux
UserAgent: Mozilla/5.0 (X11; Linux i686) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/63.0.3239.84 Chrome/63.0.3239.84 Safari/537.36
URL solicitada: /htdocs/fourn/facture/list.php?filtre=fac.fk_statut:1,paye:0&mainmenu=accountancy&leftmenu=suppliers_bills
Referer: http://..../htdocs/index.php?mainmenu=home&leftmenu=home
Gestor de menú: eldy_menu.php
Tipo de gestor de base de datos: mysqli
Último error en solicitud de acceso de base de datos: SELECT f.rowid as facid, f.ref, f.ref_supplier, f.datef, f.date_lim_reglement as datelimite, f.fk_mode_reglement, f.total_ht, f.total_ttc, f.total_tva as total_vat, f.paye as paye, f.fk_statut as fk_statut, f.libelle as label, f.datec as date_creation, f.tms as date_update, f.localtax1 as total_localtax1, f.localtax2 as total_localtax2, s.rowid as socid, s.nom as name, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code as typent_code, state.code_departement as state_code, state.nom as state_name, p.rowid as project_id, p.ref as project_ref, SUM(pf.amount) as dynamount_payed FROM dnd_societe as s LEFT JOIN dnd_c_country as country on (country.rowid = s.fk_pays) LEFT JOIN dnd_c_typent as typent on (typent.id = s.fk_typent) LEFT JOIN dnd_c_departements as state on (state.rowid = s.fk_departement), dnd_facture_fourn as f LEFT JOIN dnd_paiementfourn_facturefourn as pf ON pf.fk_facturefourn = f.rowid LEFT JOIN dnd_projet as p ON p.rowid = f.fk_projet WHERE f.fk_soc = s.rowid AND f.entity IN (1) AND fac.fk_statut = 1 AND paye = 0 GROUP BY f.rowid, f.ref, f.ref_supplier, f.datef, f.date_lim_reglement, f.fk_mode_reglement, f.total_ht, f.total_ttc, f.total_tva, f.paye, f.fk_statut, f.libelle, f.datec, f.tms, f.localtax1, f.localtax2, s.rowid, s.nom, s.town, s.zip, s.fk_pays, s.client, s.code_client, typent.code, state.code_departement, state.nom, p.rowid, p.ref ORDER BY f.datef DESC, f.rowid LIMIT 51
Código de retorno de error para la última petición de acceso a la base de datos: DB_ERROR_NOSUCHFIELD
Información del último error de petición de acceso de base de datos: Unknown column 'fac.fk_statut' in 'where clause'
Por si fuera sirve de algo añado las URL de cada uno de los accesos:
[EL QUE FUNCIONA CORRECTAMENTE]
http://..../htdocs/fourn/facture/list.php?leftmenu=suppliers_bills_notpaid&search_status=1
[EL QUE NO FUNCIONA]
http://..../htdocs/fourn/facture/list.php?filtre=fac.fk_statut:1,paye:0&mainmenu=accountancy&leftmenu=suppliers_bills