Dolibarr ERP & CRM » Bugs » bug #745
ajax search doesn't workDernières modifications
Répondre
État Détails |
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
PRODUCT_DONOTSEARCH_ANYWHERE
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: | |
Etat |
Resolution: | Fixed | | Assigned to: | Aucun |
Status: | Open | |
Commentaires- David A. G. 05/03/2013 13:37
- The bug has been corrected inside GIT sources
(http://www.github.com/Dolibarr/dolibarr).
So fix should be available with next stable release.
|
|
Aucun→ Fixed