Context Navigation

← Previous Ticket
Next Ticket →

#4417 closed defect (bug) (worksforme)

Error Searching For Posts

Reported by:	cpoteet	Owned by:
Priority:	high	Milestone:
Component:	Administration	Version:	2.2
Severity:	normal	Keywords:	dev-feedback
Cc:		Focuses:

Description

Got this when searching for a post from the manage posts page.

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 '-1' at line 19]
SELECT posts.*, CASE WHEN posts.post_title REGEXP 'bermuda' THEN 1 ELSE 0 END AS keyword_in_title, MATCH ( posts.post_title, posts.post_content ) AGAINST ( 'bermuda' ) AS mysql_score FROM wp_posts as posts WHERE posts.post_date_gmt <= '2007-06-06 18:51:00' AND ( posts.post_password = '' ) AND ( posts.post_status = 'static' OR posts.post_status = 'publish' ) AND ( posts.post_title REGEXP 'bermuda' OR posts.post_content REGEXP 'bermuda' ) ORDER BY keyword_in_title DESC, mysql_score DESC, posts.post_date DESC LIMIT 0, -1

Change History (3)

#1 @rob1n
19 years ago

Milestone → 2.3 (trunk)

I can't reproduce this on r5660.

What MySQL version are you running?

I'm on 5.0.37.

#2 @cpoteet
19 years ago

Cc rob1n added; cpoteet removed
Resolution → worksforme
Status new → closed

It works on my other WP environments. Makes me think it's an isolated issue and not related to WP at large (or else more would've been said about it I'm sure).

#3 @rob1n
19 years ago

Milestone 2.3 (trunk)

Note: See TracTickets for help on using tickets.

Download in other formats:

Make WordPress Core