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
"eric salayon" <esalayon@gmail.com>
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 [...] how can i fix this? tnx in advance....
Try to put backquotes (`timestamp`) or double quotes ("timestamp") around any field names that are reserved words. I think which one works changes with versions and settings. Please do not sent html email to the list. Hope that helps, -- MJ Ray - personal email, see http://mjr.towers.org.uk/email.html Work: http://www.ttllp.co.uk/ irc.oftc.net/slef Jabber/SIP ask
participants (2)
-
eric salayon -
MJ Ray