database error when editing pages

  • inka-wolfy

    (@inka-wolfy)


    20 years ago

    Hi, I upgraded from 1.5 to 2.0.2 today and know I cannot edit pages any longer. I get the following error message in “/wp-admin/post.php?action=edit&post=nnn”:

    WordPress database error: [Unknown column ‘user_firstname’ in ‘field list’]
    SELECT ID, user_login, user_firstname, user_lastname FROM wp_users WHERE user_level <= 10 AND user_level > 0

    After looking in mysql wordpress database in table wp_users, I found no such columns as “user_firstname” and “user_lastname”.
    There is a column named “user_nicename” however.

    Seems that there are some discrepancies here…

    help or input appreciated.

    Inka

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter inka-wolfy

    (@inka-wolfy)

    20 years ago

    FYI, I get the same error when I try to write a new page!

    Thread Starter inka-wolfy

    (@inka-wolfy)

    20 years ago

    isn’t there anyone who can help me out here? Please?

    schulte

    (@schulte)

    20 years ago

    You did each of these steps, right?

    http://codex.wordpress.org/Upgrading_WordPress#Detailed_Upgrade_Instructions_for_1.5.x_to_2.0.2_and_2.0_to_2.0.2

    Thread Starter inka-wolfy

    (@inka-wolfy)

    20 years ago

    yes, absolutely.

    everything is working, except writing/editing pages.

    schulte

    (@schulte)

    20 years ago

    I believe the WordPress database error message is from wp-admin/edit-form-advanced.php — and that particular SELECT statement is from 1.5.x.

    I’m guessing somewhere along the way in step 7 (see url above), that not all the old 1.5 code was deleted and replaced.

    Thread Starter inka-wolfy

    (@inka-wolfy)

    20 years ago

    schulte,
    thank you SO MUCH for leading me on the right track!
    It was the edit-page-form.php file that wasn’t replaced, for whatever reason. I’m at a loss how that happened, I could swear that I deleted the old files on my web server. And WHY this particular file only is a mystery to me.

    Anyway, problem solved and again, muchas gracias!

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘database error when editing pages’ is closed to new replies.