WordPress.org

Ready to get started?Download WordPress

Forums

[Plugin: AStickyPostOrderER] SQL error once astickypost is activated (3 posts)

  1. eLiasPT
    Member
    Posted 5 years ago #

    Hello everyone!
    I was really needing this plugin, it seems very helpful. When I activate this plugin I get this error in my page:

    WordPress database 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 ') WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publis' at line 1]
    SELECT SQL_CALC_FOUND_ROWS distinct wp_posts.* , wp_croer_posts.post_rank IS NULL AS isnull FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id LEFT JOIN wp_croer_posts ON (wp_posts.ID = wp_croer_posts.post_id AND wp_croer_posts.cat_id = ) WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') AND NOT EXISTS (SELECT * FROM wp_term_relationships JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id WHERE wp_term_relationships.object_id = wp_posts.ID AND wp_term_taxonomy.term_id IN (6,7,1) ) ORDER BY isnull ASC, wp_croer_posts.post_rank ASC, wp_posts.post_date DESC LIMIT 0, 10

    Any idea what might be causing this?
    Thank you in advance and keep the good work.

  2. moshu
    Member
    Posted 5 years ago #

    Wait a little bit - in WP 2.7 is already built-in :)

  3. eLiasPT
    Member
    Posted 5 years ago #

    Ok, hope it comes fast ;)
    Thank you.

Topic Closed

This topic has been closed to new replies.

About this Topic