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

    Thread Starter lemonhead

    (@lemonhead)

    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>
      <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 –>

    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

    (@lemonhead)

    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.