WordPress Error: You do not have sufficient permissions to access this page
Some people, upon upgrading from WordPress 1.5.x to 2.0.x have been experiencing this error:
You do not have sufficient permissions to access this page
The most common cause of this error is an upgrade that didn’t complete. The database number has been incremented, so WordPress thinks it is up to date, but it hasn’t yet written the permissions that you will need to access the WordPress admin interface.
I have written a script to force the 1.5.x to 2.0.x upgrade.
Download
Instructions
- Click “Download” and save as
force-upgrade.php - Upload
force-upgrade.phpto your WordPress root directory (the directory withwp-config.php) - Access the file in your browser (e.g.
http://example.com/wordpress/force-upgrade.php) - Delete
force-upgrade.phpfrom your server
I won’t promise you that this will solve all your problems, but it has helped several people who have tried it. Let me know how you fare.
Hey, It Worked For Me!
Josh
April 9, 2006 at 3:44 pm
[...] I found this helpful post from Mark Jaquith where he provided a script to “force” the WordPress upgrade to finish. It worked perfectly and now I’m back in business. [...]
Steve and the Software » Blog Archive » Upgrading to WordPress 2.0.x
April 21, 2006 at 3:25 pm
Excellent job. Thanks so much for the assist.
Thom
May 2, 2006 at 11:51 pm
This is the sequence of events when I run your script. Thoughts? Thanks much!
WordPress loaded…
Upgrade functions loaded…
Object cache flushed…
Database made current…
Fatal error: Call to undefined function: upgrade_160() in /home/vatulnet/public_html/blog/force-upgrade.php on line 35
Maitri
May 18, 2006 at 9:39 pm
I guess I need a new upgrade-functions.php file with a definition for upgrade_160.
Maitri
May 18, 2006 at 9:46 pm
Yeah, you’ll need the latest version of WordPress with upgrade_160();
Mark Jaquith
May 22, 2006 at 6:50 pm
Hi Mark,
Thanks for the script – gave it a spin but no joy. I am only encountering this issue with users who sign up to post comments. Admin is fine.
Still hunting for a cure!
All the best,
Tom
Tom
June 3, 2006 at 3:18 am
[...] [Update: Tried out the advice listed here, alas no joy as yet] [...]
I Got Off My Assets » Blog Archive » Wordpress Upgrade Problem
June 3, 2006 at 3:24 am
Tom,
Possible problem:
Maybe your default role (subscriber?) doesn’t have any capabilities. Try the Role Manager plugin (Google it) and make sure the Subscriber role looks correct.
Mark Jaquith
June 3, 2006 at 4:38 am
Hey Mark,
Thanks for that – installed the Red Alt version, and upped the permissions to allow a subscriber to “Edit Post” (closest thing to post comment I could see).
Clicked on the “logged in” URL and it allowed me to login – yeah, unfortunately thrown straight back to the original post with no option to add anything.
Curiouser and curiouser.
Appreciate the heads up on the role manager – didn’t have a clue it was required.
“Everyone is ignorant – only on different subjects…”
All the best,
Tom
Tom
June 3, 2006 at 8:02 am
man.. I LOVE YOU!THANKS I Resolved my problem!
caipiracity
June 24, 2006 at 12:11 pm
You’re a genius! Thanks!
amsterdam
September 10, 2006 at 10:21 am
seems to be working, thanks for making my day easier!
Eirik
September 25, 2006 at 11:29 am
[...] _ WordPress Error: You do not have sufficient permissions to access this page « Mark on WordPress Doing WP upgrades? Check it out… [...]
WordPress Error: You do not have sufficient permissions to access this page « Mark on WordPress » oneafrikan.com
November 15, 2006 at 8:54 am
Mark! THANK YOU!! OMG, I was freaking out. I’m finally going to start blogging on scripty again, upgraded to the latest version of WP, it failed, couldn’t access anything… this did the trick. THANK YOU THANK YOU THANK YOU!!!
Jennifer
December 22, 2006 at 10:01 pm
[...] 1) When I ran the upgrade, it sort of died before finishing… I refreshed and it told me it was all set. Checked on the main page, and everything seemed to be okay – but when I logged in to start tinkering around with the settings, I couldn’t log in completely. I got the dashboard with no navigation and then I clicked on something and all it wanted to do was send me to the profile page – but with nothing showing except “You do not have sufficient permissions to access this page”. Googled for a solution and found one on Mark’s site. Ran his script, and all was well again. [...]
scriptygoddess » Overcoming the upgrade
December 23, 2006 at 2:25 am
Thanks mark! It worked.
Colin Nederkoorn
January 8, 2007 at 5:33 pm
[...] encontré esta página que explicaba el error, y pude [...]
Wordpress multilingüe · Galder.net web –> blog
January 18, 2007 at 3:48 am
when i upgrade 2.0.5 to 2.1, i met the same problem, unfortunely, it doesnt work any more, can you write a new one to solve “to 2.1″problem?
SkyLanD
January 25, 2007 at 1:11 pm
did this… then i could log in.. but do not have admin-rights now :/
WKR AveN
AveN
February 19, 2007 at 6:11 pm
please help
i moved my db, i added prefix to it, i went and manually changed wp-config.php and added my prefix there, but now it takes my username and password for wp-admin, but i get following error
You do not have sufficient permissions to access this page.
and i haven’t changed word press itself, i’m on same version
alexus
April 9, 2007 at 4:10 pm
From 1.5 to WordPress 2.1.3 it works! Useful script, thanks.
echowebspace
April 10, 2007 at 5:11 am
I tried using this software as I have had problems since attempting to upgrade from 1.5 to 2.1.3.
Unfortunately, the problems still remain. My DB tables seem to be a mixture of 1.5 and 2.1
When running force-upgrade.php, I got:
WordPress loaded…
Upgrade functions loaded…
Object cache flushed…
WordPress database error: [ALTER command denied to user 'smargolisbl'@'localhost' for table 'wp_categories']
ALTER TABLE wp_categories ADD COLUMN link_count bigint(20) NOT NULL default ‘0′
WordPress database error: [ALTER command denied to user 'smargolisbl'@'localhost' for table 'wp_categories']
ALTER TABLE wp_categories ADD COLUMN posts_private tinyint(1) NOT NULL default ‘0′
WordPress database error: [ALTER command denied to user 'smargolisbl'@'localhost' for table 'wp_categories']
ALTER TABLE wp_categories ADD COLUMN links_private tinyint(1) NOT NULL default ‘0′
WordPress database error: [ALTER command denied to user 'smargolisbl'@'localhost' for table 'wp_posts']
ALTER TABLE wp_posts CHANGE COLUMN post_status post_status enum(‘publish’,'draft’,'private’,’static’,'object’,'attachment’,'inherit’,'future’) NOT NULL default ‘publish’
WordPress database error: [ALTER command denied to user 'smargolisbl'@'localhost' for table 'wp_posts']
ALTER TABLE wp_posts CHANGE COLUMN post_type post_type varchar(20) NOT NULL default ‘post’
WordPress database error: [ALTER command denied to user 'smargolisbl'@'localhost' for table 'wp_posts']
ALTER TABLE wp_posts ALTER COLUMN post_type SET DEFAULT ‘post’
WordPress database error: [ALTER command denied to user 'smargolisbl'@'localhost' for table 'wp_posts']
ALTER TABLE wp_posts ADD KEY type_status_date (post_type,post_status,post_date,ID)
1. Added column wp_categories.link_count
2. Added column wp_categories.posts_private
3. Added column wp_categories.links_private
4. Changed type of wp_posts.post_status from enum(‘publish’,'draft’,'private’,’static’,'object’,'attachment’) to enum(‘publish’,'draft’,'private’,’static’,'object’,'attachment’,'inherit’,'future’)
5. Changed default value of wp_posts.post_type from to post
6. Added index wp_posts KEY type_status_date (post_type,post_status,post_date,ID)
Database made current…
Data upgraded…
Rewrite rules flushed…
Object cache flushed…
Hopefully that did it! DELETE THIS FILE FROM YOUR SERVER NOW!
And then, try to access your /wp-admin/
Any suggestions?
Thanks
Steve M
April 16, 2007 at 7:12 am
Update:
I finally managed to fix this by clearing the database and starting with WordPress’ own ‘wp-content’ folder. Problem solved.
Steve M
April 17, 2007 at 4:57 am
Thanks! worked for me in 2.2.
Joe
May 29, 2007 at 6:37 pm
[...] in Google op de foutmelding bevestigt (hier) situatie na manueel wijzigen van [...]
Linuxuser LigLog » WordPress probleem:
June 3, 2007 at 6:41 pm
don’t know what really worked for me, but I deleted a “mailing-list.php” plugin file from the plugins folder because it was including the “upgrade-functions.php”, in which some function (don’t remeber which) was redeclared.,..
Hell of a mess, I know. If anyone has mailing-list plugin and the same problem “not have sufficient permissions to access this page”, delete it!
danijelkurincic
June 4, 2007 at 8:01 pm
For those who get this error randomly, without having upgraded WordPress recently, it’s caused by a database table being corrupted. Log in to MySQL and perform a repair using the syntax
repair table tablename
This fixed mine the first time I tried it.
Ross Shannon
June 11, 2007 at 12:48 pm
Thanks. It worked fine with me.
A clarification for the not-so-fast: The force-upgrade.php is to be run AFTER uploading the files of the new version to the server.
Regards
Mortenoc
Mortenoc
July 10, 2007 at 8:30 am
Thanks heaps for this
Fix my upgrade to 2.2.1
fms
July 20, 2007 at 12:55 am
worked well, thanks
Anthony Lynch
July 26, 2007 at 12:36 pm
[...] the googled the error code, and found Mark on wordpress’s force-install script. Which comes under the theory that wordpress didn’t complete an [...]
Utah Tech Jobs : Blog Backup Scare
August 19, 2007 at 3:20 am
I have filed a bug to remove the $table_prefix in the column names which causes this problem in the first place.
http://trac.wordpress.org/ticket/4780
Ciao!
The Doctor What
August 20, 2007 at 11:11 am
i hadn’t upgraded anything WordPress on my site in a couple years and yesterday i started getting the error after logging in to my admin page and trying to go to my profile (none of the usual menu items were there):
“You do not have sufficient permissions to access this page”
I tried the script and now i can’t even get in to the admin page…
urgh… any ideas would be GREATLY appreciated.
thanks,
ryder
ryder
September 26, 2007 at 5:18 pm
THANKS !!! YOU ARE A GENIOUS
Periko
October 4, 2007 at 5:59 am
I used your upgrade script – and this got me further, but my admin account seemed to have no admin privs. All I could do was edit my profile – not post, nothing. I think the reason was that in the process of upgrading I also changed my blog prefix name. And this does bad things to wp_usermeta
Here’s what I did to fix:
Go into wp_usermeta in mysql and change all the meta_keys that proceed with the old blog prefix table name to the new blog prefix table name.
Bryan
October 11, 2007 at 10:43 pm
Bryan your solution is brilliant, easy and did not require any other scripts. excellent man
stef
November 4, 2009 at 10:27 pm
can logged into the dashboard but dunno wat happened now, i can see only the dashboard and profile links there
Pritam
October 12, 2007 at 2:57 pm
the download link is not working!
http://txfx.net/files/wordpress/force-upgrade.phps
chris
October 20, 2007 at 3:53 pm
Thank you so Much this is an awesome and clean fix.! My site http://www.caffination.com would not be up and running right now without you. Works for botched installs from wordpress 2.2.X – 2.3.1. Many thanks!
CaffiNation Paul
November 2, 2007 at 3:27 pm
Awesome, thanks
Luther Blissett
November 6, 2007 at 10:12 pm
what the hell! it worked! you are awesome man…
cheers! 
aj
November 17, 2007 at 12:25 am
Thanx!
Cedric Weber
November 20, 2007 at 10:02 am
good work, i’m not use it yet, but download it just in case i need it in near future
webringet.com
December 2, 2007 at 2:47 am
[...] “You do not have sufficient permissions to access this page” поздравляю, вам сюда. addthis_url = location.href; addthis_title = document.title; addthis_pub = [...]
Меняем префиксы у таблиц wordpress | Блоговодство
December 5, 2007 at 2:32 pm
cingular shop ringtones free ringtones from cingular cingular ringtones
Whom get free ringtones for my cell phone advance cash lawsuit loan
cingular ringtones cingular shop ringtones free ringtones from cingular
December 14, 2007 at 11:18 pm
nokia composer ringtones free nokia tracfone ringtones
As online cash advance info nextel remember ringtones
lawsuit settlement cash advance
December 14, 2007 at 11:44 pm
Bryan – October 11, 2007 at 10:43 pm :I used your upgrade script – and this got me further, but my admin account seemed to have no admin privs. All I could do was edit my profile – not post, nothing. I think the reason was that in the process of upgrading I also changed my blog prefix name. And this does bad things to wp_usermeta
Here’s what I did to fix:
Go into wp_usermeta in mysql and change all the meta_keys that proceed with the old blog prefix table name to the new blog prefix table name.
I have the same prob. The upgrade script worked, I also change the meta_keys of the old prefix table name.. I still don’t have the admin priviledges in admin account. I can’t edit posts. pls help!
jmie
December 18, 2007 at 3:51 am
Hi,
Well done.
It actually worked in fixing my WP 2.2 admin login problem. Before running the script, it keep complaining I have no permission to access the admin’s profile despite I am already using admin profile.
FYI. I am using free hosting from http://www.freehostia.com.
Paul Loke
December 18, 2007 at 6:34 am
cash advance loan no faxing cash in advance loan
Also quick cash payday loan baccarat software
overnight cash advance advance cash overnight
January 20, 2008 at 7:51 pm
I had same problem as paul loke and primas.
after ran the scripts i got the error as primas. but progressed to admin page. but can’t see write , manage , etc option. Only dashboard and profile. Any solution ?
steven
January 24, 2008 at 8:38 am
info nokia remember ringtones
Is klingeltne per sms moniniset soittonet
poly klingeltne
January 24, 2008 at 5:47 pm
free mobile motorola ringtones
A best card credit secured 3.16 gold mp3 ringtones
merchant services credit card processing
January 25, 2008 at 1:11 pm
freie klingeltne
No matter texas holdem starthnde advance card cash credit
0 advance card cash credit instant online guaranteed cash advance credit card cash advance credit card
January 29, 2008 at 7:45 am
Nowadays free us polyphonic ringtone croupier fold slow basic bank back free polyphonic ringtone for alltel circle railroad weak 100 gratis klingeltne speek kicker pocket symbols.
realtone klingeltne
February 1, 2008 at 1:42 pm
Jugar poker regeln zum download Kugel paar gekommen overplay kostenloses online poker spiel Überbrücker Zweien rain Klaps Diamanten Banknotenrolle poker spiel lernen paigow steif Neutrales!
24 ringtones theme 24 theme ringtones
February 1, 2008 at 2:06 pm
poker superstars online game
Morgen advance cash day pay advance cash day in loan pay uk
inheritance cash advance
February 2, 2008 at 2:08 am
cell free phone razr wallpaper
Unhappily free polyphonic ringtone for nokia 3560 free motorola cellular phone wallpaper
cell free phone upload wallpaper
February 2, 2008 at 2:58 am
des jeux de poker telecharger
Thanks polyphone klingeltne downloaden les rgles de jeu poker
sonneries tlphone
February 2, 2008 at 3:16 am
this topic is not used and moderated anymore? … i also have some problems..but as i can see..nobody is here anymore
adleras
March 6, 2008 at 12:32 pm
download free ringtones tracfone
Each free sprint sanyo ringtones dash mobile ringtones t
polyphonic ringtones for sony ericsson
March 15, 2008 at 3:07 am
yikes
it came in as a quicktime file.php
granted i dont understand any of this but that seems weird.
will you call me
213-435-3665
thanks,
marion
sweeteorgiapeaches
March 16, 2008 at 2:41 pm
[...] then coba search googling dan nemu cara buat membereskan masalah itu. Masuk aja disini cukup download dan upload filenya lalu dijalanin. Ntar uotputnya kayak gini: WordPress [...]
IncridiBlog » Blog Archive » Mengatasi Wordpress Error “You do not have sufficient permissions to access this page”
March 17, 2008 at 8:14 am
Did the job for me! Perfect! Thanks a lot!
Leen
April 3, 2008 at 2:07 pm
OBRIGADO!
thankx a lot!
você salvou minha vida =DD
o/
dHEKU
April 9, 2008 at 9:08 am
I am trying to install a new theme in word press 2.o but any theme i chose it comes up with an error “Broken Theme” and “style.css is unreadable”.
Any comments much appreciated.
John
April 9, 2008 at 7:33 pm
Works for me!!Thanks
Funciono barbaro gracias por la info!!
Maurito
April 10, 2008 at 10:37 am
ohh maaan thx!!!!!!
Olaf
April 10, 2008 at 7:52 pm
I’ve upgraded to WP 2.5 but I’m still unable to get rid of this error message and am still locked out of the admin module. I’ve tried all the fixes suggested on this page
What else can be done? Is the WP crew unaware of this problem that seems to be affecting so many people and are they not working on a fix for it?
Hopefully, they are, otherwise I’ll have to replace my blog script with another, more stable platform.
aviation art
April 13, 2008 at 5:12 am
Thank, it worked.
Biju
April 15, 2008 at 2:36 pm
worked for me! Thank you for taking the time to help us out. It is much appreciated.
-J
Twelfth St. Media
April 16, 2008 at 3:31 pm
Not only did it not work but it completely wiped clean all of the content from my website. You’re shitty little piece of code may help some people but the damage it does to others is greater.
Pierrot
April 21, 2008 at 4:21 pm
Thank You very much for saving me another big headache! Thank You!
Tom
April 30, 2008 at 5:40 pm
FIXED!!!!
OK gang – if you run the script and can then LOGIN but only get the Dashboard and Profile, you must do 2 things
1) In you wp_usermeta table make sure your meta_key entries are correct (e.g. wp_capabilities and wp_userlevel on a default configuration.
2) delete the extra wp_capabilities entries the script has added to the end of your table. by default if will add a:1:{s:13:”subscriber”;b:1;} to your wp_capabilities – which makes your admin account a subscriber only.
SumOf.Us
May 5, 2008 at 6:29 am
[...] Well, this was difficult. I have been using a blog on blogger, but since I have subscribed to a webhost I wanted to host my own blog. Easy right? No, not so… Seems that the installation of wordpress fails to add an admin user correctly. Took me ages to find out how to do it. But for a solution look here. [...]
Watmough’s Blog » Blog Archive » Hello
May 7, 2008 at 4:25 am
Thanks man !!!
It worked for me (from 2.1.3 to 2.5.1)
you made my day
orbit
May 13, 2008 at 11:57 am
Thanks a lot, You did it, it works
Cesar Perez
May 17, 2008 at 5:22 pm
[...] sufficient permissions to access this page’ error. Lucky enough I found elegant solution on http://markjaquith.wordpress.com. Thank you [...]
Problem with copy of Wordpress DB tables at szudejko.net
May 29, 2008 at 5:51 am
The plugin wordphonic 1.02 was causing the problem in my site, try deactivating it.
Anastasios
May 29, 2008 at 6:40 pm
I had SERIOUS doubts this would work since I had a working version of 2.5.1 but after changing table names and moving some files around I got this error. This php file totally fixed it! THANK YOU!!!
kathy
June 9, 2008 at 9:07 pm
ACK! I can get to the dashboard but NOTHING else!!!
kathy
June 9, 2008 at 9:07 pm
It worked!
Thanks!!!
Chris
June 11, 2008 at 9:45 pm
[...] thanks to this guy, I finally got my blog back up. Good thing too, since I need to do a lot of venting about a lot of [...]
Ambient Crisis » I’m back!!!
June 11, 2008 at 9:50 pm
Excellent! Thanks. I had this problem after using WP-Security-Scan plug in on a WP 2.5.1 installation and this fixed it right up.
Anysia
June 16, 2008 at 3:17 pm
thx
I used it a couple of minutes ago on v2.5.1, and everything works fine now.
g;)
gino
June 30, 2008 at 8:02 am
Hi Mark,
I had a crash in the middle of an upgrade and your fix helped me get into the dashboard, but I can’t navigate past that point. Can you think of any other files that might need to be “upgraded” so that we can access all of the admin panel?
If you think of something, please use small words as I am not a programmer.
Unspeakably Violent Jane
July 17, 2008 at 3:02 pm
[...] this is the case, you can find a fix here. You’ll need to download a fix and run it on your server but I’ve had great success [...]
WordPress Error: You do not have sufficient permissions to access this page | wordpressguru.eu
July 19, 2008 at 5:35 pm
no me funcionó
RP
July 20, 2008 at 11:14 pm
illinois auto insurance rate…
badge Yoder adds rasps perfectible climes …
illinois auto insurance rate
July 29, 2008 at 2:48 am
Thank you Mark. Worked in v2.5.1. Awesome!
mercime
August 6, 2008 at 1:31 pm
For those of you who encountered this error, and are in the process of moving WP to another spot… and changed the base table names in the process (e.g. the old tables had the prefix “wp_” and you chose to change it to “XX_wp_” in the new spot) then please take a look at this link:
http://www.lildude.co.uk/howto-change-wordpress-table-prefix/
It turns out that THAT was the reason we couldn’t log into the admin, and the solution presented here just ended up putting garbage information into the database that we had to delete.
hermes
August 7, 2008 at 7:12 pm
Thanks! worked nicely
Genaro Rocha
August 26, 2008 at 5:01 pm
[...] http://markjaquith.wordpress.com/2006/03/28/wordpress-error-you-do-not-have-sufficient-permissions-t... [...]
ChokeLive Podcast - My Wordpress Cannot Login
August 27, 2008 at 11:30 am
Worked for me too, great job
California SR22
September 20, 2008 at 9:47 pm
Worked a treat – thanks a bunch! And this was applied to a 2.5 db, through a hosting company, they must have run the upgrade en masse and not noticed it not working.
Kev Brown
September 26, 2008 at 12:40 am
[...] tersebut bisa juga karena proses upgrade yg ga lengkap, markjaquith udah nulis tuh INGAT, BACKUP DAHULU DATA ANDA SEBELUM MELAKUKAN [...]
Tips memindah wordpress hosting server | CoLiq
October 7, 2008 at 6:32 am
Three cheers for the genius!!! Thanks!! I’m back at work again.
David Radovanovic
October 22, 2008 at 12:28 pm
Nice! Thanks!!!
Adam
November 2, 2008 at 8:20 pm
Zx93fcdmlkEqo09
ou gc ih
ju ds ta
josh
December 11, 2008 at 2:54 am
[...] y muchas de ellas referían un script llamado force-upgrade.php. Efectivamente lo encontré en http://markjaquith.wordpress.com/2006/03/28/wordpress-error-you-do-not-have-sufficient-permissions-t... , lo bajé y lo ejecuté. Seguía con lo mismo del mensajito este. Después de un rato de navegar [...]
You do not have sufficient permissions to access this page | ¡Un mexicano en Japón!
December 11, 2008 at 5:54 am
did not worked for me. i’m using wp 2.7
vetvrijcom
December 22, 2008 at 3:22 pm
Did not work for my 3.0 install.
Any updates for 3.0?
Thanks
Chas
January 26, 2009 at 8:42 pm
[...] Forcing a database upgrade after one has been left incomplete for one reason or another [...]
Nuudelisoppa » Blog Archive » The Pain of WordPress: “You do not have sufficient permissions to access this page” when trying to upgrade
February 11, 2009 at 7:07 am
[...] Download the force-upgrade script and run it. It’s a fairly old script but since it all it does is invoke [...]
Fixing permissions after a Wordpress prefix change
February 13, 2009 at 8:26 pm
Thanks a lot for the fix.
It worked like a charm.
Happy coding
Israel
February 22, 2009 at 12:26 am
worked perfect for me after upgrading from 1.5 to 2.7.1 and getting locked out of my admin. thanks.
darren mccoy
March 5, 2009 at 6:38 pm
[...] If you’re upgrading from a previous version of WordPress and you get the permissions error, you might look at this solution. [...]
WordPress Error: You do not have sufficient permissions to access this page | Es Developed - Fresh Website and Graphic Design
March 16, 2009 at 6:01 am
i tired force express, it made the site run — but unfortunatley i can post or edit
butter
March 20, 2009 at 1:30 pm
Thanks Mark for your force-upgrade script. For al those that are having trouble with this as I have this is what I did to fix my problem. I am a novice on databases so I first did the one-click install that my hosting provider (Media Temple) provided to create the tables.
1) One Click Install (version 2.0)
2) Went to login into WP and it accepted my login information
3) Got message: You do not have sufficient permissions to access this page error
4) Downloaded and ran Mark’s force-upgrade.php file
Force Upgrade for WordPress
4) Opened up Plesk – used Database WebAdmin to bring up PHPMyAdmin
5) Click on the User_Meta Table
6) Made sure table prefixes were consistent and correct
7) Saw that I now had an extra line in user_meta named ‘capabilities’ instead of ‘wp_capabilites’ and the value was “subscriber”
10) After all this was complete. Everything showed up in working order in my admin panel.
Hope this helps somebody.
bedrockconnect
March 22, 2009 at 9:36 am
I just want to say that I was getting what I thought was this error, and it turned out to be something very silly–I was copying my urls from my FTP, and so they all started with ftp rather than http.
I imagine everyone else is a little more savvy than that, but just in case anyone else is that silly…
KJ DellAntonia
March 30, 2009 at 12:31 am
Why I always login to admin profile, the others menu disappear, any help?
stopanos
April 4, 2009 at 4:24 am
Yeah!
I’ve been at this ALL day. I’m a complete web amateur, but great tips here helped sort it out!
Thanks!
antonthehill
April 5, 2009 at 12:09 pm
Sweeet! Worked like a charm!
Clint
April 7, 2009 at 7:02 pm
Thanx a bunch!!!
Worked with no probs…
Saved so much research time.
cheers,
Chippa
Chippa
April 9, 2009 at 7:19 pm
Thanks man, you saved my day.
Parry
April 18, 2009 at 9:54 am
[...] Second I tried the Force install from here : http://markjaquith.wordpress.com/2006/03/28/wordpress-error-you-do-not-have-sufficient-permissions-t... [...]
WordPress issue is as below « Brewing Ideas
April 19, 2009 at 4:07 am
Bottom line: the force-upgrade worked. Thanks, Mark!
A little more info about my unique situation might shed light on what’s really going on — I include my guesses; feel free to enlighten me.
I have two blogs at two different websites. I installed a WP 2.7 instance from scratch a few weeks ago at one of the sites, and have been playing with all the plug-ins, templates, etc. to determine how much of a website (beyond the blog) is possible with WP. Templates with menus and other pages make this environment rich — I imagine many people build their entire website in WP.
I then tried to install WP on the other website. Unlike the first one, this site only had WP 2.0, the 3 year old version. I installed it, and then expected to do an upgrade to 2.7. The upgrade from wordpress.org downloaded 2.7 to my home computer, leaving me with the need to FTP it up to the website.
Since there was no script to do this, I created a completely parallel instance. But since this 2.7 was completely vanilla, I had to copy the wp-config file over so it would know where the data base was. It found that OK, noted that it was out of date, and upgraded it (or at least said it did). That’s when I tried
to login thru the browser as admin, and when I hit the ‘you don’t have permssion…’ . So going to Google with the error message, I found your site, downloaded your force-upgrade.php, and finally got to the 2.7 dashboard.
Now I am working on the next problem — 2.7 downloaded from wordpress.org doesn’t have anywhere near the dashboard controls of the other 2.7 — just Profile and Tools; no Appearance, Plug-ins, etc. I am assuming that there are more php files I need to activate, and if I look at the directory structure at the two sites, there are differences beyond the theme I downloaded. I still wonder about how various downloads differ at this basic level. Certainly I would expect to have to download plug-ins one by one, but the general dashboard access points ought to be common for the same version. Right?
Charles
April 19, 2009 at 1:46 pm
Thanks very much. This worked on 2.7.1
Andrew
April 29, 2009 at 5:01 pm
[...] not complete, so you have to forece it to complete. I found a neat little utility someone wrote to force wordpress to update. So I grabbed it throw it on the server and ran it. It said that it completed successfully, so I [...]
wordpress upgrade « My website, blog and portfolio…
May 13, 2009 at 10:21 pm
Thank You! Worked for me.
~~CursedRumaks
June 8, 2009 at 4:24 am
Thanks a lot for the script, seems to work all the way to wp 2.8.
By the way, this was caused by WP-Security Scan, damn that plugin!
wolfheart
June 13, 2009 at 12:46 pm
it didnt work for me.
i am unable to acesss my admin an after that i tries your script.
it didnt work..
Gurpreet
June 22, 2009 at 4:32 am
Awesome. W0rked for me! Thanx
Dj Skunk Diesel
June 22, 2009 at 5:17 pm
Thanks a lot my friend!!!!!!!!!!!!!!!!!!!!!!!!!!
Work perfect with 2.8
leonidas
July 9, 2009 at 4:57 pm
Worked like a champ after an update from WordPress 2.7 to 2.8.1. Thanks a ton!
Jack
July 13, 2009 at 1:00 am
Hey this worked! I just fixed this error on a 2.8.0 installation with it. Good stuff.
Web Guy 303
July 18, 2009 at 3:29 pm
Muchas gracias hermano,
si funciona exelente
Rube
July 19, 2009 at 1:33 pm
Hi it works for me too.. nice job!
Thanks a lot
karthikeyan
July 29, 2009 at 6:28 am
I owe you one…. it worked on 2.8.2
Thank you Sir…
D Mang
July 29, 2009 at 6:52 pm
A life-saver, thank you.
Tatesjourney
August 8, 2009 at 10:42 am
Its working… wow!!!
Raja
August 13, 2009 at 5:24 am
WOHO awesome, it fixed it
ElNino
August 16, 2009 at 3:37 pm
Hi,
I get the same error message, but only for the plugin “pn-counter”.
I use WP 2.8.4, and it’s running well for the rest!
I have tried several solutions, but the same error message is popping up every time I will give pn-counter a try!
Thanks,
Eno
enoword
August 18, 2009 at 11:41 am
[...] http://markjaquith.wordpress.com/2006/03/28/wordpress-error-you-do-not-have-sufficient-permissions-t... [...]
oh, oh! problemas | Libro de Apuntes
August 22, 2009 at 2:02 pm
Thanks a lot.
That has able to access my admin side.
Priyanka
August 27, 2009 at 1:18 am
Thank you so much !!
You save me.
Thanks
ben
August 27, 2009 at 1:09 pm
But it didn’t help my problem with pn-counter. . . .
What else to try ?
??
Eno
August 28, 2009 at 3:15 am
May i know why i post comment on someone blog but the comment never show up?Can u help?Thanks
Melody
August 29, 2009 at 11:39 am
well, I’m having the pb with the NowReading plugin .. I’ve tried your fix but it seemes it doesn’t work for me .. I’m still having the problem ..
cannelle
September 7, 2009 at 7:30 am
It didn’t work for me with version 2.8, not sure what it could be, but several plugins gave me the same error.
trendmx seo
September 7, 2009 at 12:42 pm
you helped me a lot! Thanks!
Oshik Ernst
September 16, 2009 at 5:59 am
OH thank You can make me easy
CandyMan
September 18, 2009 at 12:38 pm
perfect it works for wp 2.8
bill
September 20, 2009 at 12:40 pm
Thank you thank you thank you,
Wow, it turns out it was erroring. I had a lot of trepidation over downloading a php script from txfx.net when a link was on this site markjaquith.wordpress.com, but damn that worked. I thought this blog was wrecked.
Thanks!
racy_rick
September 22, 2009 at 3:45 pm
Thanks. That worked a treat. I thought it was a file permission problem with the Thesis theme which I was trying out on a spare domain.
Zotrim
September 26, 2009 at 11:23 am
[...] this is the case, you can find a fix here. You’ll need to download a fix and run it on your server but I’ve had great success with it [...]
How to solve : You do not have sufficient permissions to access this page | Shafiq Ahmed Saifi | Open Source CMS Development/Implementation News , Articles and Resources
September 30, 2009 at 4:05 am
Hey it works. Great Thanks to you! I’ve problems with my plugins before but it’s all fixed now.
Syafree
October 3, 2009 at 7:56 am
You rule!
I couldn’t get into any admin page after installing WP 2.0 from Plesk.
I’ve used your file – it said that there was some error but anyway now i have admin privileges
Grubas
October 7, 2009 at 5:30 pm
i fucking love you man
i tryed editing my user in the data base – failed
i reseted my password a couple of time – failed
i searched in the scripts for a pass mix up – failed
used force-upgrade.php : WORKED
thank you for the script
nfo911
October 9, 2009 at 7:15 am
ALL BEGAN TO WORK!!!! THANK YOU FRIEND!!! Let God bless you!
Frienddesign
October 12, 2009 at 7:22 pm
How can I Solve this problem. That when I leave a comment on the blog. It shown me this Web. This is the url can help me check it out thanks .
URL:http://www.ttfatloss.com/wp-comments-post.php
It show some WordPres> Error
chewyishen
October 14, 2009 at 11:08 am
worked like a charm! thanks for making the process so easy.
morgan
October 15, 2009 at 7:23 pm
Your the shit… worked for me like a charm
Sativa_Smoke
October 16, 2009 at 3:57 am
Hi Mark
Thanks VERY much for the script.
It didn’t work the first time so I had a little look-see and the following comments are for anyone who is not getting the page to display correctly so that the script can actually be run:
—-
You might be having an issue due to the frames the script comes wrapped in.
I opened the file that I’d downloaded with my text editor, copied out the code, saved it as a fresh “force-upgrade.php” file (containing JUST the code I needed — without the frames), uploaded that to my server, and navigated to the page… voila! I could see the message saying “Please click here to force the upgrade”
I did, it worked, I deleted the file, yay!
Thanks a LOT, Mark. I was COMPLETELY stumped as to how to get around it. Nice one and a lot of people, me included, are very grateful to you.
All the best,
TheNightOwl
TheNightOwl
October 17, 2009 at 5:07 am
I tried this on 2.8.4 site… it allowed me into the admin area, but now all I see is Profile and Tools, I can not access Posts, Pages, Media Library, Plug-ins, etc. I just upgraded to 2.8.5 but still all I see under admin is Profile and Tools. Any ideas out there!????
LindyNorris
October 21, 2009 at 12:22 pm
Tried the steps above and still no go. I also tried copying/pasting the text and saving as .php file (just in case frames were causing an issue) and still no go.
I have looked at my table names (not sure exactly what I’m looking for) and everything seems ok.
I STILL cannot access any plugins after upgraded to 2.8.5.
I’ve looked all over the internet for answers and there’s no real solution. I’ve read hundreds of posts in the worpdress forums and this is the most common solution (using the force-upgrade.php script). Nothing else I’ve tried has worked.
Is there seriously no answer for this?
Scott
October 26, 2009 at 12:23 am
Its working Now Thank you very much.
Jagat
Jagat Shrestha
October 29, 2009 at 2:26 am
I register one user in my root WP DB before run that script. I opend this script then it worked fine, after using that script I added one more user in my WP DB but again I faced “you do not have sufficient permissions to access this page.” error. I dont want to run this script manually after every 5 min. Anyother solution?
KA
November 1, 2009 at 11:35 am
Worked great. Register.com seems to have this problem by default on their software install widget. Glad to have a solution.
Daprez
November 8, 2009 at 6:34 pm
Hello,
I had similar problem and I was getting same message.
“you do not have sufficient permissions to access this page.”
After running the force-upgrade.php script, i could login and see the subscriber level dashboard – I can only see Tools and Profile. It shows me user as “admin”, but nothing other than that.
I can browse the site fine,but not the admin dashboard.
Can somebody help?
Cheers
Harry
November 9, 2009 at 5:50 pm
thanks, it works on 2.5.8
/p/u/g/u/h/
November 9, 2009 at 8:56 pm
Hello,
Ok.I changed all the entries in the database with the correct _*names.
I could now get in as administrator. The only bit (probably the most important) that is missing is “Add New” under PLUGINS section, so I can’t upgrade anything without ftp’g the file manually. I am sure this may affect my future WP upgrades.
Anybody here to help?
Cheers
Haresh
November 10, 2009 at 5:46 pm