android.database.sqlite.SQLiteException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Caused By : SQL(query) error or missing database
    via Stack Overflow by Omar
    ,
  • Missing database error in android studio?
    via Stack Overflow by Ryder Thacker
    ,
  • Android sqlLite create table
    via Stack Overflow by Victor Kiricheiko
    ,
  • dalvik.system.NativeStart
    via Stack Overflow by Anouar Elmekki
    ,
    • android.database.sqlite.SQLiteException: near "TEXT": syntax error (code 1): , while compiling: CREATE TABLE contacts ( Id INTEGER PRIMARY KEY, Name TEXT NOT NULL, PhoneNumber TEXT, Email TEXT ################################################################# Error Code : 1 (SQLITE_ERROR) Caused By : SQL(query) error or missing database. (near "TEXT": syntax error (code 1): , while compiling: CREATE TABLE contacts ( Id INTEGER PRIMARY KEY, Name TEXT NOT NULL, PhoneNumber TEXT, Email TEXT) ################################################################# at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1058) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:623) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59) at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31) at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1812) at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1743) at com.example.useraccountname.contacts_app.ContactDAO.onCreate(ContactDAO.java:19) at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251) at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163) at com.example.useraccountname.contacts_app.ContactDAO.insert(ContactDAO.java:31) at com.example.useraccountname.contacts_app.add_contacts.onOptionsItemSelected(add_contacts.java:40) at android.app.Activity.onMenuItemSelected(Activity.java:3205) at android.support.v4.app.FragmentActivity.onMenuItemSelected(FragmentActivity.java:403) at android.support.v7.app.AppCompatActivity.onMenuItemSelected(AppCompatActivity.java:189) at android.support.v7.view.WindowCallbackWrapper.onMenuItemSelected(WindowCallbackWrapper.java:100) at android.support.v7.app.AppCompatDelegateImplV7.onMenuItemSelected(AppCompatDelegateImplV7.java:663) at android.support.v7.view.menu.MenuBuilder.dispatchMenuItemSelected(MenuBuilder.java:811) at android.support.v7.view.menu.MenuItemImpl.invoke(MenuItemImpl.java:152) at android.support.v7.view.menu.MenuBuilder.performItemAction(MenuBuilder.java:958) at android.support.v7.view.menu.MenuBuilder.performItemAction(MenuBuilder.java:948) at android.support.v7.widget.ActionMenuView.invokeItem(ActionMenuView.java:618) at android.support.v7.view.menu.ActionMenuItemView.onClick(ActionMenuItemView.java:139) at android.view.View.performClick(View.java:5698) at android.widget.TextView.performClick(TextView.java:10846) at android.view.View$PerformClick.run(View.java:22565) at android.os.Handler.handleCallback(Handler.java:739) at android.os.Handler.dispatchMessage(Handler.java:95) at android.os.Looper.loop(Looper.java:158) at android.app.ActivityThread.main(ActivityThread.java:7230) at java.lang.reflect.Method.invoke(Native Method) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)

    Users with the same issue

    Hiren Amaliyar
    4 times, last one,
    justCodeit
    27 times, last one,
    gamebusterz
    1 times, last one,
    filpgame
    3 times, last one,
    Unknown visitor1 times, last one,
    111 more bugmates