WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Google XML Sitemap error. WP 2.3 (12 posts)

  1. killaja
    Member
    Posted 6 years ago #

    Hey all. I just upgraded to WordPress 2.3 and immediately afterwards added the Google Sitemap plugin (http://www.arnebrachhold.de/projects/wordpress-plugins/google-xml-sitemaps-generator/)

    Now when I make a post, I get this error:

    Warning: mysql_fetch_object(): 75 is not a valid MySQL result resource in /home/janton/domains/reelracing.tv/public_html/wp-content/plugins/google-sitemap-generator/sitemap.php on line 2075
    
    Warning: mysql_query() [function.mysql-query]: Access denied for user 'janton'@'localhost' (using password: NO) in /home/janton/domains/reelracing.tv/public_html/wp-content/plugins/popularity-contest.php on line 544
    
    Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/janton/domains/reelracing.tv/public_html/wp-content/plugins/popularity-contest.php on line 544
    Access denied for user 'janton'@'localhost' (using password: NO) on line: 544

    Any idea what could be wrong?

    Thanks for your help,
    Jordan

  2. killaja
    Member
    Posted 6 years ago #

    Some more info. Disabling either Google XML Sitemaps -OR- Popularity Contest makes the error go away.

    Also, setting Post Priority in the Google Sitemaps to be calculated using something OTHER THAN Popularity Contest gives the error above but without the first of the 3 Warnings.

  3. killaja
    Member
    Posted 6 years ago #

    To correct myself, the errors described above occur when I COMMENT on a post. Not when I write a new post.

    This is the error I get when I write a new post:

    Warning: mysql_fetch_object(): 100 is not a valid MySQL result resource in /home/janton/domains/reelracing.tv/public_html/wp-content/plugins/google-sitemap-generator/sitemap.php on line 2075
    
    Warning: Cannot modify header information - headers already sent by (output started at /home/janton/domains/reelracing.tv/public_html/wp-content/plugins/google-sitemap-generator/sitemap.php:2075) in /home/janton/domains/reelracing.tv/public_html/wp-includes/pluggable.php on line 390
  4. Stevie212
    Member
    Posted 6 years ago #

    It's Google Site Map causing the error obviously, disable it and take it up with the plugin author, hope that helps.

  5. Chris_K
    Member
    Posted 6 years ago #

    Arnee, the author, has posted several times here in the forums that there's an upgrade available. Killaja, are you using the latest version?

  6. killaja
    Member
    Posted 6 years ago #

    Yes. I am using the latest version. I only installed this plugin a little while ago and I got the download straight off his site.

  7. Arnee
    Member
    Posted 6 years ago #

    Hi,

    Google Sitemap 3.0 + Popularity contest don't work well together at the moment. See this ticket at trac.

    You can use version v 3.0b10 of the plugin. It is WP 2.3 compatible but uses the old mysql query system thus it is slower and uses more memory. 3.0b10 Download. This version should work well with Popularity Contest :)

  8. miCRoSCoPiCeaRthLinG
    Member
    Posted 6 years ago #

    I've got Pop Contest 1.21 installed and Google XML Sitemaps v3.0b8. Ever since upgrading to WP 2.3, I keep getting this error when trying to compose and SAVE a post:

    WordPress database error: [Table 'wordpress.wp_categories' doesn't exist]
    SELECT c.cat_ID AS ID, MAX(p.post_modified) AS last_mod FROM <code>wp_categories</code> c, <code>wp_post2cat</code> pc, <code>wp_posts</code> p WHERE pc.category_id = c.cat_ID AND p.ID = pc.post_id AND p.post_status = 'publish' AND p.post_type='post' GROUP BY c.cat_id

    It's probably because of an earlier version incompatibility. Will grab the new one and see if it works. Will post back so others with similar problems can figure out easily.

    Yup. That did it. Upgrading to v3.0b10 did the trick.

    Cheers,
    m^e

  9. killaja
    Member
    Posted 6 years ago #

    Thanks arnee. b10 solved the problem.

  10. bsdlover
    Member
    Posted 6 years ago #

    Hello, when I insert a comment or delete it, or post a new article I have this error:

    Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) on line: 544

    but, if I disable Google XML Sitemaps plugin (I use the latest version, 3.0), everything work fine.

    Can you help me please?

    Thank you very much.

  11. mrbill9999
    Member
    Posted 6 years ago #

    Worked like a champ. Thanks!!

  12. saphod
    Member
    Posted 6 years ago #

    I am still using WP 2.1.3 and had the same issue with Popularity Contest - using v3.0b10 did the trick. Thanks!!

Topic Closed

This topic has been closed to new replies.

About this Topic