Ryan Boren wrote:
On 8/28/07, spencerp <[EMAIL PROTECTED]> wrote:
Just curious, has there been database schema changes for certain tables,
or? Like, added rows/columns or whatever in certain ones, or not? I'm
not sure what all was changed really, I'm just asking because I have
been running 2.3 since it started and I'm going by HIS plugin error. =/
I'm guessing, besides file renaming, reorgs, etc... that any possible
database changes that had been made, might throw some off. That's an IF
though.

The big schema change is the dropping of the categories, post2cat, and
link2cat changes in favor of the new terms, term_taxonomy, and
term_relationship tables.  Any plugin that queries against the old
table will break horribly.

Ouch, okay. I think there was some that used the old schema before, if I remember right. But I'm not sure which ones they were though. Since someone made up a Compatible/ Not Working / Iffy - plugin compatibility page for 2.3 now, we'll find out which ones aren't going to cut it, and which will in due time. =)


Plugins that use the category API should
be fine.
Okay, awesome. =D

The only other schema change is the addition of "pending" to the
post_status enum.  That should be very low impact.

Yeah, I agree with you there. That's a whole new addition to the database. I wouldn't expect any plugins to be affected by that. However, I'm not sure about the plugins regarding "posts" though. Example: Adhesive, or Sticky Post plugins, or any other post related plugins? Just throwing this out there, but, IF one of the post related plugins spits an error, it'd probably be regarding the "unaccounted for" status "pending"..? I'm guessing most plugins were created, with the basic ones, and when a new status is added it might hiccup some where... Again, this is just guessing or assuming the possibilities of database error spitting.

Here's the schema diff from 2.2 to 2.3.

http://trac.wordpress.org/changeset?old_path=branches%2F2.2%2Fwp-admin%2Fupgrade-schema.php&old=5966&new_path=trunk%2Fwp-admin%2Fincludes%2Fschema.php&new=5966
Thanks Ryan. =) For starters, I'll get cracking on some plugin testing on a test bed blog of mine, then start updating the 2.3 plugin compatibility page list. Well, I'll test them out, adjust then accordingly and then let the plugin author know. =)

--
spencerp
http://spencerp.net
http://www.vindictivebastard.net




_______________________________________________
wp-testers mailing list
[email protected]
http://lists.automattic.com/mailman/listinfo/wp-testers

Reply via email to