Can you please remove my site URL from this ticket? It would have been good to know that all requests are posted publicly as soon as they're submitted.
I am trying to update the database on one of our sites and it always fails at the same point:
> Precondition "able to create a new database table"... ERR
From the error logs:
WordPress database error CREATE command denied to user '[user]'@'localhost' for table 'wp_toolset_migration_precondition_test_table' for query CREATE TABLE wp_toolset_migration_precondition_test_table ( id bigint(20) unsigned not null auto_increment, PRIMARY KEY (id)) made by do_action('wp_ajax_types_relationships_database_upgrade'), WP_Hook->do_action, WP_Hook->apply_filters, Toolset_Ajax->__call, OTGS\Toolset\Types\Ajax\Handler\RelationshipsDatabaseUpgrade->process_call, OTGS\Toolset\Common\Relationships\DatabaseLayer\Version2\Migration\MigrationController->do_next_step, OTGS\Toolset\Common\Relationships\DatabaseLayer\Version2\Migration\Step01PreMigrationCheck->run, OTGS\Toolset\Common\Relationships\DatabaseLayer\Version2\Migration\Step01PreMigrationCheck->check_precondition, OTGS\Toolset\Common\Relationships\DatabaseLayer\Version2\Migration\Step01PreMigrationCheck->OTGS\Toolset\Common\Relationships\DatabaseLayer\Version2\Migration\{closure}
WordPress database error DROP command denied to user '[user]'@'localhost' for table 'wp_toolset_post_guid_id' for query TRUNCATE TABLE wp_toolset_post_guid_id made by do_action('wp_ajax_toolset_clear_post_guid_id_cache'), WP_Hook->do_action, WP_Hook->apply_filters, Toolset_Ajax->__call, Toolset_Ajax_Handler_Clear_Post_Guid_Id_Cache->process_call, OTGS\Toolset\Common\Utils\TypesGuidIdGateway->truncate, WPCF_Guid_Id->truncate
Hello,
I don't see your website URLs in this ticket.
And according to the debug logs you provided above, there is a MYSQL user permission in your website, you can follow MYSQL document to grant all Privileges to specific database for your MYSQL user:
hidden link
section "Database Privileges"
hidden link
That worked, thank you! Our web hosting was migrated by our provider recently, so they must have removed some permissions.
The support form asks for a URL then displays it on the public topic that is created on the forums. But it looks like you have found it.
