All custom queries i make are returning errors including the simplest ones… and the queries doesn’t return results in the console.
What is your database?
How did you create the tables? Have you modified them using the database manager? Have you applied the changes you made there (if any)?
Have you tried refreshing the schema in the database manager?
What if you use the query builder - are there any issues?
i am using postgres sql , i am using database manager , and i am in development mode so no changes to apply, i have refreshed the schema several times… other type of queries works only every custom queries i make doesn’t work , i tried switching to different database in the custom query ,it still doesn’t work. i restarted wappler i still experience same issue
Have you added/removed something to your table in the database manager? Maybe some pending changes are there? Some relations added/removed?
Please check this.
There are no pending changes currently
Have you made and applied any changes related to relations between tables recently?
I created some relations recently… I will try to create a new table to see if i will still experience same issue …but i don’t think that’s supposed to cause an issue
There are probably some issues with these relations you created or they have not been applied properly, that’s what the error says.
The users table for instance doesn’t have any relation, it’s a standalone table… I still get the error on it too
The custom query works with the new table i just created, how can i make it work with other tables?
Maybe you are on the wrong project target that doesn’t have all your database changes.
Make sure you have the right target active.
I am in the development target… I don’t have other targets
Is it meant to be capital U for users?
it’s capital U for Users
Just checking
are experiencing same issue