Re: Software error: DBD::mysql::st execute failed: Field 'name' doesn't have a default value

[hippo]

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.

[jonnyfolk]

Thanks for your advice - much appreciated