charmax: (Scully grump)charmax ([personal profile] charmax) wrote,
@ 2007-07-08 09:38 am UTC
Entry tags:bronze ambition, requesting help
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]
SELECT post_status FROM wp_posts WHERE ID = AND post_status IN ('private') LIMIT 1

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]
SELECT post_status FROM wp_posts WHERE ID = AND post_status IN ('private') LIMIT 1


If so can you help me? Pleaseeeee.

(10 comments) - (Post a new comment)
(Flat) (Top-level comments only)

ext_8855: (Sign Post)


[identity profile] halcyon-shift.livejournal.com
2007-07-08 08:53 am UTC (link)
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 to this)  (Thread) 



[identity profile] charmax.livejournal.com
2007-07-08 08:54 am UTC (link)
Thank you! Hmmm and do you know how I can go about fixing this?

(Reply to this)  (Thread from start)  (Parent) 



[identity profile] charmax.livejournal.com
2007-07-08 08:58 am UTC (link)
I was just looking at that table and under Attributes it says it's "UNSIGNED" is this where I correct it?

(Reply to this)  (Thread from start)  (Parent) 



[identity profile] charmax.livejournal.com
2007-07-08 09:34 am UTC (link)
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 to this)  (Thread from start)  (Parent)  (Thread) 


ext_8855: (Sign Post)


[identity profile] halcyon-shift.livejournal.com
2007-07-08 09:45 am UTC (link)
*g* I was just answering the other email, so glad that's sorted. Your navigation problem looks like a stylesheet error, maybe?

(Reply to this)  (Thread from start)  (Parent)  (Thread) 



[identity profile] charmax.livejournal.com
2007-07-08 09:54 am UTC (link)
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 to this)  (Thread from start)  (Parent)  (Thread) 


ext_8855: (Sign Post)


[identity profile] halcyon-shift.livejournal.com
2007-07-08 10:00 am UTC (link)
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 to this)  (Thread from start)  (Parent)  (Thread) 


ext_8855: (Sign Post)


[identity profile] halcyon-shift.livejournal.com
2007-07-08 10:03 am UTC (link)
oop, sorry

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

(Reply to this)  (Thread from start)  (Parent)  (Thread) 



[identity profile] charmax.livejournal.com
2007-07-08 10:18 am UTC (link)
Fantastic, it's fixed! *hugs you hardly* :D

(Reply to this)  (Thread from start)  (Parent)  (Thread) 


ext_8855: (Sign Post)


[identity profile] halcyon-shift.livejournal.com
2007-07-08 10:20 am UTC (link)
yay!

(Reply to this)  (Thread from start)  (Parent) 


(10 comments) - (Post a new comment)
(Flat) (Top-level comments only)