Opened 14 years ago

Closed 14 years ago

Last modified 14 years ago

#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)

typo_fix.diff (737 bytes) - added by teleyinex 14 years ago.
Patch for fixing the schema.sql file

Download all attachments as: .zip

Change History (5)

Changed 14 years ago by teleyinex

Attachment: typo_fix.diff added

Patch for fixing the schema.sql file

comment:1 Changed 14 years ago by davea

Resolution: fixed
Status: newclosed

comment:2 Changed 14 years ago by teleyinex

Resolution: fixed
Status: closedreopened

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 14 years ago by davea

Resolution: fixed
Status: reopenedclosed

comment:4 Changed 14 years ago by Nicolas

Keywords: patch schema added; server db database typo removed
Note: See TracTickets for help on using tickets.