Support » Alpha/Beta/RC » Error in upgrade install of 2.0

  • I just installed 2.0 and upgraded a fairly new blog from 1.5.2 in which I am using the K2 theme. Everything went smoothly, except this error appears at the top of each post.

    I’m just reporting, not complaining.

    WordPress database error: [Unknown column ‘user_level’ in ‘where clause’]
    SELECT COUNT(*) FROM wp_users WHERE user_level > 2

Viewing 5 replies - 1 through 5 (of 5 total)
  • I’ve similar error msg of the “user” part, and I dunno why after I installed RC3, my recent post can’t work.

    Here’re the code:

    <?php get_recent_posts(); ?>

    Also, when I clicked upgrade.php, error msg shown as below:

    WordPress database error: [Table ‘wordpress.wp_usermeta’ doesn’t exist]
    SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = ‘1’

    I ignored it and click upgrade, and seems nothing strange happened…

    dtclarinet – K2 has a known error in it. The way users are managed has changed between the currently stable 1.5.2(strayhorn) and 2.0.

    To fix this problem, go into theme editor->theloop.php and remove this line:

    get_var("SELECT COUNT(*) FROM $wpdb->users WHERE user_level > 1"); if ($count_users > 1) { ?> by

    This appears twice, so make sure you remove both. When K2 127 is released(currently in svn) it will only support WP 2.0

    I just went on a furthur look, and it appears the following code will also work 😀

    Published <?php /* If there is more than one author, show author's name */ $count_users=$wpdb->get_var("SELECT COUNT(*)
    FROM $wpdb->usermeta WHERE meta_value REGEXP 'contributor|author|editor|administrator'");if($count_users>1){ ?> by <?php
    the_author_posts_link();} ?>

    It may be an idea to check the official K2 support forums –

    I’ve heard about the new release of K2, which will support 2.0. I’ll upgrade as soon as it comes out. Thanks. Otherwise everything seems to be working…


    Thanks, that code popped right in and cleaned it up.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error in upgrade install of 2.0’ is closed to new replies.