Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB Migration / Fix things #1106

Open
pjaudiomv opened this issue Oct 28, 2024 · 2 comments
Open

DB Migration / Fix things #1106

pjaudiomv opened this issue Oct 28, 2024 · 2 comments

Comments

@pjaudiomv
Copy link
Collaborator

This is here to track various data integrity items either due to old servers data or just in general

@pjaudiomv
Copy link
Collaborator Author

  1. empty fields vs NULL. 2.x Servers would have empty strings in _comdef_meetings_main and in 3.x these fields are NULL.
  2. a _comdef_meetings_data field for instance location_neighborhood could me an empty string. in 3.x this row would be removed and not exist.

A side effect of this is they show up as meeting changes. IE. email was changed from "" to "".

@alanb2718
Copy link
Collaborator

Some others:

  • meetings that refer to a format that no longer exists
  • meetings owned by a service body that was deleted
  • service bodies with editors that no longer exist
  • (maybe - since this is not currently checked for) different formats with the same key in the same language, e.g. two formats with key B in English

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants