search

molgenis / molgenis-emx2

MOLGENIS EMX2, the latest version of the MOLGENIS data platform.
GNU Lesser General Public License v3.0
14 stars 18 forks source link

Inserting records into tables created through the web interface fails #4117

Open hslh opened 3 months ago

hslh commented 3 months ago

What version of EMX2 are you using (see footer) v10.108.3

Describe the bug After creating a new table from the web interface, adding a record to it results in the error message "Update into table 'Name' failed.: Transaction failed: relation "pet store.mg_changelog" does not exist." . Adding a record to an existing table succeeds without an error message, but it isn't recorded in the changelog. Disabling the changelog in settings circumvents the problem.

To Reproduce Steps to reproduce the behavior:

  1. Go to 'https://emx2.dev.molgenis.org/pet%20store/schema/#/'
  2. Create a new table (ontology or data doesn't matter)
  3. Open the table and insert a new record
  4. Click the 'Save'-button
  5. See error message "Update into table 'Name' failed.: Transaction failed: relation "pet store.mg_changelog" does not exist."

Expected behavior When the changelog is enabled, inserting records in newly created tables should succeed. Additionally, insertions (in any table) should be recorded in the changelog.

mswertz commented 3 months ago

can you try to reproduce on a preview server? I suspect be that a migration is missing and that this doesn't happen on clean servers (which would reduce impact but make it harder to solve)

hslh commented 3 months ago

It doesn't happen on a preview server, adding an entry works without error and this is recorded in the changelog.