BWP Google XML Sitemaps Error: post_google_news.xml does not have any item.

  • Resolved stevieAnn

    (@stevieann)


    11 years, 1 month ago

    Hi –

    I love this tool so far but I’m having problems getting the post_google_news.xml to render.

    The status are on the statistics page is throwing this error:

    post_google_news.xml does not have any item. You can fix this easily by excluding any post types / terms you do not use in Sitemap Generator tab within your admin area. If you still see this error, consider checking the module that generates this sitemap (post_google_news.php). (Debug is on)

    I have followed the advice given and it has not worked. I have this error in my logs:

    WordPress database error Table ‘realcomwppreview.wp_pTC_logs’ doesn’t exist for query INSERT INTO wp_pTC_logs (time,userid,message,priority) VALUES (‘2013-03-14 17:27:39 ‘,22,’User Stevie can view pTypeConverter page successfully’,3) made by require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘admin_menu’), call_user_func_array, pTC_menu, logMe, W3_Db->insert, W3_DbCache->insert, W3_DbCallUnderlying->insert, W3_Db->insert, W3_DbProcessor->insert, W3_Db->default_insert, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query, referer: http://www.preview.real.com/resources/wp-admin/admin.php?page=bwp_gxs_google_news

    and I really just don’t know what to do now. I’ve tried deleting and re-installing the plug in. The other sitemaps are written just fine.

    Any help at all would be very much appreciated.

    Thank you!

    http://wordpress.org/extend/plugins/bwp-google-xml-sitemaps/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter stevieAnn

    (@stevieann)

    11 years, 1 month ago

    Update.

    When loading the post_google_news.xml I get this error in my logs:

    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 ‘) GROUP BY wposts.ID\r\n\t\t\t\tORDER BY wposts.post_date DESC LIMIT 0,1000’ at line 10 for query SELECT * FROM wp_term_relationships wprel\r\n\t\t\t\t\tINNER JOIN wp_posts wposts\r\n\t\t\t\t\t\tON wprel.object_id = wposts.ID\r\n\t\t\t\t\t\tAND wposts.post_status = ‘publish’\r\n\t\t\t\t\tINNER JOIN wp_term_taxonomy wptax\r\n\t\t\t\t\t\tON wprel.term_taxonomy_id = wptax.term_taxonomy_id\r\n\t\t\t\t\t\tAND wptax.taxonomy = ‘category’\r\n\t\t\t\t\t, wp_terms wpterms\r\n\t\t\t\t\tWHERE wptax.term_id = wpterms.term_id\r\n\t\t\t\t\t\tAND wposts.post_date > ‘2013-03-12 11:07:58’ AND wpterms.term_id NOT IN () GROUP BY wposts.ID\r\n\t\t\t\tORDER BY wposts.post_date DESC LIMIT 0,1000 made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array, call_user_func_array, BWP_SIMPLE_GXS->request_sitemap, BWP_SIMPLE_GXS->load_module, BWP_GXS_MODULE_POST_GOOGLE_NEWS->__construct, BWP_GXS_MODULE->build_data, BWP_GXS_MODULE_POST_GOOGLE_NEWS->generate_data, BWP_GXS_MODULE->get_results, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

    I checked the code and everything looks fine. Still confused. Any suggestions?

    Plugin Author Khang Minh

    (@oddoneout)

    11 years, 1 month ago

    Hi there,

    Something is not right with the query used to generate news posts, please contact me through http://betterwp.net/contact/, we will continue our discussion there.

    nickaster

    (@nickaster)

    10 years, 11 months ago

    I’m having the same problem… though I’m not sure what’s in my logs yet.

    See here:
    http://www.triplepundit.com/post_google_news.xml

    Any solutions?

    Plugin Author Khang Minh

    (@oddoneout)

    10 years, 11 months ago

    Are you certain that you have Google News posts? All News posts must be at most 2 days old.

    Turkman

    (@turkman)

    10 years, 11 months ago

    This same thing is happening for me. Am receiving the following “post_google_news.xml does not have any item. You can fix this easily by excluding any post types / terms you do not use in Sitemap Generator tab within your admin area. If you still see this error, consider checking the module that generates this sitemap (post_google_news.php).” Just installed the plugin two days ago. It worked well for one day then stopped today.

    In Webmaster Tools, I’m seeing follwoing: “General HTTP error: 404 not found.”

    I am a Google News provider and all categories are listed as news posts. Sometimes though, I do have a day without a post, could this be the cause here?

    Thanks.

    Plugin Author Khang Minh

    (@oddoneout)

    10 years, 11 months ago

    Yes that can be the cause, you should always have news posts within a 2-day period.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘BWP Google XML Sitemaps Error: post_google_news.xml does not have any item.’ is closed to new replies.