[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Dolibarr-bugtrack] [bug #16258] DB_ERROR_NOSUCHFIELD et DB_ERROR_SYNTAX
From: |
sacha |
Subject: |
[Dolibarr-bugtrack] [bug #16258] DB_ERROR_NOSUCHFIELD et DB_ERROR_SYNTAX |
Date: |
Mon, 3 Apr 2006 22:42:39 +0000 |
User-agent: |
Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1 |
URL:
<http://savannah.nongnu.org/bugs/?func=detailitem&item_id=16258>
Summary: DB_ERROR_NOSUCHFIELD et DB_ERROR_SYNTAX
Project: Dolibarr
Submitted by: kuni38
Submitted on: lundi 03.04.2006 à 22:42
Severity: 3 - Normal
Status: None
Privacy: Public
Assigned to: None
Open/Closed: Open
Release: None
Operating System: None
_______________________________________________________
Details:
Bonjour,
lors de la validation de paiement d'une facture fournisseur, ces messages
d'erreurs apparaissent.
Serait ce la version mysql en cause ?..
merci de votre aide
Type gestionnaire de base de donnée: mysql
Requete dernier acces en base: SELECT p.rowid,unix_timestamp(p.datep) as dp,
p.amount, p.statut, p.fk_bank, c.libelle as paiement_type, p.num_paiement,
p.note, b.fk_account FROM llx_c_paiement as c, llx_paiementfourn as p LEFT
JOIN llx_bank as b ON p.fk_bank = b.rowid WHERE p.fk_paiement = c.id AND
p.rowid = 4
Code retour dernier acces en base: DB_ERROR_NOSUCHFIELD
Information sur le dernier accès en base: Unknown column 'p.statut' in
'field list'
Type gestionnaire de base de donnée: mysql
Requete dernier acces en base: SELECT f.facnumber, f.total_ttc, pf.amount,
f.rowid as facid, f.paye, f.fk_statut, s.nom, s.idp FROM
llx_paiementfourn_facturefourn as pf,llx_facture_fourn as f,llx_societe as s
WHERE pf.fk_facturefourn = f.rowid AND f.fk_soc = s.idp AND
pf.fk_paiementfourn =
Code retour dernier acces en base: DB_ERROR_SYNTAX
Information sur le dernier accès en base: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near '' at line 1
-------------
Version: 2.0.1
Server: Apache
Url: /office/dolibarr/htdocs/fourn/paiement/fiche.php?id=4
_______________________________________________________
Reply to this item at:
<http://savannah.nongnu.org/bugs/?func=detailitem&item_id=16258>
_______________________________________________
Message posté via/par Savannah
http://savannah.nongnu.org/
- [Dolibarr-bugtrack] [bug #16258] DB_ERROR_NOSUCHFIELD et DB_ERROR_SYNTAX,
sacha <=