Recent Topics

1 Dec 28, 2010 14:18    

My b2evolution Version: 4.0.3

When i enter '*' to aggregate all blogs, i get the following error:

Unexpected error!

Additional informationi:

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 '*,6 ) ) AND ( ( post_ptyp_ID IS NULL OR post_ptyp_ID NOT IN (1000) ) ) AND' at line 3(Errno=1064)

Your query:

SELECT DISTINCT post_ID

FROM evo_items__item

INNER JOIN evo_postcats ON post_ID = postcat_post_ID

INNER JOIN evo_categories ON postcat_cat_ID = cat_ID

WHERE ( cat_blog_ID IN ( *,6 ) )

AND ( ( post_ptyp_ID IS NULL

OR post_ptyp_ID NOT IN (1000) ) )

AND ( post_datestart <= '2010-12-28 15:16:46' )

Have no idea where that 6 comes from, i just enter *

2 Dec 28, 2010 19:20

Can't reproduce the error in demo. Try to re-upload the /inc/ directory now ;)

3 Dec 28, 2010 20:43

sam2kb wrote:

Can't reproduce the error in demo. Try to re-upload the /inc/ directory now ;)

well i have reuploaded the whole inc directory and the same error persists


Form is loading...