Support » Fixing WordPress » Do I exist – User SQL error

  • 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 ?

Viewing 5 replies - 1 through 5 (of 5 total)
  • 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.

    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’)): ?>

  • <h2>Polls</h2>

  • <?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>Password: <input type=”password” name=”pwd” id=”pwd” value=”” size=”12″ tabindex=”8″ />
      <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 } ?>


    <!– end sidebar –>

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/ on line 511

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

I would say that you most definitely exist…. strange question though 😐

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Do I exist – User SQL error’ is closed to new replies.