WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] [Plugin: WP-dTree] Incorrect SQL syntax in WP-dtree breaks publishing/saving (6 posts)

  1. dolemite
    Member
    Posted 5 years ago #

    ...posts in lastest version of WordPress.

    I upgraded my wordpress from 2.6 to 2.6.5 recently. Everything was working fine until I went to write a post. When I hit the save or publish button a bunch of SQL errors appeared stating there was a problem with the syntax. It was suggested to me that I start disabling plugins and this was the first one I tried.

    Here's the bug I opened. I disabled the WP-dTree plugin and everything worked after that.

    Here's the link to the bug:
    http://trac.wordpress.org/ticket/8468

    http://wordpress.org/extend/plugins/wp-dtree-30/

  2. ulfben
    Member
    Posted 5 years ago #

    It seems that the ORDER BY is not set properly. What version of WP-dTree are you running, and did you disable it before upgrading from whatever version you used previously?

    To fix your b0rked install:
    1. disable wp-dtree and delete it.
    2. get the latest version, upload and enable.
    3. make sure 'wp_dtree_options' gets created in your options table, and that the dtree_cache-table is created in your database.

  3. dolemite
    Member
    Posted 5 years ago #

    I'll give this a try and see how this works.

  4. dolemite
    Member
    Posted 5 years ago #

    I followed the directions but regarding #3. None of them appear in the Database/get created.

    Is there a quick SQL query I can run to get these created?

  5. dolemite
    Member
    Posted 5 years ago #

    I figured it out. It looks like you not only have to disable the plug in but remove the widget from the active widgets list for it to work correctly.

  6. ulfben
    Member
    Posted 5 years ago #

    If the tables are not created on install of this plugin, there is something wrong with your WordPress or server setup. Judging by your other posts on trac and these forums, I find that plausible.

    The widget should have no bearing on this issue at all.

    Glad you got it to work though.

Topic Closed

This topic has been closed to new replies.

About this Topic