first_name last_name can't display or resets

  • Resolved maxo9000

    (@maxo9000)


    12 years, 3 months ago

    OK I admit I think i f#%^ up

    Heres the story so far

    1. Installed WordPress using Softaculous apps installer in my CPanel – everything ok
    2. Installed My theme – everything ok
    3. Installed some plugins – everything ok
    4. removed deactivated and removed some plugins – something not ok

    In WordPress the users have all got BLANK first and last names.
    If I enter them and update they still show as BLANK.
    Having a look in cPanel MyPHP tables something is happening.

    Here is the process

    * WordPress > Users > All Users – all columns show data except for the (Name) column
    —> URL shows : wp-admin/users.php

    * WordPress > Edit > User Profile – (First Name) blank (Last Name) blank
    —> URL shows : wp-admin/user-edit.php?user_id=35&wp_http_referer=%2Fwp-admin%2Fusers.php

    * WordPress > Type in First Name field > aaa
    * WordPress > Type in Last Name field > bbb
    * WordPress > Update User
    —> URL shows : wp-admin/user-edit.php?user_id=35&updated=true&wp_http_referer=%2Fwp-admin%2Fusers.php

    The (First Name) and (Last Name) are BLANK.. WHAT THE F!@#???

    It ONLY happens with those 2 fields all other fields work..
    If we take a look in cPanel MyPHPAdmin we find this ..

    > wpdatabasename_users > user > first_name is blank
    > wpdatabasename_users > user > last_name is blank
    but
    > wpdatabasename_usermeta > user > first_name is aaa
    > wpdatabasename_usermeta > user > first_name is bbb

    having a look in (wpdatabasename_users) there could be what appears to be other columns left behind by the previous (property management plugin) Im not sure what the default in there should be.

    LETS TRY SOMETHING…

    If I go back to the user profile
    * WordPress > Edit > User Profile – (First Name) blank (Last Name) blank
    * WordPress > Type in First Name field > ccc
    * WordPress > Update User
    If we take a look in cPanel MyPHPAdmin we find this ..
    > wpdatabasename_users > user > first_name is blank
    > wpdatabasename_users > user > last_name is blank
    but
    > wpdatabasename_usermeta > user > first_name is ccc
    > wpdatabasename_usermeta > user > last_name is blank

    ONE LAST TRY

    * in cPanel MyPHPAdmin
    * wpdatabasename_users > user > Edit
    * Type first_name ddd
    * Go (save)

    If I go back to wordpress
    * WordPress > Users > All Users – columns for the (Name) > ddd for the user
    * WordPress > Edit > User Profile – (First Name) ddd (Last Name) blank
    * WordPress > Type in First Name field > eee
    * WordPress > Update
    screen refreshes and the first_name field has gone back to ddd

    If we take a look back in cPanel MyPHPAdmin we find this ..
    > wpdatabasename_users > user > first_name is ddd
    > wpdatabasename_users > user > last_name is blank
    but
    > wpdatabasename_usermeta > user > first_name is eee
    > wpdatabasename_usermeta > user > first_name is blank

    WHATS GOING ON?

    I have already run an auto re-update of wordpress 3.4.1
    I have already tested deactivating all plugins
    I have already done a repair table for both _user and _usermeta

    any one have any clue? I dont want to have to reinstall wordpress and MySql
    is it a wordpress problem ?
    is it a database problem ?
    is it an security access problem ?

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

  • Can you switch to the default twentyten theme and see if you still have this problem?

    First in the user table wp_users there is not a column for first name or last name. Those are both in the wp_usermeta table and should show up on the users profile page.

    It is very possible that the plugin you referenced changed the database structure or made some other modifications. You can see the default db schema here: https://codex.www.ads-software.com/images/9/9e/WP3.0-ERD.png

    Thread Starter maxo9000

    (@maxo9000)

    Thanks Chris I will try that.

    What I think is odd is that in the db schema you linked there is no first_name and last_name also same here http://codex.www.ads-software.com/Database_Description

    But I will take you word for it since Im still learning ( actually learning alot about the backend of wordpress )

    Thread Starter maxo9000

    (@maxo9000)

    On a different site and install of wordpress I get this

    * WordPress > Users > All Users – all columns show data
    —> URL shows : wp-admin/users.php

    * WordPress > Edit > User Profile
    —> URL shows : wp-admin/profile.php

    * WordPress > Type in First Name field > aaa
    * WordPress > Type in Last Name field > bbb
    * WordPress > Update User
    —> URL shows : wp-admin/profile.php?updated=true

    are these different urls a clue?

    Thread Starter maxo9000

    (@maxo9000)

    Let me share with you how I fixed this so far without re-installing everything..

    back in cPanel MyPHPAdmin.
    * DROP or Delete from the wpdatabasename_users table the first_name and last_name column!

    Basics I should know already but because Im a cowboy!
    Lesson 1. dont work on the production version of the site to make plugin/coding changes.
    Lesson 2. beware of plugins that alter sql database!

    Thread Starter maxo9000

    (@maxo9000)

    im closing this topic thanks again chris for pointing out the db schema!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘first_name last_name can't display or resets’ is closed to new replies.