OS info
- Operating System : Windows 10.0.19043
- Wappler Version : 4.7.2
Problem description
This problem was reported already with bug report 1648450646370, but not solved with the latest 4.7.2. release.
The latest error report: report1648794648445.zip (147.9 KB)
Unfortunately, project development can not continue until the problem is solved so it is a difficult situation to deal with. Apologies for the rant
To explain the situation again:
I have a PostreSql db and table āusersā containing all user detail for the system. As an own practice I donāt do any database schema updates in Wappler but rather on the database level itself through pgAdmin4.
The situation is that, seemingly after 4.7.1, this particular tableās schema, āusersā, cannot be synchronized with the database.
I noticed the problem after starting to have some strange behavior with server actions involving the table since complaining that certain fields are missing. Only then it was discovered that the table schema is out of sync with the database.
From the bug report:
[2022-04-01 08:30:19.270] START refreshSchemaForNode
[2022-04-01 08:30:20.016] got columnInfo error: TypeError: val.lastIndexOf is not a function
at convertPostgresDataType (file:///C:/Users/nantu/AppData/Local/Wappler/resources/app/Shared/DMXzone/dmxAppCreator/UI/Databases/knex_dbTypeMappings.js:98:18)
at file:///C:/Users/nantu/AppData/Local/Wappler/resources/app/Shared/DMXzone/dmxAppCreator/UI/databaseManager.js:8:104152
at $each (file:///C:/Users/nantu/AppData/Local/Wappler/resources/app/Shared/DMXzone/dmxAppCreator/UI/jQuery/js_lib.js:588:10)
at file:///C:/Users/nantu/AppData/Local/Wappler/resources/app/Shared/DMXzone/dmxAppCreator/UI/databaseManager.js:8:103948
at processTicksAndRejections (internal/process/task_queues.js:93:5)
The schema for the users table is shown here:
Steps to reproduce
1.Screencast of problem
2.
3.