Right now I’m using MySQL as one of the main data sources for my glide app. I want to delete some columns that are not useful to me anymore. However, when I delete them I get errors in Glide saying that the data cannot be loaded because X column cannot be found.
Note that I’m not using custom queries to load this data, so I wasn’t expecting this problem since I thought Glide would basically perform “SELECT * FROM TABLE” statements. But apparently it doesn’t. In order for my app to work again, I had to add the columns back, or create new columns with those exact same names.
In the docs, it says there should be a “Sync Table Schema” button at the top right corner, however, I can’t find it anywhere.
What can I do?
Is your sync “read & write” or “read only”? I wonder if it makes a difference.
Otherwise @DarrenHumphries might be able to comment more here.
2 Likes
To reload your table you’ll see that there is a reload symbol just to the right of the table name at the top middle. Try that and see.
@DarrenHumphries I had tried that before, but it gives me the same error:
It looks like it refreshes records, but not the schema? It works if I add a column with the exact name back:
Should be read & write, since I’m pulling the entire table, instead of doing a custom query and am able to add new rows from in-app forms.
1 Like
This looks like something you should let support know about.
I’m using Postgres and when I add a column in SQL and hit the reload the column shows up. If I then delete the column in SQL and hit reload it just disappears. Could be there is a problem with this if you are using MySQL. Worth reporting.
2 Likes
