The 8base team already checked your workspace, and we could see that there is a problem with the Author field in the Posts table. This field is of mandatory type, so in order for what you want, you must delete the Author relationship and create it again but without the mandatory option.
For more explanation please read below:
8base server has relation fields. Relation fields could be implemented by 2 ways: Pivot tables: The relation data is stored in a third table. Foreign key: Mysql solution with foreign key restriction.
We released supporting foreign key relation field implementation. After this release, all fields that you create would be implemented with the classic relation mechanism.
The 8base server has its language to connect/disconnect relations. To connect records the client’s web use this syntax, but after the release, this syntax couldn’t work with foreign key implementation in case of mandatory fields because the server splits create operation on two: insert scalar data + connect, but since scalar data from this moment requires a foreign key field, MySQL throws the error. It could work if you create One - Many relation without a mandatory option
Ok, thanks guys, will check it out. But it’d just be cool if the app itself explained what was wrong, at least if it gave me an error code that I could look up (a minimal solution to human error though).
Please don’t let this continual spin be the behaviour, it’s like asking your gf/bf wtf is wrong now. Speak now, or forever hold your spin.
arghh, so I have to avoid the Syntax Error again? Bad memories of the VIC 20 days when anyone was blamed for walking while the cassette was still loading Blitz! (btw, I never quite completed Blitz!, the fkn spacebar). Syntax Error w/o reason, welcome to my life, s’ok there’s a hotel nearby