CPT dashboard error

  • Resolved Justin McGuire

    (@vijustin)


    7 years, 1 month ago

    When I pull the my Custom post type in the dashboard I get no posts. I installed query_monitor and found the following errors. Commenting out line 182 of /wp-content/plugins/wordpress-seo/admin/links/class-link-columns.php resolves this issue though this is at best a temporary solution. Please advise.

    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
    FROM wp_posts
    WHERE 1=1
    AND wp_posts.post_type = ‘listing’
    AND (wp_posts.post_status = ‘publish’
    OR wp_posts.post_status = ‘future’
    OR wp_posts.post_status = ‘draft’
    OR wp_posts.post_status = ‘pending’
    OR wp_posts.post_status = ‘private’)
    ORDER BY wp_posts.post_date DESC
    LIMIT 0, -1 /* From [site.com/wp-admin/edit.php?post_type=listing] in [/wp-content/plugins/wordpress-seo/admin/links/class-link-columns.php:182] */
    Unknown
    Unknown 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 ‘-1 /* From [site.com/wp-admin/edit.php?post_type=listing] in’ at line 1

    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 ‘-1 /* From [exhomes.staging.wpengine.com/wp-admin/edit.php?post_type=listing] in’ at line 1

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    In order to better assist you, we’ll need more information.

    • How did you create your custom post types?
    • Did you create any 3rd party plugins to create the custom post types? If yes, which one?
    • Can you please elaborate more how we can reproduce the issue on our end?
    • Where are you expecting to see the posts in your WordPress dashboard?
    Thread Starter Justin McGuire

    (@vijustin)

    This custom post type is being created by a 3rd party plugin “AgentPress Listings” which is used in conjunction with a Genesis WordPress theme. I was expecting to see the full list of “listings” within the dashboard of the site.

    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    While we’re unable to confirm whether it’s a bug or not specific to the Yoast SEO plugin, we suggest you please submit a bug report with all the details over at our GitHub repository.

    We’re actively using the bug tracking on our GitHub repository so your best next step would be to create a new issue for our developers at https://github.com/Yoast/wordpress-seo/issues/new. You will need an account to create a new issue. If this is your first bug report, please check out: https://kb.yoast.com/kb/how-to-write-a-good-bug-report/.

    Don’t forget to include the URL to this conversation in your bug report.

    Plugin Support Jerlyn

    (@jerparx)

    Closed due to inactivity.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘CPT dashboard error’ is closed to new replies.