WordPress.org

Ready to get started?Download WordPress

Forums

Do I exist - User SQL error (6 posts)

  1. Lemonhead
    Member
    Posted 8 years ago #

    When I click on my name from the WP blog page, I am brought into a page that list all my posts. Everything looks fine except in the sidebar I see the following error under memebers :

    WordPress database error: [Unknown column 'user_nickname' in 'field list']
    SELECT user_nickname,user_nicename FROM wp_users WHERE ID=1

    Any thoughts or suggestions ?

  2. jaredquinn
    Member
    Posted 8 years ago #

    user_nickname doesn't exist any more in the database. It's been moved from the user data in wp_users to the user meta data (i believe).

    Your problem is probably caused by a plugin or some code in your sidebar utilising this field which needs to be upgraded to work with the newer wordpress you're running.

  3. Lemonhead
    Member
    Posted 8 years ago #

    Here is my sidebar code. Any idea which line might be causing the issue ? Also my site admin button no longer appears.

    <!-- begin sidebar -->

    <?php global $user_ID; ?>

    <div id="sidebar">

    <?php if ($user_ID) { ?>
    <h2><?php _e('User Options'); ?></h2>

    <?php } ?>

    <?php if (!is_single()) { ?>
    <h2><?php _e('Sections'); ?></h2>

    <?php } ?>

    <?php if (is_home() || is_author()) { ?>
    <h2><?php _e('Members'); ?></h2>

      <?php list_authors(TRUE, TRUE, FALSE, TRUE); ?>

    <?php } ?>

    <h2><?php echo level10bm_get_element_header('categories'); ?></h2>

      <?php level10bm_wp_list_cats('sort_column=name&optioncount=1&hierarchical=0&exclude=4'); ?>

    <?php if (function_exists('vote_poll')): ?>

  4. <h2>Polls</h2>

  5. <?php endif; ?>

    <?php if (!$user_ID) { ?>
    <h2><?php _e('Login'); ?></h2>

    • <form name="loginform" id="loginform" action="/blog/wp-login.php" method="post">
      <label>Username: <input type="text" name="log" id="log" value="" size="10" tabindex="7" />
      </label>
      <label>Password: <input type="password" name="pwd" id="pwd" value="" size="12" tabindex="8" />
      </label>
      <label><input name="rememberme" type="checkbox" id="rememberme" value="forever" tabindex="9" />
      Remember me</label>
      <input type="submit" name="submit" id="submit" value="Submit" tabindex="10" />
      <input type="hidden" name="redirect_to" value="/" /></form>

    <?php } ?>

    </div>

    <!-- end sidebar -->

  • jaredquinn
    Member
    Posted 8 years ago #

    The Level10 plugin may be the culprit here... I found this on the Level10 blog.

    # jim Says:
    January 28th, 2006 at 5:02 pm

    Hi. I am running into an issue with the plugin. From a clean install of the latest wordpress I am seeing this error under “All authors” on the sidebar.

    Any ideas? It’s a great plugin.

    WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]
    SELECT wp_users.ID, user_nickname, user_firstname, user_lastname, user_nicename FROM wp_users WHERE user_login ‘admin’ ORDER BY user_nickname

    Warning: Invalid argument supplied for foreach() in /home/.karamazov/deathnewt/deathnewt.net/calendar/wp-content/plugins/level10_blog_matrix.php on line 511

  • Lemonhead
    Member
    Posted 8 years ago #

    Thanks for the speedy response, I will try out this lead.

  • MattRead
    Member
    Posted 8 years ago #

    I would say that you most definitely exist.... strange question though :|

  • Topic Closed

    This topic has been closed to new replies.

    About this Topic

    Tags

    No tags yet.