SQL syntax error

Jul 08, 2007 09:38

Does anyone know what this is?

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_status IN ('private') LIMIT 1' at line 1 ( Read more... )

requesting help, bronze ambition

Leave a comment

halcyon_shift July 8 2007, 08:53:04 UTC
This part "WHERE ID =" is expecting an id, but it's not getting one - it's getting an AND. I'm suspecting this may be causing a problem...

Reply

charmax July 8 2007, 08:54:47 UTC
Thank you! Hmmm and do you know how I can go about fixing this?

Reply

charmax July 8 2007, 08:58:15 UTC
I was just looking at that table and under Attributes it says it's "UNSIGNED" is this where I correct it?

Reply

charmax July 8 2007, 09:34:47 UTC
Ok I've fixed that error but now I'm getting my navigation in the wrong place (bottom of the page instead of on the right) http://bronze-ambition.net/wp/?p=390

Any help with that LD?

I'll stop spamming my own post now...

Reply

halcyon_shift July 8 2007, 09:45:55 UTC
*g* I was just answering the other email, so glad that's sorted. Your navigation problem looks like a stylesheet error, maybe?

Reply

charmax July 8 2007, 09:54:50 UTC
Yeah I'm coming over just a tad needy ain't I? lol Anyway, yep got that one fixed. Now, I'm not sure where I am with the stylesheet - it could well be that. The navigation sits where it's supposed to on the main page just not with the individual posts. Could you take a look at the stylesheet maybe?

Reply

halcyon_shift July 8 2007, 10:00:43 UTC
Your main content / side bar classes / ids are

If you lessen the widths of those, it might help to bring the nav back up where it should be. Some fiddling around is probably required.

Alternatively, or if that doesn't work, try widening the width of the id container

Reply

halcyon_shift July 8 2007, 10:03:25 UTC
oop, sorry

id 'content'
class 'widecolumn'
id 'contentright'
class 'boxSidebar'

Reply

charmax July 8 2007, 10:18:01 UTC
Fantastic, it's fixed! *hugs you hardly* :D

Reply

halcyon_shift July 8 2007, 10:20:47 UTC
yay!

Reply


Leave a comment

Up