DB Cleanup

[mrfenyx]

Hi, I am running mealie with the default DB. I am currently working on a tool that will send recipes to mealie through the API. Unfortunately, I somehow managed to have a "ghost" recipe that appears in the UI but if I click it, try to edit it, etc. I get an error:

I did a bit of investigating and it seems that the recipe is still in the database (at least, if I do a backup / export I find it there). I tried taking another folder and copying it, then renaming it to the UUID I found in the DB export but it didn't seem to do anything.
I am also getting these errors:

ERROR: 13-Aug-23 17:49:37 	Unknown Error on recipe controller action
ERROR: 13-Aug-23 17:49:37 	2 validation errors for Recipe
recipeIngredient -> 0 -> referenceId
none is not an allowed value (type=type_error.none.not_allowed)
recipeIngredient -> 1 -> referenceId
none is not an allowed value (type=type_error.none.not_allowed)
Traceback (most recent call last):
File "/app/mealie/routes/recipe/recipe_crud_routes.py", line 286, in get_one
recipe = self.service.get_one_by_slug_or_id(slug)
File "/app/mealie/services/recipe/recipe_service.py", line 121, in get_one_by_slug_or_id
return self._get_recipe(slug_or_id, "slug")
File "/app/mealie/services/recipe/recipe_service.py", line 46, in _get_recipe
recipe = self.repos.recipes.by_group(self.group.id).get_one(data, key)
File "/app/mealie/repos/repository_generic.py", line 163, in get_one
return eff_schema.from_orm(result)
File "/app/mealie/schema/recipe/recipe.py", line 181, in from_orm
recipe = super().from_orm(obj)
File "pydantic/main.py", line 579, in pydantic.main.BaseModel.from_orm
pydantic.error_wrappers.ValidationError: 2 validation errors for Recipe
recipeIngredient -> 0 -> referenceId
none is not an allowed value (type=type_error.none.not_allowed)
recipeIngredient -> 1 -> referenceId
none is not an allowed value (type=type_error.none.not_allowed)

[mrfenyx]

Ok, my solution was to install a tool to edit SQLite DBs (https://sqlitebrowser.org/), download the mealie.db locally, search through all the tables for references to the recipe to be deleted by UUID and delete those rows. Finally, stopped the mealie stack, uploaded the new mealie.db, restarted the stack and all was good.