Recent Topics

1 Oct 24, 2007 16:47    

My b2evolution Version: 1.10.x

After setting up posts to dsplay on future dates I got this message when trying to open my blog url. What did I do wrong or miss?

MySQL 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 'ORDER BY post_datestart ASC' at line 1(Errno=1064)
Your query: Get Announcement Posts
SELECT *
FROM evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE ( ( post_status = "private"
AND post_creator_user_ID = 1 )
OR post_status IN ('published','protected') )
AND cat_blog_ID =
ORDER BY post_datestart ASC

The blog is
http://www.homedesignsense.com/blog

Thanks for the assistance.

2 Oct 24, 2007 16:57

Disable the Sticky Posts plugin and see if that cures things ;)

¥

3 Oct 24, 2007 17:03

That worked, but how do I keep a subject at the top at all times with the sticky?

4 Oct 24, 2007 17:08

If you make a post in the plugins thread then I'm sure there'll be an easy fix ;)

¥

5 Oct 24, 2007 17:11

I'm not sure I follow ????

6 Oct 24, 2007 18:01

Never mind I just "Read" what you wrote. Thank you for your help.


Form is loading...