http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5668
Marc Véron <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Severity|enhancement |critical --- Comment #80 from Marc Véron <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
