android.database.sqlite.SQLiteException: near "CREATE_TABLE": syntax error (code 1): , while compiling: CREATE_TABLE MEMES (_id INTEGER PRIMARY KEY AUTOINCREMENT, ASSET TEXT, NAME TEXT)

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via teamtreehouse.com by Unknown author, 1 year ago
near "CREATE_TABLE": syntax error (code 1): , while compiling: CREATE_TABLE MEMES (_id INTEGER PRIMARY KEY AUTOINCREMENT, ASSET TEXT, NAME TEXT)
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 Shubham Nandanwar
, 1 year ago
near "s": syntax error (code 1): , while compiling: INSERT INTO CATEGORIES (_id, SNO, SINDHI, HINDI ,ENGLISH, DRAWABLE, AUDIO, CATEGORY) values(188,9,'सस्','सास','Wife\'s or Husband\'s Mother','R.drawable.blank','R.raw.saas','Relatives');
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 "CREATE_TABLE": syntax error (code 1): , while compiling: CREATE_TABLE MEMES (_id INTEGER PRIMARY KEY AUTOINCREMENT, ASSET TEXT, NAME TEXT)
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1672)
at com.teamtreehouse.mememaker.database.MemeSQLiteHelper.onCreate(MemeSQLiteHelper.java:50)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:252)
at com.teamtreehouse.mememaker.database.MemeDatasource.(MemeDatasource.java:17)
at com.teamtreehouse.mememaker.ui.fragments.MemeItemFragment.onResume(MemeItemFragment.java:89)
at android.app.Fragment.performResume(Fragment.java:1743)
at android.app.FragmentManagerImpl.moveToState(FragmentManager.java:924)
at android.app.FragmentManagerImpl.performPendingDeferredStart(FragmentManager.java:785)
at android.app.FragmentManagerImpl.startPendingDeferredFragments(FragmentManager.java:1086)
at android.app.FragmentManagerImpl.execPendingActions(FragmentManager.java:1464)
at android.support.v4.view.ViewPager.populate(ViewPager.java:1068)
at android.support.v4.view.ViewPager.populate(ViewPager.java:914)
at android.view.View.measure(View.java:16497)
at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5125)
at android.widget.FrameLayout.onMeasure(FrameLayout.java:310)
at android.view.View.measure(View.java:16497)
at android.view.View.measure(View.java:16497)
at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5125)
at android.widget.FrameLayout.onMeasure(FrameLayout.java:310)
at android.view.View.measure(View.java:16497)
at android.view.ViewRootImpl.performMeasure(ViewRootImpl.java:1916)
at android.view.ViewRootImpl.measureHierarchy(ViewRootImpl.java:1113)
at android.view.ViewRootImpl.performTraversals(ViewRootImpl.java:1295)
at android.view.ViewRootImpl.doTraversal(ViewRootImpl.java:1000)
at android.view.ViewRootImpl$TraversalRunnable.run(ViewRootImpl.java:5670)
at android.view.Choreographer$CallbackRecord.run(Choreographer.java:761)
at android.view.Choreographer.doCallbacks(Choreographer.java:574)
at android.view.Choreographer.doFrame(Choreographer.java:544)
at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:747)
at android.os.Handler.handleCallback(Handler.java:733)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:136)
at android.app.ActivityThread.main(ActivityThread.java:5017)
at java.lang.reflect.Method.invokeNative(Native Method)
at java.lang.reflect.Method.invoke(Method.java:515)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:779)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.