Error while performing a schema update. Cannot rename opigno_answer__field_response

Problem/Motivation

After upgrading the opigno_module from version 3.0.4 to 3.12, and running drush updb I encountered an error saying:

‘Exception thrown while performing a schema update. Unable to rename ‘opigno_answer__field_response’ to ‘field_deleted_data_hashnumber’: table ‘field_deleted_data_hashnumber’ already exists.’

The only way I could escape this problem was to delete the table, import the database again, and rerun drush updb.

The hook that is complaining is the one on this line:
https://git.drupalcode.org/project/opigno_module/-/blob/3.1.2/ActivityTy...

Steps to reproduce

• Use Drupal 10.1.x
• Have content courses and interactive content using h5p
• Upgrade Opigno Module from 3.0.4 to 3.1.2
• Run drush updb

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes