Sitemap Generator Problem

  • Resolved DylanO

    (@dylano)


    18 years, 3 months ago

    I have just plugged in Sitemap Generator 2.7.1, set up a blog driven robots.txt file and in the options area tried to “build” the sitemap and received the following message

    WordPress database error: [Table ‘ehwordpress.wp_post2cat’ doesn’t exist]
    SELECT cat_ID AS ID, MAX(post_modified) AS last_mod FROM wp_posts p LEFT JOIN wp_post2cat pc ON p.ID = pc.post_id LEFT JOIN wp_categories c ON pc.category_id = c.cat_ID WHERE post_status = ‘publish’ GROUP BY cat_ID

    Could not write into /usr/www/virtual/[REMOVED]/www.[REMOVED].com/[REMOVED]/sitemap.xml

    Could not write into /usr/www/virtual/[REMOVED]/www.[REMOVED].com/[REMOVED]/sitemap.xml.gz

    All other aspects of the blog appear to be working and since I am relatively inexperienced at such things as PHP and database construction, I was hoping someone could assist me by telling me what I might be doing wrong or how I might repair this problem.

    Thank you

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    18 years, 3 months ago

    I’m surprised you didn’t [REMOVE] the name of your database prefix which is [REMOVED].

    Sorry I could not resist 🙂

    Are you using WordPress 2.3.1 or version >2.1? I use the version 3.0.2.1 version of that plugin and I’m using the “Modify or create robots.txt…” option myself.

    Unless there is some reason such as compatibility with your host, that may work out better for you.

    Jeremy Clark

    (@jeremyclark13)

    18 years, 3 months ago

    Read this sticky. The issue is the sitemap generator plugin isn’t above version 3 and it’s not compatible with WP 2.3 +. You need to upgrade your plugin.

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

The topic ‘Sitemap Generator Problem’ is closed to new replies.