[Koha-cvs] CVS: koha/updater updatedatabase,1.4.2.8,1.4.2.9

[Steve Tonnesen]

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

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


Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.4.2.8
retrieving revision 1.4.2.9
diff -C2 -r1.4.2.8 -r1.4.2.9
*** updatedatabase      25 Jun 2002 16:56:29 -0000      1.4.2.8
--- updatedatabase      25 Jun 2002 16:57:39 -0000      1.4.2.9
***************
*** 232,238 ****
      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;
  }
  
--- 232,238 ----
      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;
  }
  
***************
*** 272,275 ****
--- 272,278 ----
  
  # $Log$
+ # Revision 1.4.2.9  2002/06/25 16:57:39  tonnesen
+ # Fixed bug.  $sth->execute after $sti->prepare.
+ #
  # Revision 1.4.2.8  2002/06/25 16:56:29  tonnesen
  # Populate systempreferences table with values for acquisitions and