Dolibarr ERP & CRM » Bugs » bug #745
ajax search doesn't workSnapshot| Details |
| 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
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: |
|
| Status |
| Resolution: | None | | Assigned to: | None |
| Status: | Open | |
Answer now
|
|