my $sth2 = $dbh->prepare("SELECT * FROM subscription_numberpatterns WHERE id = ?");
- my $sth3 = $dbh->prepare("UPDATE serials SET serialseq_x = ?, serialseq_y = ?, serialseq_z = ? WHERE serialid = ?");
+ my $sth3 = $dbh->prepare("UPDATE serial SET serialseq_x = ?, serialseq_y = ?, serialseq_z = ? WHERE serialid = ?");
foreach my $subscription ( $sth->fetchrow_hashref() ) {
next if !defined($subscription);
- my $number_pattern = $subscription->numberpattern();
$sth2->execute( $subscription->{numberpattern} );
- $number_pattern = $sth2->fetchrow_hashref();
+ my $number_pattern = $sth2->fetchrow_hashref();
my $numbering_method = $number_pattern->{numberingmethod};
# Get all the data between the enumeration values, we need