[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Dolibarr-bugtrack] [Bug #745] ajax search doesn't work

From: Doliforge
Subject: [Dolibarr-bugtrack] [Bug #745] ajax search doesn't work
Date: Tue, 19 Mar 2013 09:25:57 +0100

Ce message ne s'affiche pas correctement?
mettez à jour vos préférences utilisateur.

ajax search doesn't work

Dernières modifications

19/03/2013 09:25 (Europe/Paris)
Changements :
  • Step to reproduce bug: 
  • Resolution: 



Submitted by:  David A. G. (braito) Submitted on:  04/03/2013 11:55
Last Modified On:  05/03/2013 13:38 Dolibarr version:  develop
PHP version:   Database type and version:  
OS Type/Version:   Category:  Module Products-Services
Severity:  4 
Summary:  ajax search doesn't work
Description:  when you try lo search for a product using the feature
Doesn't show anything.

the log report is this:
Error url="" query_string=htmlname=idprod&outjson=1&price_level=0&type=&mode=1&status=1&finished=2&idprod=o+aciv, sql=SELECT p.rowid, p.label, p.ref, p.description, p.fk_product_type, p.price, p.price_ttc, p.price_base_type, p.tva_tx, p.duration, p.stock, pl.label as label_translated FROM llx_product as p LEFT JOIN llx_product_lang as pl ON pl.fk_product = p.rowid AND pl.lang='es_ES' WHERE p.entity IN (1) AND p.tosell = 1 AND (p.ref LIKE 'o aciv%' OR p.label LIKE 'o aciv%' OR pl.label LIKE 'o aciv%') ORDER BY p.ref LIMIT, db_error=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

I try to find the problem, and i think it is the query doesn´t has limit.
Step to reproduce bug:  
Resolution:  Fixed Assigned to:  Aucun
Status:  Open 


David A. G. 05/03/2013 13:37
The bug has been corrected inside GIT sources

So fix should be available with next stable release.

reply via email to

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