[Bug 7954] New: Errors in kohastructure.sql
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7954 Priority: P1 - high Change sponsored?: --- Bug ID: 7954 CC: gmcharlt@gmail.com Assignee: julian.maurice@biblibre.com Summary: Errors in kohastructure.sql QA Contact: koha.sekjal@gmail.com Severity: major Classification: Unclassified OS: All Reporter: julian.maurice@biblibre.com Hardware: All Status: ASSIGNED Version: master Component: Installation and upgrade (web-based installer) Product: Koha I just made a fresh master installation, and encountering the following error: 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, - ' It seems that in '---', only the two last dashes are considered by MySQL as the start of a comment. $mysql -V mysql Ver 14.14 Distrib 5.1.61, for debian-linux-gnu (x86_64) using readline 6.2 -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7954 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED CC| |katrin.fischer@bsz-bw.de Resolution|--- |DUPLICATE --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi Julian, there is a patch for this waiting for qa :) bug 5668 *** This bug has been marked as a duplicate of bug 5668 *** -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7954 --- Comment #2 from Julian Maurice <julian.maurice@biblibre.com> --- Created attachment 9172 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=9172&action=edit fix kohastructure.sql Replace '---' by '--' as MySQL seems to consider only the two last dashes as the start of a comment. Also add a missing 'DROP TABLE IF EXISTS' before 'CREATE TABLE' -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7954 --- Comment #3 from Julian Maurice <julian.maurice@biblibre.com> --- oh... ok :-) Thanks Katrin. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org