Scheme error?

Configuration
1

Hello everybody. Home assistant shows me an error and although I understand it, I don’t know why it occurs?
I imagine that the insert occurs automatically. If so, then is that field left over?
Thanks

sqlalchemy.exc.IntegrityError: (MySQLdb._exceptions.IntegrityError) (1364, "Field 'state_id' doesn't have a default value")
[SQL: INSERT INTO states (domain, entity_id, state, attributes, event_id, last_changed, last_updated, created, old_state_id) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: ('script', 'script.homeassistant_update', 'on', '{"last_triggered": "2021-06-16T00:55:37.552615+00:00", "mode": "single", "current": 1, "friendly_name": "homeassistant_update"}', 512625, datetime.datetime(2021, 6, 16, 0, 55, 37, 552870, tzinfo=datetime.timezone.utc), datetime.datetime(2021, 6, 16, 0, 55, 37, 552870, tzinfo=datetime.timezone.utc), datetime.datetime(2021, 6, 16, 0, 55, 37, 552870, tzinfo=datetime.timezone.utc), None)]
(Background on this error at: http://sqlalche.me/e/14/gkpj)
2

You should check the last ‘state_id’ value in table states and set-up autoincrement to its value+1

SELECT MAX(state_id) AS Count FROM states;
ALTER TABLE states MODIFY COLUMN state_id INT NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=your value + 1;

in case you will get message about foreign key, try put auto increment between next (helped to me):


SET FOREIGN_KEY_CHECKS = 0;

/* DO WHAT YOU NEED HERE */

SET FOREIGN_KEY_CHECKS = 1;