[wp-testers] 2.3 Nightly - Plugin Compatibility

[spencerp]

Ryan Boren wrote:
> On 8/28/07, spencerp <spencerp1 at gmail.com> 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