/
Missing SQL Tables from CORD19

Missing SQL Tables from CORD19

Problem

The following tables were missing in SQL,

exportimpl
importtaskimpl
passwordresettoken
simpleuser

Few pages such as 'Tasks' crashed on the local server.

 

Solution

To solve this issue,

  1. Go to src->main->java->edu->asu->diging->cord19->explorer->config->PersistenceConfig.java

  2. In the properties function (Properties additionalProperties() {}) , change ‘MySQL5Dialect’ to 'MySQL55Dialect'.

  3. This should generate any missing tables.

Related articles

Related content

Converting MySQL to UTF8mb4 encoding to handle special characters (Example: Č, ā)
Converting MySQL to UTF8mb4 encoding to handle special characters (Example: Č, ā)
More like this
Bulk Importing References
Bulk Importing References
More like this
Database setup
More like this
Setting up your Quadriga development environment (Java)
Setting up your Quadriga development environment (Java)
More like this