[Dolibarr-bugtrack] [bug #16667] problen with page change

[anonymous]

URL:
  <http://savannah.nongnu.org/bugs/?func=detailitem&item_id=16667>

                 Summary: problen with page change
                 Project: Dolibarr
            Submitted by: None
            Submitted on: mercredi 24.05.2006 à 08:58 UTC
                Severity: 3 - Normal
                  Status: None
                 Privacy: Public
             Assigned to: None
             Open/Closed: Open
                 Release: 2.0.0-alpha1
        Operating System: GNU/Linux

    _______________________________________________________

Details:

when going from page 1 to page 2 in the prospect list, i get this message:

Server: Apache/2.0.52 (CentOS)
Url sollicitée:
/dolibarr-2.0.0/htdocs/comm/prospect/prospects.php?page=1&stcomm=
QUERY_STRING: page=1&stcomm=
Referer:
http://serveur/dolibarr-2.0.0/htdocs/comm/prospect/prospects.php?leftmenu=prospects

Type gestionnaire de base de donnée: mysql
Requete dernier acces en base: SELECT s.idp, s.nom, s.ville,
unix_timestamp(s.datec) as datec, unix_timestamp(s.datea) as datea,
st.libelle as stcomm, s.prefix_comm, s.fk_stcomm , d.nom as departement FROM
llx_c_stcomm as st, llx_societe as s LEFT join llx_c_departements as d on
d.rowid = s.fk_departement WHERE s.fk_stcomm = st.id AND s.client=2 AND
s.fk_stcomm= ORDER BY s.nom ASC, s.nom ASC LIMIT 36
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 'ORDER BY s.nom ASC, s.nom ASC LIMIT 36' at line
1



-------------
Version: 2.0.0
Server: Apache/2.0.52 (CentOS)
Url: /dolibarr-2.0.0/htdocs/comm/prospect/prospects.php?leftmenu=prospects







    _______________________________________________________

Reply to this item at:

  <http://savannah.nongnu.org/bugs/?func=detailitem&item_id=16667>

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