TandoorRecipes / recipes

Application for managing recipes, planning meals, building shopping lists and much much more!
https://docs.tandoor.dev
Other
5.44k stars 576 forks source link

Errors during Plan to Eat import #3297

Open DenWav opened 1 month ago

DenWav commented 1 month ago

Tandoor Version

1.5.19

Setup

Unraid

Reverse Proxy

Others (please state below)

Other

Local nginx

Bug description

During import I get a variety of errors:

value too long for type character varying(512)
Error parsing string , <text>, food cannot be empty

Examples:
Error parsing string , Dry Ingredients, food cannot be empty
Error parsing string , Lime wedge, food cannot be empty
Error parsing string , Cake, food cannot be empty
etc

Not an error, but I also notice Tandoor does not decode HTML escape codes, for example many recipe titles contain the character sequence &#39; (') as well as others like &amp;, etc.

Here is the import file: plantoeat-recipes-411575_09-08-2024.txt

Relevant logs

No response

lyndametref commented 1 day ago

Plant to eat generate a line without amount when you have "headings" in ingredients list. I workaround this by adding an amount to all of those heading lines (replace regex ^, with 1, ). By doing that the import process have created food with the plant to eat heading text which I need to clean up.