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;
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