Support » Plugin: WP-dTree » [Plugin: WP-dTree] WordPress database error: [Unknown column 'hash' in 'where clause&

  • I get these messages when I activated the widget in the sidebar. Any ideas? This happened after upgrading to 4.0.

    WordPress database error: [Unknown column ‘hash’ in ‘where clause’]
    SELECT content FROM wp_dtree_cache WHERE hash = UNHEX(MD5(‘a:32:{s:5:\”title\”;s:6:\”Strane\”;s:5:\”cache\”;i:1;s:6:\”opento\”;s:0:\”\”;s:7:\”oclinks\”;i:1;s:8:\”uselines\”;i:1;s:8:\”useicons\”;i:0;s:7:\”exclude\”;s:0:\”\”;s:11:\”closelevels\”;i:1;s:11:\”folderlinks\”;i:1;s:13:\”showselection\”;i:1;s:7:\”include\”;s:0:\”\”;s:15:\”opentoselection\”;i:1;s:8:\”truncate\”;i:23;s:10:\”sort_order\”;s:3:\”ASC\”;s:6:\”sortby\”;s:4:\”name\”;s:8:\”treetype\”;s:3:\”cat\”;s:8:\”cpsortby\”;s:9:\”post_date\”;s:11:\”cpsortorder\”;s:4:\”DESC\”;s:10:\”hide_empty\”;i:1;s:8:\”child_of\”;i:0;s:6:\”parent\”;s:4:\”none\”;s:10:\”allowdupes\”;i:1;s:11:\”postexclude\”;s:0:\”\”;s:9:\”listposts\”;i:1;s:7:\”showrss\”;i:0;s:9:\”showcount\”;i:0;s:8:\”taxonomy\”;s:8:\”category\”;s:10:\”pad_counts\”;i:1;s:12:\”hierarchical\”;i:0;s:6:\”number\”;i:0;s:24:\”include_last_update_time\”;i:0;s:8:\”title_li\”;s:0:\”\”;}’)) LIMIT 1

    WordPress database error: [Unknown column ‘hash’ in ‘field list’] etc…….

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author ulfben

    (@ulfben)

    It seems the old version didn’t drop the table properly. Did you uninstall and delete the old version from the Admin panel?

    Disable WP-dTree 4.0 and re-enable it. It should rebuild the table itself.

    If that doesn’t work, disable and delete (from the Plugins-admin panel). Then re-install from fresh download.

    Let me know how it works out.

    (You can test for this problem by activating a widget (make sure caching is enabled) and update any setting.)

    Hey Ulfben,

    Thanks for the prompt response.

    You were right. I disabled it and then re-enabled it, and the error messages are gone.

    I get the pipe “|” above and lost some styling, but I’ll try to fix that.

    Another question. Since your JS conflicts with another one which i use only on my front page, in previous WP-dTree I deregistered it on the front page in the functions.php.

    However, now that function doesn’t work (see below)

    add_action( ‘wp_print_scripts’, ‘my_deregister_javascript’, 100 );
    function my_deregister_javascript() {
    if ( !is_page() ) {
    wp_deregister_script( ‘prototype’ );
    }
    }

    Any ideas?

    Thanks in advance, and great work on the new version of the plugin 🙂

    Darko

    Plugin Author ulfben

    (@ulfben)

    I’m not sure what you’re asking. That function should work. But WP-dTree does not use prototype. If you have animations on it will use jQuery.

    As for styling, read the FAQ first.

    Ok, perfect. Disabling the animations did the trick.
    I will, thanks.

    i got the same error after updating. but reenabling fixed my previous issues too.

    Plugin Author ulfben

    (@ulfben)

    I’ve improved the installation procedure for WP-dTree 4.1, hopefully these un-initiated tables wont be an issue anymore. Thanks for reporting!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘[Plugin: WP-dTree] WordPress database error: [Unknown column 'hash' in 'where clause&’ is closed to new replies.