[3.x & 4.x] Error on single post with "Random order

« [4.x] Basic users can't create a blog (fixed) :: [4.0.5] error in 'Post by email' (fixed) »
Author Message
sam2kb
Posted: Thu Apr 21, 2011 19:18     Topic subject: [3.x & 4.x] Error on single post with "Random order

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

Exact error message:

Code

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
Back to top