Title: Do I exist – User SQL error
Last modified: August 18, 2016

---

# Do I exist – User SQL error

 *  [lemonhead](https://wordpress.org/support/users/lemonhead/)
 * (@lemonhead)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/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)

 *  [jaredquinn](https://wordpress.org/support/users/jaredquinn/)
 * (@jaredquinn)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/do-i-exist-user-sql-error/#post-390478)
 * 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.
 *  Thread Starter [lemonhead](https://wordpress.org/support/users/lemonhead/)
 * (@lemonhead)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/do-i-exist-user-sql-error/#post-390482)
 * 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>
    - [Write Post](https://wordpress.org/blog/wp-admin/post.php?output_format=md)
    - [Manage Posts](https://wordpress.org/blog/wp-admin/edit.php?output_format=md)
    - [Your Profile](https://wordpress.org/blog/wp-admin/profile.php?output_format=md)
    - [Webmail](https://wordpress.org/blog/webmail?output_format=md)
    - <?php wp_register(); ?>
    - <?php wp_loginout(); ?>
 *  <?php } ?>
 * <?php if (!is_single()) { ?>
    <h2><?php _e(‘Sections’); ?></h2>
    - [Photo Gallery](https://wordpress.org/blog/gallery2/?output_format=md)
    - [Archives](https://wordpress.org/blog/archives/?output_format=md)
    - [Site Visitor Map](http://www.gvisit.com/map.php?sid=882fa74eef09a4eec874f807b671e38e)
    - [Subscription](https://wordpress.org/support/topic/do-i-exist-user-sql-error/blog/subscribe/?output_format=md)
 * <?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 get_poll();?>
    - 
 * <?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](https://wordpress.org/support/users/jaredquinn/)
 * (@jaredquinn)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/do-i-exist-user-sql-error/#post-390483)
 * 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
 *  Thread Starter [lemonhead](https://wordpress.org/support/users/lemonhead/)
 * (@lemonhead)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/do-i-exist-user-sql-error/#post-390487)
 * Thanks for the speedy response, I will try out this lead.
 *  [mattread](https://wordpress.org/support/users/mattread/)
 * (@mattread)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/do-i-exist-user-sql-error/#post-390492)
 * 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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 3 participants
 * Last reply from: [mattread](https://wordpress.org/support/users/mattread/)
 * Last activity: [20 years, 1 month ago](https://wordpress.org/support/topic/do-i-exist-user-sql-error/#post-390492)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics