dolibarr-bugtrack
[Top][All Lists]
Advanced

[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/





reply via email to

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