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?
Fix All Fields Not Working (22.11)
Re: Fix All Fields Not Working (22.11)
Same database (eg only localhost) or different DB-server? If different server, don't overwrite setup.md5 on upload.
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: Fix All Fields Not Working (22.11)
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.
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.
BR - Janusz
Re: Fix All Fields Not Working (22.11)
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.
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.
BR - Janusz