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

jonnyfolk has asked for the wisdom of the Perl Monks concerning the following question:

I was recently forced into a server change and it has broken an old script that's in use. I'm getting the error: "Software error: DBD::mysql::st execute failed: Field 'name' doesn't have a default value at admin.cgi line 192."

  my $var;
  if ($new eq "charter") { $var = "c"; } elsif ($new eq "sales") { $va
+r = "s"; }
  my $sth = $dbh->prepare("INSERT INTO $new (active) VALUES (0)");
 #line 192
 $sth->execute;
[download]

Could any kind Monk please advise on the steps I should take to troubleshoot this

NB. The script is connecting to the DB ok - other aspects like edit are working fine

Comment on Software error: DBD::mysql::st execute failed: Field 'name' doesn't have a default value Download Code

Replies are listed 'Best First'.
Re: Software error: DBD::mysql::st execute failed: Field 'name' doesn't have a default value by hippo (Archbishop) on Oct 28, 2020 at 16:17 UTC
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. 🦛	[reply] [d/l] [select]
Re^2: Software error: DBD::mysql::st execute failed: Field 'name' doesn't have a default value by jonnyfolk (Vicar) on Oct 31, 2020 at 07:51 UTC
Thanks for your advice - much appreciated	[reply]