Getting a wordpress mysql db error. Help anyone? - GoFuckYourself.com

eroswebmaster · 02-09-2006, 09:09 PM

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 · 02-09-2006, 09:11 PM

what are you doing to get the error?

baddog · 02-09-2006, 09:12 PM

Quote:

Originally Posted by SPeRMiNaToR

what are you doing to get the error?

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

eroswebmaster · 02-09-2006, 09:12 PM

Quote:

Originally Posted by SPeRMiNaToR

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 · 02-09-2006, 09:13 PM

Quote:

Originally Posted by baddog

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 · 02-09-2006, 09:14 PM

Quote:

Originally Posted by eroswebmaster

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 · 02-09-2006, 09:17 PM

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 · 02-09-2006, 09:20 PM

Quote:

Originally Posted by Brujah

Could be the design that interfered with the php code.

That would be my first guess

eroswebmaster · 02-09-2006, 09:23 PM

Quote:

Originally Posted by Brujah

Could be the design that interfered with the php code.

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

JD · 02-09-2006, 09:25 PM

Quote:

Originally Posted by eroswebmaster

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 · 02-09-2006, 09:26 PM

Quote:

Originally Posted by SPeRMiNaToR

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 · 02-09-2006, 09:34 PM

Quote:

Originally Posted by eroswebmaster

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 · 02-09-2006, 09:35 PM

Quote:

Originally Posted by SPeRMiNaToR

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 · 02-09-2006, 10:50 PM

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.

02-09-2006, 09:09 PM	#1
eroswebmaster March 1st, 2003 Join Date: Jul 2001 Location: Seat 4 @ Venetian Poker Room Posts: 20,295	Getting a wordpress mysql db error. Help anyone? 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. __________________ For rent - ICQ 127-027-910 Click here for more details

02-09-2006, 09:17 PM	#7
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	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. __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com

02-09-2006, 10:50 PM	#14
BigFlexy Registered User Join Date: Sep 2004 Location: Brampton Posts: 78	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. __________________ Chicks N Babes Online - The sexiest teenage babes on the internet! WEBMASTERS! Click here to trade traffic, hard links, RSS feeds with Chicks N Babes Online Post your galleries here

02-09-2006, 09:11 PM	#2
JD Too lazy to set a custom title Industry Role: Join Date: Sep 2003 Posts: 22,651	what are you doing to get the error?