MySql Configuration Unable to create New Organisations

I have recently migrated to MySQL for my configuration, everything looks like it went well, apart from I am unable to create new organizations.
any new organizations show with a ID of Zero inside Grafana, and a ID of NULL inside MySQL.
If i manually edit the SQL and Give the Organization a ID then all is good.

looks like we have more problems, unable to create new dashboards, it saves correctly but there not visible, looks like it fails to create.

might to switch back to SQLite

How did you do the migration from Sqlite to MySql?