Hello everyone, today I was trying to install insurge in order to get SOPAC2 running. I was following these instructions http://manual.koha-community.org/3.2/en/sopacinstall.html but I got stuck in the "Import insurge" step. I got a SQL syntax error:
root@li405-250:/usr/local/lib# mysql -u root -p < /usr/local/lib/insurge/sql/scas_insurge.sql; Enter password: ERROR 1064 (42000) at line 25: 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 '(`hist_id`), KEY `repos_id` (`repos_id`,`group_id`,`uid`,`bnum`,`codate`) ) EN' at line 11 This is the beginning of scas_insurge.sql. I haven't changed anything in it, so I don't know why it is not working... -- phpMyAdmin SQL Dump > -- version 2.11.8.1deb5+lenny3 > -- http://www.phpmyadmin.net > -- > -- Host: localhost > -- Generation Time: Feb 26, 2010 at 05:02 PM > -- Server version: 5.0.51 > -- PHP Version: 5.2.6-1+lenny4 > > SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; > > CREATE DATABASE IF NOT EXISTS `scas`; > USE scas; > > -- > -- Database: `scas` > -- > > -- -------------------------------------------------------- > > -- > -- Table structure for table `insurge_history` > -- > > CREATE TABLE IF NOT EXISTS `insurge_history` ( > `hist_id` int(12) NOT NULL, > `repos_id` char(24) NOT NULL, > `group_id` char(12) NOT NULL, > `uid` int(10) NOT NULL, > `bnum` int(13) NOT NULL, > `codate` datetime NOT NULL, > `title` text, > `author` text, > `added` datetime NOT NULL > PRIMARY KEY (`hist_id`), > KEY `repos_id` (`repos_id`,`group_id`,`uid`,`bnum`,`codate`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Tracks patron check-out > history'; > If you could help me with this I'd be very grateful. Thank you guys! :) _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
