Page 1 of 1

Fix All Fields Not Working (22.11)

Posted: 2022-01-28 09:40
by jbielak
Hi,
AppGini 22.11

At the moment I am struggling with the following:
I have added one field to a table. Utilities -> Fix All Fields can see the field is missing and trying to create it. No outcome, field not created.

Why does it happen, any idea?
What's the solution to have it working?

Re: Fix All Fields Not Working (22.11)

Posted: 2022-01-28 11:07
by jsetzer
Same database (eg only localhost) or different DB-server? If different server, don't overwrite setup.md5 on upload.

Re: Fix All Fields Not Working (22.11)

Posted: 2022-01-28 16:12
by jbielak
Same server (localhost).

Interesting observation - I have checked in the other project/database and it works.
There is something special about the one, in which the fixing tool cannot make it.

Re: Fix All Fields Not Working (22.11)

Posted: 2022-01-28 16:59
by jbielak
Problem solved.

Admin area -> Utilities -> Query logs -> Error queries

Found that due to some mysterious reason a few data fields in the affected table were written with date "0000-00-00" instead of NULL. In TV/DV the field was displayed as empty.

Cannot reproduce the situation in which such a value could be written to the db.