A great example of getting distracted by the technology and forgetting about the basics (i think the English expression is not seeing the wood for the trees).
A few weeks ago i decided MySQL on the office server needed an upgrade. as it was still on 5.1 or 5.3 (cant remember now) and MySQL Workbench would not connect (“Bad Handshake” error)
As most of my online servers use MariaDB i decided to go that way on the office Windows server setup
I completely forgot that MariaDB defaults to strict mode which meant that empty values were rejected rather than replaced with defaults.
Thanks and apologies to patrick, Teodor and George who had to sort this out for me, i should have come up with the solution myself but being at RC 3 led me to believe the problem was Wappler and I stopped thinking outside the box.
Let’s hope my issue will help someone else who has this problem in the future.
Great support as always from the Wappler team!