noalyss-generale
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[noalyss-generale] Noalyss version 9.1 import Banque SQL ERROR


From: rolphp
Subject: [noalyss-generale] Noalyss version 9.1 import Banque SQL ERROR
Date: Tue, 7 Mar 2023 09:29:56 +0100

Bonjour Dany
 
Petit soucis sql lors de l'import banque.

Erreur dans /srv/www/noalyss/include/ext/importbank/include/import_bank.class.php:31 Message = SQL ERROR insert into jrn (jr_def_id,jr_montant,jr_comment,jr_date,jr_ech,jr_grpt_id,jr_tech_per,jr_mt,jr_optype,currency_id,currency_rate,currency_rate_ref) values ($1,$2,$3,to_date($4,'DD.MM.YYYY'),to_date($5,'DD.MM.YYYY'),$6,$7,$8,$9,$10,$11,$12) ERROR: null value in column "currency_id" violates not-null constraint DETAIL: Failing row contains (5192, 6, 125.7100, FOURNITEX SA 2023-00048 Virement en euros, 2023-02-07, 6733, null, 2023-03-07 09:23:54.597099, 0, null, null, null, t, null, null, null, null, null, null, 1678177434.607, null, NOR, null, 1.000000, 1.000000). 
 
Je n'avais pas ce soucis à la version précédante
 
Bonne journée.
 
R

reply via email to

[Prev in Thread] Current Thread [Next in Thread]