[Dolibarr-bugtrack] [bug #24210] Erreur SQL sur les contrats d'un contact

[bastnic]

URL:
  <http://savannah.nongnu.org/bugs/?24210>

                 Summary: Erreur SQL sur les contrats d'un contact
                 Project: Dolibarr
            Submitted by: bastnic
            Submitted on: ven 05 sep 2008 13:37:47 GMT
                Severity: 3 - Normal
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
         Discussion Lock: Any
                 Release: 2.4
        Operating System: None

    _______________________________________________________

Details:

Sur la page Commercial > Contrats > dans la boite en haut à droite, cliquez
sur un client, ça donne une erreur sql.



========================================================
Dolibarr a détecté une erreur technique.
Voici les informations qui pourront aider au diagnostic:

Dolibarr: 2.4
Niveau de fonctionnalités: 2
Server: Apache/2.2.8 (Ubuntu) PHP/5.2.4-2ubuntu5.3 with Suhosin-Patch
mod_ssl/2.2.8 OpenSSL/0.9.8g
Url sollicitée: /soc.php?socid=
Referer: http://demo1.dolibarr.org/contrat/index.php?leftmenu=contracts

Type gestionnaire de base de donnée: mysql
Requete dernier acces en base en erreur: SELECT s.rowid, s.nom,
s.address,unix_timestamp(s.datec) as dc, s.prefix_comm,unix_timestamp(s.tms)
as date_update, s.tel, s.fax, s.email, s.url, s.cp, s.ville, s.note, s.client,
s.fournisseur, s.siren, s.siret, s.ape, s.idprof4, s.capital, s.tva_intra,
s.rubrique, s.fk_typent as typent_id, s.fk_effectif as effectif_id,
s.fk_forme_juridique as forme_juridique_code, s.code_client,
s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent,
s.fk_departement, s.fk_pays, s.fk_stcomm, s.remise_client, s.mode_reglement,
s.cond_reglement, s.tva_assuj, s.fk_prospectlevel, fj.libelle as
forme_juridique, e.libelle as effectif, p.code as pays_code, p.libelle as
pays, d.code_departement as departement_code, d.nom as departement, st.libelle
as stcomm, te.code as typent_code FROM llx_societe as s LEFT JOIN
llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_pays as p ON
s.fk_pays = p.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT
JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN
llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent
as te ON s.fk_typent = te.id WHERE s.rowid =
Code retour dernier acces en base en erreur: DB_ERROR_SYNTAX
Information sur le dernier accès en base en erreur: 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
Message: 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

========================================================




    _______________________________________________________

Reply to this item at:

  <http://savannah.nongnu.org/bugs/?24210>

_______________________________________________
  Message posté via/par Savannah
  http://savannah.nongnu.org/