Error SQLSTATE 42703

BoreGodofBlunder

I am trying to add a preset to a relation (called 'ingredient_type'), one that I have a bunch of presets in already (which I made a few weeks ago). Now when I go to add another, it is giving me an error that the column of the relation itself (ingredient_tpye) doesn't exist on the relation itself (ingredient_type) (sorry if that isn't completely clear, see screenshots below). Anyone have any ideas and thanks in advance for suggestions.

BoreGodofBlunder

I think I figured it out, or at least I have a solution for now.
It was being referenced as an n:1 relation in another relation and that was a mandatory field. By making that non mandatory, I am able to add more to this relation. I am not sure if this is because I have done something else wrong and there is some orphaned data of some sort, but this is a fresh install of the portable REI3 for windows with a clean database, so I am not sure how that could be the case.

gabriel

On first glance I do not see a cause for this error. Even if some other relationship is referencing ingredient_type, this should not stop you from adding new records via presets.

My first guess would be a frontend bug, where you were on a different relation before and some cache got mixed up. When you are on this page and reload your browser page, does the error disappear?

BoreGodofBlunder

I cannot replicate it now unfortunately, even after making that other n:1 relation mandatory again. I don't think I specifically refreshed (although I might have), but I definitely navigated back and forth between various relations and tried a few different combinations.

gabriel

BoreGodofBlunder
Thank you though for trying to replicate it. I have it on my list to update the preset interface soon anyhow - its quite outdated and if there is a possible frontend bug, that´s one more reason 🙂