resolvedI had a problem the other day with a plugin designed to produce a sitemap which would be "friendly" to Google's site-crawling robots. I wrote to PressHarbor Support. As the correspondence below shows, I'd forgotten I had actually installed this plugin and thought it came as part of the WordPress installation.
John suggested that by raising problems such as this in the forum the answer could be helpful to others besides me. In that spirit, I volunteered to share this correspondence.
Des Walsh
http://www.thinkinghomebusiness.com
___________
>Tried to use the Site Map generator installed with WP and got the screen
>as in the attached image.
FYI, this Site Map generator is not 'installed with WP', it is a third
party plugin.
>Is there something I can do to deal with that?
By way of background, here are a few things you need to know about our
Wordpress setup:
- Wordpress 2.3 is scheduled to be released in August.
- There are many changes to the DB schema in 2.3.
- For these reasons, instead of installing 2.2 now and upgrading our
customers to 2.3 in September, we're installing the current "trunk"
version of Wordpress 2.3. We think it would be better for folks to see -
today- what the effects of the new version will have rather than to
install their blog and see it break a month from now....
- Since there have been some changes to the DB schema, some themes and
plugins which have not been updated or try to speak to the DB directly
instead of going through the WP functions may show errors.
In your case, the table 'wp_post2cat' no longer exists in Wordpress 2.3,
so you are seeing this WordPress database error. I believe the new table
name is 'taxonomy' in Wordpress 2.3. I am sure that the author will have
a new version of the plugin available to correct this when 2.3 is released.
However, the error that the plugin could not write into the path /var/
www/hosts/thinkinghomebusiness.com/httpdocs is not likely to go away...
I can't believe that any plugin author would expect that directory to be
writable, that would be a gaping security hole... Assuming you get a
version of this plugin that is compatible with WP 2.3, you would need to
follow the instructions at:
http://www.arnebrachhold.de/2006/04/07/google-sitemaps-faq-sitemap-issues-errors-and-problems
where he explains the errors "I get an open error and / or permission
denied" and "Create the sitemap files and make them writable".
If you could post these kinds of questions to the discussion site going
forward, that would help us build a body of knowledge for future users.
Hope this helps.
John Keegan