[Resolved] Database error when updating Toolset

[Author]

Posts

[CraigS3893]

Getting this error at top of WP admin:

Error: ALTER command denied to user 'web45b_fortyfivebee'@'10.3.2.28' for table '45bwp_toolset_post_guid_id'

Was told this was a hosting permissions issue by Toolset support earlier today but hosting checks out and all permissions are granted.

[Shane]

Hi Craig,

You can post your responses here.

[CraigS3893]

If it helps, I went live with a new design today, with a new DB.

I dropped all the existing tables in the live DB and imported the new one from local, then uploaded the site files, then upgraded the plugins. This is when the error appeared.

[CraigS3893]

Just added another plugin for 301 redirects and it seems this can't create the DB tables either.

[CraigS3893]

And another 301 plugin failing with error starting:

Message: Failed to perform query "CREATE TABLE IF NOT EXISTS

Looks like this is a DB / permissions error at the hosting end. I've gone back to them about it. Will post here with their response.

[Shane]

Hi Craig,

Its definitely the server side issue. Have a look at my screenshot.

As you can see the database update ran perfectly without any issues when I created a copy on my localhost of your site.

If you want me to provide you with this backup please let me know.

Thanks,
Shane

[CraigS3893]

Hi Shane
Thanks. I just tried updating my localhost version and the other plugins updated without any issues but when I try to update Types (which I've registered with the localhost address) I get this error:

Download failed. cURL error 35: error:1407742E:SSL routines:SSL23_GET_SERVER_HELLO:tlsv1 alert protocol version

Is this related in any way?

[CraigS3893]

Turned out it was a permissions issue on the host Db - all working now, thanks for your help.

[Shane]

Hi Craig,

Awesome, happy the issue is now resolved.

You can go ahead and mark this ticket as resolved when you're ready.

Thanks,
Shane

[CraigS3893]

Thanks for helping. The further error at the end was down to my MAMP needing an upgrade.