getting sqlite exception when insert ? how to?

Question

i created the database like this

db.execSQL("CREATE TABLE "+TABLE_NAME+" (" 
    +_ID+" INTEGER PRIMARY KEY AUTOINCREMENT," 
    + TITLE+" TEXT UNIQUE," 
    + PUBLISHED+" DATETIME," 
    + CONTENT+" TEXT," 
    + RATERS+" TEXT,"
    + VIEWCOUNT+" TEXT,"
    + THUMBNAIL+" TEXT,"
    + FAVCOUNT+" TEXT,"
    + FAVSTAT+" INTEGER,"
    + LINKWEB+" TEXT);");

i got an exception when i try to insert the values in the table??

02-24 15:57:37.802: ERROR/DatabaseUtils(283): Writing exception to parcel
02-24 15:57:37.802: ERROR/DatabaseUtils(283): android.database.sqlite.SQLiteException: table bru_tube has no column named linkweb: , while compiling: INSERT INTO bru_tube(content, favstat, title, thumbnail, linkweb, raters, viewcount, published, favcount) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?);
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at android.database.sqlite.SQLiteProgram.native_compile(Native Method)
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at android.database.sqlite.SQLiteProgram.compile(SQLiteProgram.java:110)
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:41)
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at android.database.sqlite.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1026)
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1412)
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at android.database.sqlite.SQLiteDatabase.insertOrThrow(SQLiteDatabase.java:1307)
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at com.brownuniv.brutube.BruTube_Provider.insert(BruTube_Provider.java:82)
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at android.content.ContentProvider$Transport.insert(ContentProvider.java:150)
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:140)
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at android.os.Binder.execTransact(Binder.java:287)
02-24 15:57:37.802: ERROR/DatabaseUtils(283):     at dalvik.system.NativeStart.run(Native Method)

how to solve it??? any idea?

Thorsten Dittmar · Accepted Answer · 2010-02-24 10:38:24Z

3

Are you sure that the LINKWEB variable also contains the text "linkweb"? Maybe a spelling mistake. You can use ADB to connect to the emulator and view the database - maybe that helps (see this document).

edited Feb 24, 2010 at 10:38

answered Feb 24, 2010 at 10:08

Thorsten Dittmar

56.9k10 gold badges95 silver badges145 bronze badges

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

1 Comment

ccheneson Over a year ago

As Thorsten said, make sure you have the correct table schema in your database . From the link above, have a look at the section "Examining sqlite3 Databases from a Remote Shell"

Vishal Khakhkhar · Accepted Answer · 2010-02-24 11:38:00Z

1

checkout there exists column "linkweb" in your table

answered Feb 24, 2010 at 11:38

Vishal Khakhkhar

2,1163 gold badges30 silver badges60 bronze badges

Comments

Diego Torres Milano · Accepted Answer · 2010-02-24 12:12:16Z

0

Use sqlite3 from command line on the emulator or on your desktop to verify that what you are trying to achieve is correct and has no syntax errors. Also verify the schema after table creation.

answered Feb 24, 2010 at 12:12

Diego Torres Milano

69.9k9 gold badges116 silver badges145 bronze badges

Comments

Atul Yadav · Accepted Answer · 2010-02-25 12:45:42Z

0

i think that there is not any column name linkweb.

answered Feb 25, 2010 at 12:45

Atul Yadav

4967 silver badges26 bronze badges

Comments

user286919 · Accepted Answer · 2010-03-05 08:01:40Z

0

i think you are missing space after writing text

answered Mar 5, 2010 at 8:01

user286919

492 silver badges6 bronze badges

Collectives™ on Stack Overflow

getting sqlite exception when insert ? how to?

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related