#984 closed Defect (fixed)
Typo in schema.sql in last revision
Reported by: | teleyinex | Owned by: | davea |
---|---|---|---|
Priority: | Blocker | Milestone: | Undetermined |
Component: | Server - Setup | Version: | 6.10.17 |
Keywords: | patch, schema | Cc: | davea |
Description
In the last revision, everything compiles well but when you try to create a project you obtain an error from MySQL saying that you have a syntax error. The problem is two typos in the last table. Adjoining is the patch to fix that problem (I have tested myself, anyway please check it before applying).
Attachments (1)
Change History (5)
Changed 15 years ago by
Attachment: | typo_fix.diff added |
---|
comment:1 Changed 15 years ago by
Resolution: | → fixed |
---|---|
Status: | new → closed |
comment:2 Changed 15 years ago by
Resolution: | fixed |
---|---|
Status: | closed → reopened |
I have checked again the schema.sql and there is already a typo in the schema.sql file. Please, check the patch I submit before. The error is in the table:
CREATE TABLE host_app_version( host_id integer NOT NULL , app_version_id integer NOT NULL , pfc_n double NOT NULL , pfc_avg double NOT NULL , et_n double NOT NULL , et_avg double NOT NULL , et_var double NOT NULL , et_q double NOT NULL , host_scale_time double NOT NULL , scale_probation tinyint NOT NULL , error_rate double NOT NULL , max_results_day integer NOT NULL , app_id integer NOT NULL , ) ENGINE = Inn
in the app_id register. The colon after NOT NULL should be removed.
comment:3 Changed 15 years ago by
Resolution: | → fixed |
---|---|
Status: | reopened → closed |
comment:4 Changed 14 years ago by
Keywords: | patch schema added; server db database typo removed |
---|
Patch for fixing the schema.sql file