I identified the issue, it all relates back to my issue with MSSQL RowVersion (RV). I deleted the RV column and the error goes away. I add it back and the error shows up.
I’m obviously not implementing the RV properly in Yii, or there’s a bug with Yii’s handling of things.
I just wish there was documentation on RV, concrete examples, but I haven’t found much of any.
I’ll keep digging. Hopefully I’ll eventually find something that works.
I would start by investigating what the RV actually does to cause such error.
Or even better find a way to easily replace RV functionality with ordinary column!
Or if not trivial, replace MSSQL with a better database like Postgresql
The db is set by the client. I have no control on the choice of dbs and can’t switch. (I can modify the tables/structure, but that’s it)
There is no replacing the functionality in this instance as the RowVersion column is required to be able to build Power Automate Flows off of the table. Furthermore, RowVersion columns are commonplace in MSSQL, so it truly is something Yii should handle.
Thank you for all your help. I truly appreciate it.
Oh I’ve searched high and low, come across 4-5 posts/threads, but no solution.
Even rewriting the save method as an INSERT SQL statement generates the error above. No, this truly is a Yii feature support issue I believe. With Azure becoming more and more popular, this should be a priority to resolve IMHO.