Page MenuHomePhabricator

searching for 1-3 letter query or 'help' gives mysql error 1.4beta5
Closed, ResolvedPublic

Description

Author: j-wikimedia.org

Description:
If you search for a 1 to 3 letter query, or 'help', I get this error:

A database query syntax error has occurred. This may indicate a bug in the
software. The last attempted database query was:

SELECT cur_id, cur_namespace, cur_title, cur_text FROM `cur`,`searchindex`

WHERE cur_id=si_page AND AND cur_namespace IN (0) LIMIT 0,20

from within function "". MySQL returned error "1064: You have an error in your
SQL syntax near 'AND cur_namespace IN (0) LIMIT 0,20 ' at line 1 (localhost)

I'm using php-mysql-5.0.2-7, php-5.0.2-7, php-pear-5.0.2-7, php-devel-5.0.2-7,
php-ldap-5.0.2-7, mysql-devel-3.23.58.14, mysql-server-3.23.58-14 on fedora core 3.

Jason


Version: unspecified
Severity: normal
OS: Linux
Platform: PC

Details

Reference
bz1357
TitleReferenceAuthorSource BranchDest Branch
EventProcessFunction throws NPE if user func returns Nonerepos/data-engineering/eventutilities-python!50gmodenaT335706-handle-none-eventsmain
Update gitlab runners to v15.9.1repos/releng/gitlab-cloud-runner!233jeltoupgrade-gitlab-runner-15-9-1main
Add support for Iceberg 1.2.1 as a runtime dependency of Spark 3.1.2.repos/data-engineering/conda-analytics!18xcollazoadd-icebergmain
Customize query in GitLab

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 8:10 PM
bzimport added a project: MediaWiki-Search.
bzimport set Reference to bz1357.
bzimport added a subscriber: Unknown Object (MLST).

zigger wrote:

*** This bug has been marked as a duplicate of 1368 ***