WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Change in schema for 2.1? (8 posts)

  1. Chelsove
    Member
    Posted 7 years ago #

    I've just written an import script for the categories, authors and articles on our main site and into WordPress 2.05. Is there information available anywhere for database schema changes from one version to another?

    I'm sorry if this is something that's already been answered, but I'm new to the forum and didn't find anything on search and on first few pages.

  2. Kafkaesqui

    Posted 7 years ago #

    The only doc I'm aware of that discusses changes to the db:

    http://wordpress.org/development/2006/12/naughty-or-nice/

    The main change is the post_type record in the posts table, but the best way to check what's new is to compare db structure values from the upgrade-schema.php files (wp-admin/) in both versions.

  3. bubazoo
    Member
    Posted 7 years ago #

    I keep getting

    Warning: preg_replace() [function.preg-replace]: No ending delimiter ':' found in /wp-install-dir/wp-includes/formatting.php on line 648

    when I activate a few of my plugins. I upgraded them all to the latest versions, but yet I'm still getting this error after upgrading to 2.1

    so I'm not real sure what this means.. missing delimiter, is that an error in the formatting.php file? or something they took out in version 2.1? I have no idea, haven't figured it out yet

    but am I the only one getting this error in 2.1? because so far I seem to be the only one reporting it, so something must have changed in 2.1, but so far the docs haven't told me anything pertaining to this, so I haven't figured it out yet

    any ideas though? I could modify the formatting.php file I suppose, but I don't know what the correct syntax would be, when variable names are in play, so I don't know what to do about it really

  4. Kafkaesqui

    Posted 7 years ago #

    bubazoo, what does your issue have to do with the database schema?

  5. Samuel B
    moderator
    Posted 7 years ago #

    Sure sounds plugin related. By chance did you deactivate them all and reactivate one by one testing in between?

  6. Kafkaesqui

    Posted 7 years ago #

    Let's keep bubazoo's issue on the correct thread:

    http://wordpress.org/support/topic/102795

  7. bubazoo
    Member
    Posted 7 years ago #

    ah ha!

    figured out the problem!

    Pierre's AJAX Shoutbox plugin, is conflicting with More-Smilies 3.3 plugin

    darn plugins already LOL

    now I just have to figure out if there is another plugin LIKE more-smilies that won't conflict with the shoutbox, hrm.

  8. Chelsove
    Member
    Posted 7 years ago #

    Thanks for the answer, Kafkaesqui!

    In case anyone finds this later, and wonders about the changes between 2.05 and 2.1, the latter version has three more fields in wp_categories, namely link_count, posts_private and links_private. The wp_linkcategories table has been replaced with the wp_link2cat table. Then there's the post_type type changing from varchar(100) to varchar(20) in wp_posts.

    Perhaps there were other, subtle changes but I only focused on what would mean something for my import.

Topic Closed

This topic has been closed to new replies.

About this Topic