Sometimes field names are not updated following database field name changes - even when they’re re-selected. This has happened to me several times and caused queries to fail.
In this example, I decided to change the field name from exportformat_id to exf_id. I re-saved the connection - and Wappler correctly refleced the changes. I then re-selected the field names. In most cases everything is updated correctly, but as you can see here, the field used in the condition is not the same as the one appearing in the SQL preview - and running the query results in a 500 error due to the non-existent (old) field:
It’s easy to fix - re-re-selecting usually fixes it - but it could cause some confusion. When it happens, I think it’s usually in the WHERE clause.
Last updated: