[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