[Koha-patches] [PATCH] Updated create_koc_db.pl to output SQlite2 files compatible with the Offline Circulation system, rather than the SQlite3 files that required post-processing.

[Kyle M Hall]

From: koha <koha at localhost.(none)>

---
 install_misc/debian-lenny.packages |    2 +-
 install_misc/debian.packages       |    1 +
 misc/cronjobs/create_koc_db.pl     |    2 +-
 3 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/install_misc/debian-lenny.packages b/install_misc/debian-lenny.packages
index c1a5ccc..1424857 100644
--- a/install_misc/debian-lenny.packages
+++ b/install_misc/debian-lenny.packages
@@ -27,7 +27,7 @@ libdatetime-perl	install
 libdatetime-timezone-perl	install
 libdbd-mysql-perl	install
 libdbd-mysql-perl install
-libdbd-sqlite3-perl	install
+libdbd-sqlite2-perl	install
 libdbi-perl	install
 libemail-date-perl	install
 libemail-date-perl	install
diff --git a/install_misc/debian.packages b/install_misc/debian.packages
index 9394849..11dfeb4 100644
--- a/install_misc/debian.packages
+++ b/install_misc/debian.packages
@@ -22,6 +22,7 @@ libdatetime-locale-perl	install
 libdatetime-perl	install
 libdatetime-timezone-perl	install
 libdbd-mysql-perl install
+libdbd-sqlite2-perl install
 libdbi-perl	install
 libemail-date-perl	install
 libgcrypt11-dev install
diff --git a/misc/cronjobs/create_koc_db.pl b/misc/cronjobs/create_koc_db.pl
index 0aed4d0..6a17353 100755
--- a/misc/cronjobs/create_koc_db.pl
+++ b/misc/cronjobs/create_koc_db.pl
@@ -111,7 +111,7 @@ verify_dbd_sqlite();
 
 ## Create DB Connections
 my $dbh_mysql = C4::Context->dbh;
-my $dbh_sqlite = DBI->connect( "dbi:SQLite:dbname=$filename", "", "" );
+my $dbh_sqlite = DBI->connect( "dbi:SQLite2:dbname=$filename", "", "" );
 $dbh_sqlite->{AutoCommit} = 0;
 
 create_borrowers_table();
-- 
1.5.6.5