Re: Upgraded from 3.3 to 4.0 - sql issues
Don't worry. They are harmless. Should be fixed for 4.1 But this doesn't indicate there is something wrong with your installation.
2 are "duplicate entry": saying that that part of the upgrade was already done.
column 'guards' can't have a default value: this is solved by a later operation in the upgrade script.