$orderby = 'ptyp_ID datemodified'; ... you probably want "issuedate" or summat ;)

¥

Okay, in /blogs/index.php I changed it from

// Stickies go first
$orderby = 'ptyp_ID datemodified';

to issuedate and got this error:

An unexpected error has occured!

If this error persits, please report it to the administrator.

Go back to home page
Additional information about this error:

MySQL error!

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

Your query: ItemList2::Query() Step 1: Get ID list

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 = 2)

AND (( post_ptyp_ID IS NULL

OR post_ptyp_ID NOT IN (1000) ))

AND (post_datestart <= '2008-12-04 07:09:59')

AND ( ( ( post_status = 'private'

AND post_creator_user_ID = 1 )

OR post_status IN ('published','protected') ) )

ORDER BY post_ptyp_ID DESC, post_issuedate DESC, post_ID DESC

LIMIT 14

:?:

Now I'm really lost. :oops:

I am not just trying to change the sticky issue (which is what it appears I am trying to do), but is this the right place to change what I want? I see nothing else with datemodified in it to change.

instead of:

// Stickies go first
$orderby = 'ptyp_ID datemodified'; 

use:

// Stickies go first
$orderby = 'ptyp_ID datestart'; 

THANK YOU THANK YOU THANK YOU!

anytime :roll:

¥

In my 2.45 installation, it already has a "sticky" category, ID = 3. It doesn't work. Is it supposed to?

I *think* that's a future enhancement ;)

¥