.SQLiteException: near ",": syntax error (code 1): , while compiling:

Question

What am I missing? Something with a "," but I seem to be looking in the wrong place. This is my code:

private static final String DATABASE_CREATE =
        "CREATE TABLE if not exists " + SQLITE_TABLE + " (" +
                KEY_ROWID + " integer PRIMARY KEY autoincrement," +
                KEY_CURSUS + "," +
                KEY_ONDERDEEL + "," +
                KEY_GAME + "," +
                KEY_TIJD + "," +
                KEY_WEB + "," +
                KEY_CHECK + "," +
                " UNIQUE (" + KEY_ROWID +"));";

And this is the error I get:

 Caused by: android.database.sqlite.SQLiteException: near ",": syntax error (code 1): , while compiling: CREATE TABLE if not exists Games_getset (_id integer PRIMARY KEY autoincrement,cursus,onderdeel,game,tijd,web,check, UNIQUE (_id));

Look here: stackoverflow.com/questions/18718178/…

Miguel Maciel
– Miguel Maciel

2014-03-24 15:59:48 +00:00
Commented Mar 24, 2014 at 15:59 — Miguel Maciel
– Miguel Maciel, Commented Mar 24, 2014 at 15:59

laalto · Accepted Answer · 2014-03-24 16:05:48Z

9

Rename or quote the check column since check is a keyword in SQL.

For example:

private static final String DATABASE_CREATE =
    "CREATE TABLE if not exists " + SQLITE_TABLE + " (" +
            KEY_ROWID + " integer PRIMARY KEY autoincrement," +
            KEY_CURSUS + "," +
            KEY_ONDERDEEL + "," +
            KEY_GAME + "," +
            KEY_TIJD + "," +
            KEY_WEB + "," +
            + "`" + KEY_CHECK + "`," +
            " UNIQUE (" + KEY_ROWID +"));";

answered Mar 24, 2014 at 16:05

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user2378812 Over a year ago

Thanks laalto (and CRUSADER)!

anoo_radha Over a year ago

I made the same mistake by naming a column as 'cast'. I realized the mistake after reading your answer. Thanks

Al Lelopath Over a year ago

Same problem for me except my column name was 'group'

CRUSADER · Accepted Answer · 2014-03-24 15:57:53Z

-1

You need to add data type for the columns you are defining for your table. You have added integer dataType for KEY_ROWID but forgot to add dataTypes for the rest..

.........KEY_ROWID + " integer PRIMARY KEY autoincrement," +
                KEY_CURSUS + " text," +
                KEY_ONDERDEEL + " text," + ........
and so on...

answered Mar 24, 2014 at 15:57

CRUSADER

5,4723 gold badges30 silver badges66 bronze badges

1 Comment

laalto Over a year ago

This isn't the issue - it's all right to have columns with just the name specified. The problem is using a reserved word check as a column name which confuses the SQL parser.

Fallen Angel · Accepted Answer · 2014-06-30 04:51:09Z

-1

Try deleting "IF NOT EXIST" in the create table command, SQLite in android version 4.0.4 give me this error, and not in 4.4.2

Luck.

answered Jun 30, 2014 at 4:51

Fallen Angel

1

Collectives™ on Stack Overflow

.SQLiteException: near ",": syntax error (code 1): , while compiling:

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related