Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)
  • Hi there,

    Thank you so much for your patience and assistance. I found the error and it was completely on my end with the way the items were being out put on the page. Thanks again for taking the time to help me troubleshoot this issue.

    Regards,

    Rufaro

    I just checked the table in the DB and the taxonomy term is listed there and the order of the items is responding in the table when i make changes in admin. But upon display on the fronted the order doesn’t change. I also checked the console for any errors there but no errors reported.

    Hi Aurovrata,

    I do have the sort order for this particular post set to manual. I also tried turning it off and then turning it back on again to make sure taht the setting was done correctly but I still get the same query result with no inner join. Could there be something else with the way the custom post is registered that would disable the sort from occuring?

    Thanks!

    HI Aurovrata,

    Here is the SQL query that is being made on the server:

    SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘sinneave_resource’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘tribe-ea-success’ OR wp_posts.post_status = ‘tribe-ea-failed’ OR wp_posts.post_status = ‘tribe-ea-schedule’ OR wp_posts.post_status = ‘tribe-ea-pending’ OR wp_posts.post_status = ‘tribe-ea-draft’ OR wp_posts.post_status = ‘private’) ORDER BY wp_posts.post_date DESC.

    I apologize for the late reply as I have been unavailable for a while. Since we last spoke I have tried to update the plugin but this did not make a difference. It did change the language from english to french and I attempted this fix https://wordpress.org/support/topic/plugin-is-in-french-help/ to get it back to english but that did not work.

    Any help you can provide would be greatly appreciated.

    Yes I have enabled the custom sort on the custom post type. I am using wp_query and passing the custom post type, category, posts_per_page as -1 and suppress filters set to false.
    Here is the query:

    function work_items($categories)
    {
    $args = array(
    ‘post_type’ => ‘work_item’,
    ‘category_name’ => $categories,
    ‘numberposts’ => -1,
    ‘posts_per_page’ => -1,
    ‘suppress_filters’ => false
    );

    $posts = new WP_Query($args);

    return $posts;
    }

    I call this function and then loop through the posts in a while loop and output the formatted html.

    • This reply was modified 8 years, 2 months ago by rkambasha.
    • This reply was modified 8 years, 2 months ago by rkambasha.

    Hi there,

    I am running into a similar issue with my query on a custom post. I check the request that is being made and the left join is not being added to the query yet I have all the correct settings in the plugin settings and I am currently using it for other custom posts setup in the same way. I have tried deselecting and selecting the manual sort option and that did not make a difference.

    I can also see the changes I make being saved in the correct relationship table but on the front end I do not see any changes.

    Any assistance would be greatly appreciated.

    Thanks!

    • This reply was modified 8 years, 2 months ago by rkambasha.
Viewing 6 replies - 1 through 6 (of 6 total)