[Koha-bugs] [Bug 5668] Star ratings in the opac

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Apr 12 20:52:48 CEST 2012


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5668

--- Comment #81 from Marc Véron <veron at veron.ch> ---
I got the following Error in the Web Installer (Step 3)

ERROR 1064 (42000) at line 2821: 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 '- biblionumber int(11) NOT NULL, - rating_value tinyint(1) NOT
NULL, - ' at line 2 

The sql code near the Error is:
--------------------
CREATE TABLE ratings (
    borrowernumber int(11) NOT NULL, --- the borrower this rating is for
    biblionumber int(11) NOT NULL, --- the biblio it's for
    rating_value tinyint(1) NOT NULL, --- the rating, from 1-5
    timestamp timestamp NOT NULL default CURRENT_TIMESTAMP,
    PRIMARY KEY  (borrowernumber,biblionumber),
    CONSTRAINT ratings_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers
(borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT ratings_ibfk_2 FOREIGN KEY (biblionumber) REFERENCES biblio
(biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---------------------

The error is due to the comments (--- instead of --)


Additional issue:

After fixing the error, the scipt complains about an existing table
pending_offline_operations

There should be at line:
DROP TABLE IF EXISTS `pending_offline_operations`;
...at the begin of the section:
-- Table structure for table `pending_offline_operations`

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are watching all bug changes.


More information about the Koha-bugs mailing list