You do thing from a sql command either through mysql administrator, phpmyadmin (or whatever it’s called).
what file am i editing though?
You’re not editing any specific files. You’re running a command to insert some text into the database
insert into wp_usermeta values (null, 1, ‘wp_user_level’, 10);
Ran the command but it didn’t fix the problem… below is the query:
INSERT INTO db41285_wordpress.wp_usermeta (
umeta_id ,
user_id ,
meta_key ,
meta_value
)
VALUES (
NULL , ‘0’, NULL , ‘(null, 1, ”wp_user_level”, 10);’
);
Did I do this right?
Actually this “Fix” is completely unnecessary.
In your users menu is the name you wish to publish under classified as an Author or higher? Does the Name Field have an entry? the Nickname? the Username (which you can’t change)? Are they all the same/different?
USERS MAIN SCREEN (example)
Username: Ripose (registered username)
Name: Ripose (displayed under Name on Users screen)
E-mail: ripose@mymail.com (the Registered e-mail address)
Role: Author (must be author or above)
Posts: 2 (number of posts written by this person)
CLICK on Username > Click on Role > Select Author
Enter ALL names in the RIGHT places
Click on Update User
Click on Display Name Publicly As
Select the appropriate name
Click on Update User
Also whatever name you login with will be the default Author.
But the name that is displayed can be different from the author/username/nickname depending on the names you entered above.
Yeah I know, I gotta get my screen capture working.
Have a great day!
I had the same problem that was fixed by recordinghacks suggested SQL. No amount of editing data through WordPress would fix the problem.
Thanks for the posts. I’m using 2.61 and I also ran into this problem after set up the flickr blog.
I’ve since logged onto phpMYadmin and confirmed that there was no user level defined for the admin id 1 so I tried to add it using
wp_usermeta values (null, 1, ‘wp_user_level’, 10);
but when I use the command in manager I get an error saying, “You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.”
Any ideas am I using the wrong synatx?
I tried using phpmyadmin’s GUI ‘insert’ option but I can’t add the line that way either because it proxies through my hosts server and not directly with my db.
I don’t have access to sql server so I can’t access the tables directly any ideas?
ok, figured it out. I was able to resolve the 3rd party hosting phpmyadmin proxy issue and access my tables directly by downloading this WP-Plugin.
I wasn’t sure it was going to work with 2.61 since it stats that its only supported up version 2.1 but it ended working like a charm.
Thanks again for recordinghacks and everyone for the post.
I’m on wordpress 2.6.2, added in a new user at Author level and lost the admin account in the drop down.
Applied sql fix above and it has successfully fixed the issue for me. For now.
Has anyone recorded this as a bug?
Definitely a bug. I recently upgraded to 2.6.2 and I encountered the same problem again. The SQL fix above worked again.
Thanks for this. I was having the same issue which was driving me mental. The SQL fix worked like a charm!
I won’t say that this “Fix” is “completely unnecessary”, but I do think that I found another workaround for this issue. I have WordPress 2.7 installed on a GoDaddy hosting account (installed by GoDaddy’s one-click install service) and I’m not completely comfortable running database commands.
I had been creating pages without incident using the original admin (1) account that has Administrator level access. Once I created three additional accounts (2) with Editor level access, I no longer had the ability to create or edit a page so that the author of the page was the admin (1) user.
I checked to make sure that the users did not have any duplicate profile information, aside from them all having the same Website.
To fix this, while logged in as the admin (1) user, I changed one of the editor accounts (2) to give it Administrator level access.
I then logged in on another browser as the editor (2). Next I changed the admin (1) account to just Editor level access (press the Update Profile button) and then changed the admin (1) account back to Administrator level access.
I was now able to change the author of any page to the admin (1) user. The last step I had to take was to login as the admin (1) user and change the editor (2) account back to Editor level access.
I think this is confusing so hopefully the (1) and (2)s will help make it clear which user profile I’m referring to.
I have reported this as a bug, since it didn’t appear that anyone else had.
I have the same problem, one thing i’ll add is that when you login as admin and do a quick post instead of using “add new” the post, wp gets the correct author.
I just had the same issue in WordPress 2.7.1. I’m not much for messing around in SQL, so I followed @ntharp’s suggestion. I changed one of my authors to an admin, logged in under him, changed my admin user to author, went to the new post, and my name was now in the author dropdown. I selected it and published, then went back and changed my admin user back to admin, and logged back in to my user and my name is now in the Author dropdown again. That was a boatload of joy!
Kristi
http://kikolani.com
