| Summary: | Errors in kohastructure.sql | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Julian Maurice <julian.maurice> |
| Component: | Installation and upgrade (web-based installer) | Assignee: | Julian Maurice <julian.maurice> |
| Status: | CLOSED DUPLICATE | QA Contact: | Ian Walls <koha.sekjal> |
| Severity: | major | ||
| Priority: | P1 - high | CC: | gmcharlt |
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
| Attachments: | fix kohastructure.sql | ||
Hi Julian, there is a patch for this waiting for qa :) bug 5668 *** This bug has been marked as a duplicate of bug 5668 *** Created attachment 9172 [details] [review] 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' oh... ok :-) Thanks Katrin. |
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