You are only specifying a value for field active not field name. The latter doesn't have a default value so the database rightly complains. Either specify a value for name in your SQL or alter the table definition in your DB to give name a default value.

Note that this isn't a Perl problem. You would get the same response whatever DB client you used with the same query.