PressHarbor » Support » Forums » WordPress

1. deswalsh
   Member

   On another blog outside Pressharbor, where the admin url is http://www.blogname.com/wp-admin I've installed without a problem a dropdown category plugin see http://zeligplanet.altervista.org/2006/01/wordpress-plugin-zelig-dropdown-cats/

   When I go through the same process with Thinking Home Business,
   and insert in the sidebar the code <?php zelig_dropdown_cats(); ?>

   I get a Database Error, which leads with [wordpress_thinkinghomebusiness_com.wp_categories' doesn't exist]

   I'm guessing the problem is because of the admin url structure of http://www.thinkinghomebusiness.com/wordpress/wp-admin

   but don't know how to remedy the problem.

   Des

   Posted 4 years ago #

2. zoli
   Member

   Des, I had to uninstall so many plugins for category related errors... only guessing, and John will have to confirm (or not), but I think it's all because WP 2.3 changed some db tables, including categories, and most plugins out there ony work up to 2.2.

   Posted 4 years ago #

3. PressHarbor Support
   Key Master

   Zoli is correct, the issue is that we are running a prerelease version of WordPress 2.3 (not the current release version which is 2.2x) and the database structure of WordPress has changed from previous versions to support a new set of taxonomy features.

   Plugins which attempt to call the database directly via MySQL calls instead of via the WordPress category API will show errors like the one you describe.

   The official release of WordPress 2.3 is slated for September 24th, and the WordPress developers are blogging about the new database changes:

   http://boren.nu/archives/2007/08/26/wordpress-23-taxonomy-schema/

   so the plugin developers are now starting to update their code either to use the new Taxonomy API or to call the new database tables. I would expect that most plugins will be updated for compatibility within weeks of the release of 2.3, if not before the release.

   Posted 4 years ago #

4. deswalsh
   Member

   Thanks Zoli and John. I suppose I could reduce the number of categories so the list is not so cumbersome. It kind of growed like Topsy :(

   Posted 4 years ago #

5. deswalsh
   Member

   I don't know whether this is related, but I'm noticing that as I write posts in the wysiwyg editor in WP, the following appears under the editing window

   WordPress database error: [Table 'wordpress_thinkinghomebusiness_com.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
   0

   It seems to go away once the post has been saved.

   Is that something I should be concerned about?

   Des

   Posted 4 years ago #

6. PressHarbor Support
   Key Master

   It's the same issue we were referring to earlier in the thread, this error shows something was looking for the wp_post2cat table which no longer exists in WordPress 2.3.

   I assume you have some plugin installed which is attempting to access the post2cat table; have you tried deactivating the Dropdown Cats plugin you referenced at the start of this thread to see if doing so eliminates this error?

   Posted 4 years ago #

7. deswalsh
   Member

   John
   OK, I'll try that.
   Just noticed an interesting post and set of comments re plugins and 2.3 at this link http://www.alistercameron.com/2007/09/09/farewell-ultimate-tag-warrior/#comments

   Des

   Posted 4 years ago #

8. PressHarbor Support
   Key Master

   Yes, with the database changes in 2.3 we thought it would be best to start with this version of Wordpress right off the bat so you would know from Day 1 which plugins were forward compatible.

   Posted 4 years ago #

RSS feed for this topic

Reply

You must log in to post.