table users has no column named name (code 1)といったエラーへの対策がわかりません。

public static final int DB_VERSION=1;を2にするなどといった対策をしたのですが、table users has no column named name (code 1)といったエラーへの対策がわかりません。どうかアドバイスをお願い致します。
MainActivity

java
1package com.example.android.sample.myapplication;
2
3import android.database.Cursor;
4import android.database.sqlite.SQLiteDatabase;
5import android.support.v7.app.AppCompatActivity;
6import android.os.Bundle;
7import android.util.Log;
8
9public class MainActivity extends AppCompatActivity {
10
11    @Override
12    protected void onCreate(Bundle savedInstanceState) {
13        super.onCreate(savedInstanceState);
14        setContentView(R.layout.activity_main);
15
16
17        //tableの定義 -contract class
18        //users (name,score)
19
20        //open helper
21
22        //open db
23        UserOpenHelper userOpenHelper=new UserOpenHelper(this);
24        SQLiteDatabase db=userOpenHelper.getWritableDatabase();
25
26
27        //処理 select,insert,update,delete
28        Cursor c=null;
29        c=db.query(
30                UserContract.Users.TABLE_NAME,
31                null,//fields
32                null,//where
33                null,//where arg
34                null,//groupBy
35                null,//having
36                null//order by
37        );
38
39        Log.v("DB_TEST","Count:"+c.getCount());
40        while(c.moveToNext()){
41            int id=c.getInt(c.getColumnIndex(UserContract.Users._ID));
42            String name=c.getString(c.getColumnIndex(UserContract.Users.COL_NAME));
43            int score=c.getInt(c.getColumnIndex(UserContract.Users.COL_SCORE));
44            Log.v("DB_TEST","id"+id+"name:"+name+"score:"+score);
45        }
46
47        c.close();
48        //close db
49        db.close();
50
51    }
52}
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69

UserOpenHelper

java
1package com.example.android.sample.myapplication;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6
7/**
8 * Created by endoutaichi on 2017/04/06.
9 */
10
11public class UserOpenHelper extends SQLiteOpenHelper {
12
13    public static final String DB_NAME="myapp.db";
14    public static final int DB_VERSION=1;
15    public static final String CREATE_TABLE=
16            "create table "  + UserContract.Users.TABLE_NAME + "("+
17                    UserContract.Users._ID + " integer primary key autoincrement,"+
18                    UserContract.Users.COL_NAME + "text,"+
19                    UserContract.Users.COL_SCORE + "integer)";
20
21
22
23            /**"create table"+ UserContract.Users.TABLE_NAME+"("+
24             UserContract.Users._ID+"integer primary key autoincrement,"+
25             UserContract.Users.COL_NAME+"text,"+
26             UserContract.Users.COL_SCORE+"integer)";
27             **/
28    public static final String INIT_TABLE=
29            "insert into users (name,score)values" +
30                    "('taguchi',42),"+
31                    "('fkoji',82),"+
32                    "('dotinstall',62)";
33
34    public static final String DROP_TABLE=
35            "drop table if exists users";
36
37    public UserOpenHelper(Context c){
38        super(c,DB_NAME,null,DB_VERSION);
39    }
40
41
42    @Override
43    public void onCreate(SQLiteDatabase sqLiteDatabase) {
44
45        //create table
46        sqLiteDatabase.execSQL(CREATE_TABLE);
47        //init table
48        sqLiteDatabase.execSQL(INIT_TABLE);
49
50    }
51
52    @Override
53    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
54
55        //drop table
56        sqLiteDatabase.execSQL(DROP_TABLE);
57        //onCreate
58        onCreate(sqLiteDatabase);
59    }
60}
61

java
1java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.android.sample.myapplication/com.example.android.sample.myapplication.MainActivity}: android.database.sqlite.SQLiteException: table users has no column named name (code 1): , while compiling: insert into users (name,score)values('taguchi',42),('fkoji',82),('dotinstall',62)
2                                                                                              at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2070)
3                                                                                              at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2095)
4                                                                                              at android.app.ActivityThread.access$600(ActivityThread.java:137)
5                                                                                              at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1206)
6                                                                                              at android.os.Handler.dispatchMessage(Handler.java:99)
7                                                                                              at android.os.Looper.loop(Looper.java:213)
8                                                                                              at android.app.ActivityThread.main(ActivityThread.java:4786)
9                                                                                              at java.lang.reflect.Method.invokeNative(Native Method)
10                                                                                              at java.lang.reflect.Method.invoke(Method.java:511)
11                                                                                              at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:789)
12                                                                                              at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:556)
13                                                                                              at dalvik.system.NativeStart.main(Native Method)
14                                                                                           Caused by: android.database.sqlite.SQLiteException: table users has no column named name (code 1): , while compiling: insert into users (name,score)values('taguchi',42),('fkoji',82),('dotinstall',62)
15                                                                                              at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
16                                                                                              at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:893)
17                                                                                              at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:504)
18                                                                                              at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
19                                                                                              at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
20                                                                                              at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
21                                                                                              at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1673)
22                                                                                              at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1602)
23                                                                                              at com.example.android.sample.myapplication.UserOpenHelper.onCreate(UserOpenHelper.java:48)
24                                                                                              at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:252)
25                                                                                              at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)
26                                                                                              at com.example.android.sample.myapplication.MainActivity.onCreate(MainActivity.java:24)

行動規範の内容に同意します

回答2件

ベストアンサー

先ほどと同じ個所ですが、

Java
1    public static final String CREATE_TABLE=
2            "create table "  + UserContract.Users.TABLE_NAME + "("+
3                    UserContract.Users._ID + " integer primary key autoincrement,"+
4                    UserContract.Users.COL_NAME + "text,"+
5                    UserContract.Users.COL_SCORE + "integer)";

のtext, とinteger の前にスペースがないため

create table users(_id integer primary key autoincrement,nametext,scoreinteger)

この文でcreate文が発行され、あなたのusersテーブルのカラム名は
_id
nametext
scoreinteger
という謎の名前になっているかと思います。

それを踏まえて、エラー内容は

Caused by: android.database.sqlite.SQLiteException: table users has no column named name (code 1): , while compiling: insert into users (name,score)values('taguchi',42),('fkoji',82),('dotinstall',62)

つまり、「name」なんて名前のカラムはないよ！と怒られているわけです。

一度CREATE_TABLE、INIT_TABLE、DROP_TABLEの中身を出力してSQL構文が合っているか確認された方がいいと思います。

投稿2017/04/06 00:45