#populate part_pkg_taxclass for starters
'part_pkg_taxclass' => [],
+ #remove bad pending records
+ 'cust_pay_pending' => [],
+
;
\%hash;
my @part_export = FS::part_export::sqlradius->all_sqlradius_withaccounting();
foreach my $part_export ( @part_export ) {
- my $dbh = DBI->connect( map $part_export->option($_),
- qw ( datasrc username password ) );
+ my $dbh = DBI->connect(
+ ( map $part_export->option($_), qw ( datasrc username password ) ),
+ { PrintError => 0, PrintWarn => 0 }
+ );
my $str2time = str2time_sql( $dbh->{Driver}->{Name} );
my $group = "UserName";
$sth_update->execute or die $sth_update->errstr;
}
+ my $sth_index = $dbh->prepare(
+ "CREATE INDEX FreesideStatus ON radacct ( FreesideStatus )"
+ );
+ if ( $sth_index ) {
+ $sth_index->execute;
+ }
+
my $sth = $dbh->prepare("SELECT UserName,
Realm,
$str2time max(AcctStartTime)),