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