Getting a wordpress mysql db error. Help anyone?

[eroswebmaster]

This is the error code..and believe me you I don't understand mysql for shit.



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 '-3' at line 1]
SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND (category_id = 2) AND post_date_gmt <= '2006-02-10 16:58:59' AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') AND post_status != "attachment" GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, -3-3


Thanks for any help you can offer.

[JD]

what are you doing to get the error?

[baddog]

what are you doing to get the error?

Yeah . . . add a plugin, SE friendly permalinks . . . what?

[eroswebmaster]

what are you doing to get the error?

I just finished a design fora blog and was running a test post and when I click on a category or click on the test post link I get that.

[eroswebmaster]

Yeah . . . add a plugin, SE friendly permalinks . . . what?

Permalinks are next...just testing the blog after puttig up the design and I got this error.

[baddog]

I just finished a design fora blog and was running a test post and when I click on a category or click on the test post link I get that.

hmmm, sorry . . . no idea then

[Brujah]

You have an error in your SQL syntax.

ok, seriously.. for some reason you have -3 -3 in there that probably shouldn't be. Can't tell without seeing the code. Could be the design that interfered with the php code.

[baddog]

Could be the design that interfered with the php code.

That would be my first guess

[eroswebmaster]

Could be the design that interfered with the php code.

I have switched themes to the preinstalled wp themes and still same error.

[JD]

I have switched themes to the preinstalled wp themes and still same error.

did you just install WP? Might have been a db fuck up

[eroswebmaster]

did you just install WP? Might have been a db fuck up

No it had been running for a bit..but I had not really worked with it yet...but I'm thinking about just wiping the db and reinstalling it and upping the template I designed and go from there.

[JD]

No it had been running for a bit..but I had not really worked with it yet...but I'm thinking about just wiping the db and reinstalling it and upping the template I designed and go from there.

since you're not gunna lose much that might be faster/easier than figuring out wtf is going on with it

[eroswebmaster]

since you're not gunna lose much that might be faster/easier than figuring out wtf is going on with it

Yep...LOL I figured this would be one of those 2 hour gigs to find the 5 minute solution, so best just to wipe it

[BigFlexy]

I think the problem is in the Inner Join statement.

JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id)

Doesn't make sense to join the catagory id on the post id. Should be catagory ID on Catagory ID.

Also, only use one set of quotes. " or ' . Don't mix and match them. they always give headaches.