[Koha] stuck installing insurge (SQL syntax error)

[Alberto Martín Martín]

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