[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: Mon, 04 Mar 2013 11:55:14 +0100

Is this email not displaying correctly?
update email preferences.

ajax search doesn't work


Last Modified On:  2013-03-04 11:55 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:  None Assigned to:  None
Status:  Open 

Answer now

reply via email to

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