Ticket #3759 (closed defect: fixed)

Opened 1 year ago

Last modified 1 year ago

Search Engine Space Bug

Reported by: specialkitty Assigned to: anonymous
Priority: low Milestone: 2.1.2
Component: General Version: 2.1
Severity: major Keywords:
Cc:

Description

If you search for just a space using wordpress 2.1 you get the following DB error:

WordPress database 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 ') AND (post_type = 'post' AND (post_status = 'publish' OR post_status = 'privat' at line 1] SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND () AND (post_type = 'post' AND (post_status = 'publish' OR post_status = 'private')) ORDER BY post_date DESC LIMIT 0, 25

Attachments

query.php.diff (447 bytes) - added by priv on 02/14/07 18:35:43.
trim before test empty of the search string

Change History

02/07/07 18:27:40 changed by foolswisdom

  • severity changed from normal to major.

Probably relates to #3722

02/07/07 18:28:14 changed by foolswisdom

  • version set to 2.1.

02/14/07 18:35:43 changed by priv

  • attachment query.php.diff added.

trim before test empty of the search string

02/14/07 18:59:09 changed by priv

Sorry I missed the similar problem.

This problem would be gone with the fix in #3722, that fix would be more general.

02/21/07 16:00:39 changed by Nazgul

  • milestone changed from 2.1.1 to 2.1.2.

02/22/07 01:54:30 changed by ryan

  • status changed from new to closed.
  • resolution set to fixed.

(In [4911]) Handle empty search query. Props charleshooper. fixes #3722 #3759

02/22/07 01:55:18 changed by ryan

(In [4912]) Handle empty search query. Props charleshooper. fixes #3722 #3759