Skip to main content

WordPress Not sufficient permissions to access admin page

While installing WordPress for my blog, I was trying out different subdomain/ folder options.

After final installation when I tried to access the admin page I was being redirected to /wp-admin/profile.php but getting insufficient permission error like shown below.

not sufficient permission

I could access the front page easily but couldn’t log in admin panel.

I tried changing the permission of WordPress files  and directories to 755 but to no avail.

The problem was that while installing WordPress I used different table prefixes each time.

table_prefix

WordPress uses the table prefix for forming the option and usermeta keys name for storing roles and capabilities information.

So in the process, database tables had correct table prefixes but some records in the some  of the tables still had old table prefix and this was causing the problem.

To fix the issue you need to update your database using phpMyAdmin or php.

Check in your database in the usermeta and options table if they have correct table prefix in all the fields.

UPDATE `wp_usermeta` SET `meta_key` = replace(`meta_key`, 'old_prefix', 'current_prefix');
UPDATE `wp_options` SET `option_name` = replace(`option_name`, 'old_prefix', 'current_prefix');

Make sure to change old_prefix and new_prefix accordingly.

You can find the current prefix from wp-config.php.


If it’s still not working check all the rows manually and also all the other tables.


This solved the problem for me.

Comments

Post a Comment

Popular posts from this blog

jQuery support in Aptana Studio 3

I use Aptana Studio primarily for web development. It has great support for languages like PHP and JavaScript. But the problem is that I mostly use jQuery rather than code in JavaScript and Aptana does not have good support / content assist from beginning. So we need to install ruble for jQuery library. Ruble is short for Ruby bundle and is a runtime environment that allows the extensibility of Aptana Studio's editors by using Ruby. To install the jQuery bundle follow the following steps: Navigate to Commands | Bundle Developement | Install Bundle. Select jQuery and click OK. Aptana will clone jQuery ruble from github. Include appropriate jQuery sdocml in Project Build Path from Project Properties. Include a VSDoc file for jQuery in your project. [caption id="attachment_47" align="aligncenter" width="1313"] Aptana fetching jquery ruble from GitHub[/caption] You must include appropriate version VSDoc for correct Content Assist. [caption id="attac...
Post a Comment
Read more

How to split large mp3 files using mp3splt

If you have a  lengthy  or large MP3 file and you want to  split  it into files of smaller size or duration, You can easily do this using mp3splt. Mp3splt   is an utility to split mp3 and ogg vorbis digital audio files without the need of decoding. It can be used to split a file into no of tracks of fixed duration and size or specified  split points. It supports variable bit rate mp3 files, silent detection, splitting with local .XMCD, .CDDB or .CUE file splitpoints or from external servers like   tracktype.org . It copies the original files first and then generates new, smaller files during the process of splitting without altering the original file. It does not do any encoding or decoding so the splitting is very fast and lossless. Steps to follow Navigate to directory where you have downloaded mp3splt { if using portable version } . Run and execute mp3slpt using the command   mp3splt  . Specify the options according to which you wanna split. The basic syntax is   mp3splt [file path]...
Post a Comment
Read more