I installed wpml in a new site I'm running but I couldn't activate the Multilingual CMS plugin and I got that error "CREATE command denied to user" with the following info:
www/wp-content/plugins/sitepress-multilingual-cms/inc/setup/sitepress-schema.php on line 368
Already talked to my hosting provider and there is no problem with my permission to create and modify tables in DDBB. The assistant told me that "Yoast" plugin might be related but I don't have enough knowledge to solve this alone. Already tried to deactivate yoast plugin but it didn't work.
I can't obtain the debug info, I didn't make it that far 🙂
Could you please provide some assistance on this matter?
Languages: English (English )Spanish (Español )Italian (Italiano )
Timezone: Europe/Rome (GMT+02:00)
Hi there,
1) Please ask the user to send you a screenshot of the privileges of the user that is used on that database and send it to us. all the privileges should be enabled for that user (it's a WordPress requirement, not a WPML one).
2) Also ask if by any chance there's a server-side cache enabled on your site and if there is , please flush it
3) Add this code in your active theme's functions.php:
//WPML -> PERMISSION -> RESTORE - RESET
// THIS performs a reset on icl capabilities (run once in functions.php ):
// TO BE USED WHEN SOME WPML MENU IS NOT PRESENT OR AUTHORIZATION IS REQUIRED
// YOU CAN ALSO TRY to manually update "_wpml_inactive" in database to 0.
function wpmlsupp_1706_reset_wpml_capabilities() {
if ( function_exists( 'icl_enable_capabilities' ) ) {
icl_enable_capabilities();
}
}
add_action( 'shutdown', 'wpmlsupp_1706_reset_wpml_capabilities' );
Then refresh your back-end (site.com/wp-admin) and front-end (site.com).
Check if the problem is solved now and let me know how it goes.
Thank you so much Alejandro. Turns out that one of a secondary user I created for my ftp account didn't have all the permissions to write, create, etc.
