Ok - I have the following member function. sub GetCategories { my $sth = $dbh->prepare("SELECT CatID, CatName, CatLink FROM Categories"); $sth->execute() or die $DBI::errstr; my $results = $sth->fetchall_arrayref({}); return($results); ` $sth->finish(); } I call it with: my $Cats = $d2s->GetCategories();…
As I have seen here, Beginning with MySQL 8.0.34, the automatic reconnection feature is deprecated. I have a lot of Perl scripts that connect to a MySQL database with something like: my $dbh = DBI->connect( "DBI:mysql:database=$db_name;host=$db_host", $db_user, $db_pass, {'RaiseError' =>…
I am try to install DBD-SQLite V1.70 module of perl in centos7. I have tried cpanm DBD::SQLite or download from the https://metacpan.org/dist/DBD-SQLite. every time will be install error in "DBI 1.57 is required to configure this module; please install it…