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! :)