My app has delayed sync turned on.
The scenario is:
We get an error now showing a mysql error โA column in your mysql table cannot be null. Please make sure that you provide a value for this columnโ
I think the delayed sync may be updating the records out of sequence as this was working previously. Now I can only get this to work if I manually sync after step 2 and then run the combined action.
The issue is pretty clear:
A database table row being added or updated by your process has a filed that may not be NULL, but your process is attempting to set the corresponding column value to a blank value, or is leaving it blank (perhaps upon creation).
Delayed sync is not likely the issue.
Please review your appโs table configurations. For any database table column configured with NOT NULL
, the corresponding app table column must have Required? set to ON; you must not use an expression for Required? on the column.
Thanks for the reply.
The only fields i have as Not Null are the Primary Key for the table. I have a separate column for the appsheet key. The primary key column has Auto increment on so I thought this would have been ok.
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |