no such column 오류 ㅠㅠ 도와주세요 [closed]

Question

11-14 11:38:28.915  30243-30243/com.example.multical E/SQLiteLog﹕ (1) no such column: isu
11-14 11:38:28.915  30243-30243/com.example.multical D/AndroidRuntime﹕ Shutting down VM
11-14 11:38:28.925  30243-30243/com.example.multical E/AndroidRuntime﹕ FATAL EXCEPTION: main
    Process: com.example.multical, PID: 30243
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.multical/com.example.multical.grade}: android.database.sqlite.SQLiteException: no such column: isu (code 1): , while compiling: SELECT _id, subject, semester, credit, grade, isu FROM mygrades ORDER BY _id DESC
            at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2693)
            at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2758)
            at android.app.ActivityThread.access$900(ActivityThread.java:177)
            at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1448)
            at android.os.Handler.dispatchMessage(Handler.java:102)
            at android.os.Looper.loop(Looper.java:145)
            at android.app.ActivityThread.main(ActivityThread.java:5942)
            at java.lang.reflect.Method.invoke(Native Method)
            at java.lang.reflect.Method.invoke(Method.java:372)
            at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1399)
            at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1194)
     Caused by: android.database.sqlite.SQLiteException: no such column: isu (code 1): , while compiling: SELECT _id, subject, semester, credit, grade, isu FROM mygrades ORDER BY _id DESC
            at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
            at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1093)
            at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:670)
            at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
            at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
            at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
            at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
            at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1440)
            at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1287)
            at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1158)
            at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1326)
            at com.example.multical.DBAdapter.getAllInfo(DBAdapter.java:88)
            at com.example.multical.grade.onCreate(grade.java:81)
            at android.app.Activity.performCreate(Activity.java:6288)
            at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1119)
            at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2646)
            at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2758)
            at android.app.ActivityThread.access$900(ActivityThread.java:177)
            at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1448)
            at android.os.Handler.dispatchMessage(Handler.java:102)
            at android.os.Looper.loop(Looper.java:145)
            at android.app.ActivityThread.main(ActivityThread.java:5942)
            at java.lang.reflect.Method.invoke(Native Method)
            at java.lang.reflect.Method.invoke(Method.java:372)
            at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1399)
            at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1194)

 

이게 로그캣이고 살펴보면

 

 Cursor c = db.query(TABLE_NAME, new String[]{ID, SUBJECT, SEMESTER, CREDIT, GRADE,ISU}, null, null, null,null, ID + " DESC");

dbadaptor의 액티비에서 이문장이 실행되면서 오류가 나는거 같은데 어떤건지 도저히 모르겠습니다 ㅠㅠ

 

변수는

    private static final String DB_NAME = "mygrade.db";
    private static final int VERSION = 1;
    public static Cursor cursor;
    private static final String ID = "_id";
    private static final String SUBJECT = "subject";
    private static final String SEMESTER = "semester";
    private static final String GRADE = "grade";
    private static final String ISU = "isu";
    private static final String CREDIT = "credit";
    private static final String TABLE_NAME = "mygrades";
    public static int count;
    private static final String CREATE_TABLE =
        "CREATE TABLE " + TABLE_NAME + " (" +
        ID + " integer primary key autoincrement, " +
                SUBJECT + " text not null, " +
                SEMESTER + " text not null," + CREDIT +" text not null, " + GRADE +" text not null, " + ISU + " text not null );";

이렇게 설정하였습니다