Google XML Sitemap error. WP 2.3

  • Resolved killaja

    (@killaja)


    17 years, 2 months ago

    Hey all. I just upgraded to WordPress 2.3 and immediately afterwards added the Google Sitemap plugin (https://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

Viewing 11 replies - 1 through 11 (of 11 total)
  • Thread Starter killaja

    (@killaja)

    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.

    Thread Starter killaja

    (@killaja)

    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

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

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

    Thread Starter killaja

    (@killaja)

    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.

    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 ??

    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

    Thread Starter killaja

    (@killaja)

    Thanks arnee. b10 solved the problem.

    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.

    Worked like a champ. Thanks!!

    saphod

    (@saphod)

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

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Google XML Sitemap error. WP 2.3’ is closed to new replies.