[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;
  }