Project

General

Profile

Actions
Copy link

Bug #7752

closed

adding field to createSQLTable try to add instead of change default when it is not the same as the original

Added by Anchi Cheng almost 5 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
High
Assignee:
Anchi Cheng
Category:
-
Target version:
Appion/Leginon 3.5
Start date:
07/08/2019
Due date:
% Done:

0%

Estimated time:
Affected Version:
Appion/Leginon 3.4
Show in known bugs:
No
Workaround:

Description

The initialization of database by myamiweb/xml/leginonDBschema.xml may have different default from sinedon definition. For example, boolean datatype may default to 0 or Null. It is better to keep xml value in case it is needed for a reason.

The bug tries to add the column and this is not allowed by pymysql.

Actions
Copy link
 #1

Updated by Anchi Cheng almost 5 years ago

Remove alter table CHANGE so that default or enumerater changes are not affected since the part may still be triggered when new field is added through sinedon.

Actions
Copy link
 #2

Updated by Anchi Cheng over 4 years ago

  • Status changed from Assigned to Closed

works.

Actions
Copy link

Also available in: Atom PDF