[Koha] error in the installation of koha-2.2.5

eric salayon esalayon at gmail.com
Fri May 12 19:31:37 NZST 2006


im installing koha 2.2.5 in our fedora core 3 server. until in the creation
of database it incurred the following error :

ERROR 1064 (42000) at line 772: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'return char(4) default NULL,
  renewals tinyint(4) default NULL,
  timestamp tim' at line 9

here's the line it is referring to:

CREATE TABLE issues (
  borrowernumber int(11) NOT NULL default '0',
  itemnumber int(11) NOT NULL default '0',
  date_due date default NULL,
  branchcode char(4) default NULL,
  issuingbranch char(18) default NULL,
  returndate date default NULL,
  lastreneweddate date default NULL,
  return char(4) default NULL,
  renewals tinyint(4) default NULL,
  timestamp timestamp(14) NOT NULL,
  KEY issuesborridx (borrowernumber),
  KEY issuesitemidx (itemnumber),
  KEY bordate (borrowernumber,timestamp)
) TYPE=MyISAM;

my mysql version is 5.0.18-standard.

how can i fix this? tnx in advance....

eric
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20060512/f89f1df9/attachment.html


More information about the Koha mailing list