Support » Plugins » Sortable Nicer Archives Problem

  • I have used Sortable Nicer Archives for a long time. It works well in WP 1.*. But after upgrade to 2.0, it returns some errors:
    ——————
    WordPress database error: [Unknown column ‘user_level’ in ‘where clause’]
    SELECT * FROM wp_users WHERE user_level > 0
    Warning: Invalid argument supplied for foreach() in /home/…/archives.php on line 74
    ——————

    The related codes are:
    ——————
    function show_author_select() {
    global $wpdb, $tableusers, $author;
    $users = $wpdb->get_results(“SELECT * FROM $tableusers WHERE user_level > 0“, ARRAY_A);
    $output .= ‘<option value=””>All Authors</option>’.NL;
    foreach ($users as $user) {
    $output .= ‘<option value=”‘.$user[‘ID’].'”‘;
    if ($user[‘ID’] == $author) {
    $output .= ‘selected=”selected”‘;
    }
    $output .= ‘>’.$user[‘user_nickname’].'</option>’.NL;
    }
    $output = ‘<select name=”author”>’.NL.$output.'</select>’.NL;
    echo $output;
    }
    ——————
    Can anybody help me to solve this problem?
    Thank you!

Viewing 6 replies - 1 through 6 (of 6 total)
  • I’m the only author on my blog, so the author select function didn’t really serve a purpose for me. I just commented out the entire show_author_select() function and also the two lines that call it. That worked great.

    If there are multiple authors on your blog and you need the author select, better heads than mine will need to help you. 🙂

    I haven’t been able to get Sortable Nicer Archives working since I upgraded to WordPress 2.0 either. I have started with a fresh copy of the narchives.php file and commented out all the author parts (as I have anyway).

    The only way I can get it to return anything is when I select category.

    http://mindfaucet.com/comicpress/narchives.php

    Anyone else have some tips on getting the old Sortable Nicer Archives working smoothly in WordPress 2.0. I gotta have’em! =)

    The plugin needs to be updated. You aren’t doing anything wrong, it just simply doesn’t work in WordPress 2.0.

    TylerMartin, mine is working fine, but then I’ve made some other changes to it over the years. I’d be happy to share my hacked-up version, but I can’t locate an email for you.

    That would be excellent jabecker, I’ve stripped mine down as much as I could with no luck.

    Send to tyler at mindfaucet dot com.

    I’ll sent it tonight as soon as I get home, Tyler. I’m at work right now. 🙂

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Sortable Nicer Archives Problem’ is closed to new replies.