[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Dolibarr-bugtrack] [bug #16667] problen with page change
From: |
anonymous |
Subject: |
[Dolibarr-bugtrack] [bug #16667] problen with page change |
Date: |
Wed, 24 May 2006 08:58:31 +0000 |
User-agent: |
Mozilla/5.0 (Windows; U; Windows NT 5.0; fr-FR; rv:1.7.12) Gecko/20050919 Firefox/1.0.7 |
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/
- [Dolibarr-bugtrack] [bug #16667] problen with page change,
anonymous <=