[Koha-cvs] CVS: koha/updater updatedatabase,1.10,1.11

[Steve Tonnesen]

Update of /cvsroot/koha/koha/updater
In directory usw-pr-cvs1:/tmp/cvs-serv5864

Modified Files:
	updatedatabase 
Log Message:
Fixed bug.  $sth->execute after $sti->prepare.


Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -r1.10 -r1.11
*** updatedatabase	14 Jun 2002 05:24:58 -0000	1.10
--- updatedatabase	25 Jun 2002 16:59:27 -0000	1.11
***************
*** 202,208 ****
      print "Setting type of categorycode in branchcategories to varchar(4),\n and making the primary key.\n";
      my $sti=$dbh->prepare("alter table branchcategories change categorycode categorycode varchar(4) not null");
!     $sth->execute;
!     $sth=$dbh->prepare("alter table branchcategories add primary key (categorycode)");
!     $sth->execute;
  }
  
--- 202,208 ----
      print "Setting type of categorycode in branchcategories to varchar(4),\n and making the primary key.\n";
      my $sti=$dbh->prepare("alter table branchcategories change categorycode categorycode varchar(4) not null");
!     $sti->execute;
!     $sti=$dbh->prepare("alter table branchcategories add primary key (categorycode)");
!     $sti->execute;
  }