[Case 57282] cpaddon wordpress doesn't work if table prefix chosen

PvUtrix

Well-Known Member
Mar 12, 2005
58
1
156
Ekaterinburg - Russia
cPanel Access Level
Root Administrator
Hello! I've found a bug with cpaddon for wordpress. When I chose a table prefix wplud instead of just wp, I got an error "You do not have sufficient permissions to access this page." after logging in. I've reinstalled with the default prefix and it's working fine
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
41
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
Hello,

We have an internal case (57282) about this issue. I've added this forum thread to that case. Right now, we do not have the issue resolved, but you are welcome to subscribe to an RSS feed of our changelog to check for when that case has been cited:

cPanel & WHM Change Log Feed

Please note that, going forward, if you believe you've found a bug that might not have been reported, the method to report it would be to use our bug reporting system at http://go.cpanel.net/bugs or using the link at the top of the forums.

Thanks!
 

kitchin

Member
Sep 18, 2011
24
0
51
cPanel Access Level
Root Administrator
[Case 57282] [workaround] Wordpress fail with custom table prefix (You do not have sufficient per...

It's been posted many times but the threads are stale, the latest being: [Case 57282] cpaddon wordpress doesn't work if table prefix chosen - Link Removed - Merged threads -

You do not have sufficient permissions to access this page.
Still a bug. Emits this MySQL error, so it's pretty obvious a clue what the bug is (the meta_key name). Say the prefix is 'notwp'
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' COUNT(*) FROM notwp_usermeta WHERE meta_key = 'notwp_capabilities'' at line 1 for query SELECT , COUNT(*) FROM notwp_usermeta WHERE meta_key = 'notwp_capabilities' made by do_action_ref_array, call_user_func_array, wp_version_check, count_users
As a workaround, use something like PHPMyAdmin (click the SQL tab) and run these commands:
Code:
UPDATE `notwp_usermeta`
SET `meta_key`='notwp_capabilities' WHERE `meta_key`='wp_capabilities';

UPDATE `notwp_usermeta`
SET `meta_key`='notwp_user_level' WHERE `meta_key`='wp_user_level';

UPDATE `notwp_options`
SET `option_name`='notwp_user_roles' WHERE `option_name`='wp_user_roles';
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,243
463
Hello :)

Case 57282 is marked a resolved. Could you let us know the specific steps we can take to reproduce the new issue, or are you stating that using a different prefix is all it takes to reproduce the problem?

Thank you.