Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Stack Overflow by muchie
, 1 year ago
near "TEXT": syntax error (code 1): , while compiling: CREATE TABLE contacts ( Id INTEGER PRIMARY KEY, Name TEXT NOT NULL, PhoneNumber TEXT, Email TEXT
via Stack Overflow by Bryan
, 2 weeks ago
cannot create triggers on virtual tables (code 1): , while compiling: CREATE TEMP TRIGGER IF NOT EXISTS `room_table_modification_trigger_departments_UPDATE` AFTER UPDATE ON `departments` BEGIN INSERT OR REPLACE INTO room_table_modification_log VALUES(null, 0); END
via GitHub by Hyperiunn
, 2 years ago
near "UPDATE": syntax error (code 1): , while compiling: CREATE TABLE actions (id TEXT PRIMARY KEY ON CONFLICT UPDATE,user TEXT NOT NULL,parent TEXT,read TEXT,votedirection INTEGER,saved INTEGER,hidden INTEGER,dirty INTEGER,lastupdate INTEGER)
via Stack Overflow by Mo_Code
, 2 years ago
near "delete": syntax error (code 1): , while compiling: CREATE TABLE data_base_stuff( _id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT,color TEXT,priority TEXT,created_date TEXT,delete INTEGER)
via GitHub by DVassilev
, 2 years ago
table A already exists (code 1): , while compiling: CREATE TABLE A ( ID INTEGER PRIMARY KEY AUTOINCREMENT , C TEXT, D TEXT, E TEXT, F TEXT, G TEXT UNIQUE, H INTEGER NULL, I INTEGER )
via Stack Overflow by Andrey Rankov
, 1 year ago
near "CategoryProduct_MM": syntax error (code 1): , while compiling: DELETE CategoryProduct_MM FROM CategoryProduct_MM INNER JOIN superup.CategoryProduct_MM t2 ON CategoryProduct_MM.PrdID = t2.PrdID AND CategoryProduct_MM.CategoryID=t2.CategoryID
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.(SQLiteProgram.java:59)	at android.database.sqlite.SQLiteStatement.(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)