[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:52:19 +0100

Is this email not displaying correctly?
update email preferences.

ajax search doesn't work

Latest modifications

2013-03-19 09:52 (Europe/Paris)
  • Status: 

Answer now


Last Modified On:  2013-03-19 09:25 Submitted by:  David A. G. (braito)
Submitted on:  2013-03-04 11:55 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:  None
Status:  Closed 


David A. G. 2013-03-05 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]