search

colaorange / daily-money-one-doc

daily money one, issues
0 stars 0 forks source link

Error: instance.note does not meet maximum length of 512 #54

Closed dennischen closed 1 month ago

dennischen commented 1 month ago

您好，匯入時發生錯誤，請問如何處理，謝謝 資料格式錯誤: instance.note does not meet maximum length of 512

dennischen commented 1 month ago

should check evey entity(book, account, transaction) that has note field

dennischen commented 1 month ago

Information: DM+ didn't limit the length on name and note in schema and ui editor

    private static final String BOOK_CREATE_SQL = "CREATE TABLE " + TB_BOOK + " ("
            + COL_BOOK_ID + " TEXT PRIMARY KEY, "
            + COL_BOOK_NAME + " TEXT NOT NULL, "
            + COL_BOOK_SYMBOL + " TEXT NULL, "
            + COL_BOOK_SYMBOL_POSITION + " INTEGER NOT NULL, "
            + COL_BOOK_PRIORITY + " INTEGER NULL, "
            + COL_BOOK_NOTE + " TEXT)";

    private static final String ACC_CREATE_SQL = "CREATE TABLE " + TB_ACC + " ("
            + COL_ACC_ID + " TEXT PRIMARY KEY, "
            + COL_ACC_NAME + " TEXT NOT NULL, "
            + COL_ACC_TYPE + " TEXT NOT NULL, "
            + COL_ACC_CASHACCOUNT + " INTEGER NULL, "
            + COL_ACC_PRIORITY + " INTEGER NULL, "
            + COL_ACC_INITVAL + " REAL NOT NULL)";

    private static final String ACC_CREATE_SQL = "CREATE TABLE " + TB_ACC + " ("
            + COL_ACC_ID + " TEXT PRIMARY KEY, "
            + COL_ACC_NAME + " TEXT NOT NULL, "
            + COL_ACC_TYPE + " TEXT NOT NULL, "
            + COL_ACC_CASHACCOUNT + " INTEGER NULL, "
            + COL_ACC_PRIORITY + " INTEGER NULL, "
            + COL_ACC_INITVAL + " REAL NOT NULL)";
dennischen commented 1 month ago

Increase the note size to 1024 and trim the note length to a maximum of 1024.