Catalogue

HFSQL catalogue temporarily unavailable

The HFSQL database connection could not be established. The rest of the site remains available.

Code

HFSQL_CONNECTION_FAILED

Message

[01000] #0 Erreur renvoyée par le serveur <192.168.1.2:4900> : Erreur interne à la DLL WDSQL. Informations de débogage : IEWDHFSRV=32.30 Module=<WDHFSRV> Version=<31.5.340.0> ##InternalError## Code SQL de la requête : SELECT COUNT( * ) AS total FROM Produit P WHERE ( ( ( ( ( ( ( ( ( ( ( ( P.nepas_aff = 0) AND ( P.enSommeil = 0) ) AND ( P.b_Supprimer = 0) ) AND P.hierarchieP IN ( 0, 1, 2) ) AND P.UniteVente IS NOT NULL ) AND ( P.UniteVente <> '') ) AND P.Desi_FR IS NOT NULL ) AND ( P.Desi_FR <> '') ) AND ( P.tarif_B > 0) ) AND ( ( P.IDGF IS NULL OR ( P.IDGF = 0) ) OR ( EXISTS ( SELECT 1 AS Expr1 FROM Fam_GF G WHERE ( ( G.IDGF = P.IDGF ) AND ( G.NePasAff_site = 0) ) ) ) ) ) AND ( ( P.IDF IS NULL OR ( P.IDF = 0) ) OR ( EXISTS ( SELECT 1 AS Expr1 FROM Fam_F FAM WHERE ( ( FAM.IDF = P.IDF ) AND ( FAM.NePasAff_site = 0) ) ) ) ) ) AND ( ( P.IDSF IS NULL OR ( P.IDSF = 0) ) OR ( EXISTS ( SELECT 1 AS Expr1 FROM Fam_SF S WHERE ( ( S.IDSF = P.IDSF ) AND ( S.NePasAff_site = 0) )

Hint

Review server logs, test ODBC connectivity with HFSQL Control Center, and call GET /api/diagnostics/hfsql/catalogue?verbose=1 when ENABLE_DIAGNOSTICS=true.

To switch back to demo mode: set DATA_SOURCE=mock in .env.local and restart the server.