Based on the errors it looks like it failed to create all of the tables or columns for your setup.
I’d recommend the following approach.
-
Configure the logger to put the mysql add-on into trace debug and to debug to a separate file. See: Taming openHAB 2 Logging
-
Stop openHAB
-
Delete everything in the MySQL database, drop the DB is probably sufficient but it has been a very long time since I’ve messed with MySQL.
-
Start OH again and give it time to restart and do all its DB stuff.
-
Maybe restart it again just for good measure.
-
File an issue in the openhab1-addons repo and post the logs there.