Interesting - I have the information_schema db as well, but don't have the INDEX_STATISTICS table so I don't hit this issue.
The search for valid bible databases is able to handle databases without any suitable bible tables (it just checks all tables in each database for a 'verseid' field and then checks for a verse with the bookname 'Bible' so should ignore anything other than lyricue format bibles)
The failure is when lyricue is trying to run "describe INDEX_STATISTICS" so I'm not sure why that would fail
I've made a change to that direct line to avoid this issue for any table which is not behaving :-)
From:
my @fields = @{$db->selectall_arrayref("describe " . $tablename)};
To:
my $tmpfields = $db->selectall_arrayref("describe " . $tablename);
if (!defined $tmpfields) {
next;
}
my @fields = @{$tmpfields};
Interesting - I have the information_schema db as well, but don't have the INDEX_STATISTICS table so I don't hit this issue.
The search for valid bible databases is able to handle databases without any suitable bible tables (it just checks all tables in each database for a 'verseid' field and then checks for a verse with the bookname 'Bible' so should ignore anything other than lyricue format bibles)
The failure is when lyricue is trying to run "describe INDEX_STATISTICS" so I'm not sure why that would fail
I've made a change to that direct line to avoid this issue for any table which is not behaving :-)
From:
my @fields = @{$db-> selectall_ arrayref( "describe " . $tablename)};
To:
my $tmpfields = $db->selectall_ arrayref( "describe " . $tablename);
if (!defined $tmpfields) {
next;
}
my @fields = @{$tmpfields};