Missing Content Meta Information

  • Resolved perezstudios

    (@perezstudios)


    10 years, 2 months ago

    Hello,

    I have been using the WP Meta SEO Plugin for a month or two now, but a while after installing, I noticed that when I click on the Content Meta Page under the plugin that it shows nothing. It just reads “No items found.”. I have over 100 posts on the blog but I know I was able to see the page at one time and update the information in there but now I cant.

    Any ideas?

    https://ww.wp.xz.cn/plugins/wp-meta-seo/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author JoomUnited

    (@joomunited)

    10 years, 2 months ago

    Hi,

    And when you try to filter your content (to filter with page/post/custom post type)?

    Do you have any error on the view in the JS console?
    Can you also try to enable WP_DEBUG?

    Cheers,

    Thread Starter perezstudios

    (@perezstudios)

    10 years, 2 months ago

    JoomUnited,

    Thank you for the quick response. I did as you mentioned. Below is what I got when I enabled WP_DEBUG:

    WordPress database error: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
    SELECT ID, post_title, post_name, post_type, post_status , mt.meta_value AS metatitle, md.meta_value AS metadesc ,mk.meta_value AS metakeywords FROM wp_posts LEFT JOIN (SELECT * FROM wp_postmeta WHERE meta_key = ‘_metaseo_metatitle’) mt ON mt.post_id = wp_posts.ID LEFT JOIN (SELECT * FROM wp_postmeta WHERE meta_key = ‘_metaseo_metadesc’) md ON md.post_id = wp_posts.ID LEFT JOIN (SELECT * FROM wp_postmeta WHERE meta_key = ‘_metaseo_metakeywords’) mk ON mk.post_id = wp_posts.ID WHERE post_type IN (‘post’, ‘page’, ‘attachment’) AND post_status IN (‘publish’, ‘future’, ‘draft’, ‘pending’, ‘private’, ‘trash’) ORDER BY post_title ASC

    WordPress database error: [The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay]
    SELECT ID, post_title, post_name, post_type, post_status , mt.meta_value AS metatitle, md.meta_value AS metadesc ,mk.meta_value AS metakeywords FROM wp_posts LEFT JOIN (SELECT * FROM wp_postmeta WHERE meta_key = ‘_metaseo_metatitle’) mt ON mt.post_id = wp_posts.ID LEFT JOIN (SELECT * FROM wp_postmeta WHERE meta_key = ‘_metaseo_metadesc’) md ON md.post_id = wp_posts.ID LEFT JOIN (SELECT * FROM wp_postmeta WHERE meta_key = ‘_metaseo_metakeywords’) mk ON mk.post_id = wp_posts.ID WHERE post_type IN (‘post’, ‘page’, ‘attachment’) AND post_status IN (‘publish’, ‘future’, ‘draft’, ‘pending’, ‘private’, ‘trash’) ORDER BY post_title ASC LIMIT 0,21
    Content Meta

    Select All

    Title
    Snippet Preview Meta Title Meta Description
    No items found.
    Select All

    Title
    Snippet Preview Meta Title Meta Description

    Any help, would be greatly appreciated.

    Plugin Author JoomUnited

    (@joomunited)

    10 years, 2 months ago

    Hi,

    Could you try something.
    Edit the plugin file inc/class.metaseo-content-list-table.php and add line 219 (just after the ORDER BY directive)

    Code already in the file
if (!empty($orderby) & !empty($order)) {
     $orderStr =' ORDER BY ' . $orderStr;
}

//Code to add on line 219
$query = "SET SQL_BIG_SELECTS=1";
$wpdb->query($query);

    Cheers

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Missing Content Meta Information’ is closed to new replies.