Recent Topics

1 Apr 21, 2011 19:18    

How to reproduce:
1. Blog settings > General > Order by: "Random order"
2. Open any single post page

Exact error message:

MySQL error!

Unknown column 'post_RAND' in 'order clause'(Errno=1054)

Your query: Get ID of next item

SELECT DISTINCT post_ID
  FROM stable_items__item
 INNER JOIN stable_postcats ON post_ID = postcat_post_ID
 INNER JOIN stable_categories ON postcat_cat_ID = cat_ID
 WHERE ( cat_blog_ID = 1 )
   AND (( post_ptyp_ID IS NULL
    OR post_ptyp_ID NOT IN (1000,1500,1520,1530,1570,1600,3000) ))
   AND (post_datestart <= '2011-04-21 10:17')
   AND ( (  ( post_status = 'private'
   AND post_creator_user_ID = 1 )
    OR post_status IN ('published','protected') ) )
 ORDER BY post_RAND ASC, post_ID ASC
 LIMIT 1


Form is loading...