android.database.sqlite.SQLiteException

near "TABLEusers": syntax error: , while compiling: CREATE TABLEusers(idINTEGER PRIMARY KEY,usernameTEXT,passwordTEXT,nameTEXT,emailTEXT)

Solutions on the web1696

  • near "TABLEusers": syntax error: , while compiling: CREATE TABLEusers(idINTEGER PRIMARY KEY,usernameTEXT,passwordTEXT,nameTEXT,emailTEXT)
  • near "TABLEusers": syntax error (code 1): , while compiling: CREATE TABLEusers(idnumber INTEGER PRIMARY KEY, nameTEXT, email TEXT, password TEXT )
  • near “TABLEtbluser2”: syntax error: , while compiling: CREATE TABLEtbluser2(idINTEGER PRIMARY KEY AUTOINCREMENT,nameTEXT,userTEXT,passTEXT);
  • Stack trace

    • android.database.sqlite.SQLiteException: near "TABLEusers": syntax error: , while compiling: CREATE TABLEusers(idINTEGER PRIMARY KEY,usernameTEXT,passwordTEXT,nameTEXT,emailTEXT) at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method) at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68) at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:134) at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361) at android.database.sqlite.SQLiteStatement.acquireAndLock(SQLiteStatement.java:260) at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:84) at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1899) at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1839) at edu.flying.panda.taskmanager.DatabaseHandler.onCreate(DatabaseHandler.java:37) at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:165) at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:231) at edu.flying.panda.taskmanager.DatabaseHandler.getUser(DatabaseHandler.java:78) at edu.flying.panda.taskmanager.LogIn$1.onClick(LogIn.java:55) at android.view.View.performClick(View.java:3511) at android.view.View$PerformClick.run(View.java:14105) at android.os.Handler.handleCallback(Handler.java:605) at android.os.Handler.dispatchMessage(Handler.java:92) at android.os.Looper.loop(Looper.java:137) at android.app.ActivityThread.main(ActivityThread.java:4424) at java.lang.reflect.Method.invokeNative(Native Method) at java.lang.reflect.Method.invoke(Method.java:511) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551) at dalvik.system.NativeStart.main(Native Method)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    14 times, 3 weeks ago
    27 times, 4 months ago
    Once, 4 months ago
    3 times, 6 months ago
    Unknown user
    Once, 10 months ago
    28 more bugmates