table pets has no column named weight

[shaurya96]

Error inserting name=Toto gender=1 weight=7 breed=Terrier
android.database.sqlite.SQLiteException: table pets has no column named weight (code 1): , while compiling: INSERT INTO pets(name,gender,weight,breed) VALUES (?,?,?,?)

[vcctu85]

Hi @shaurya96 , double check your syntax and the order of your arguments. Or if you can specify exactly where in the code you're getting this error, I'd be happy to look at it for you.

[ChandoraAnkit]

clear your app data and cache and try again..

[AlShaymaa1]

uninstall the app and install it again

[akwa-peter]

Am having same issue, have same issue and have cleared my data, uninstalled and installed back, but stilll having same issue

[M-Kalita]

@akwa-peter and @shaurya96

UNINSTALL THE APP AND TRY AGAIN! SAME ERROR SHOWED IN MINE APP TOO BUT AFTER REINSTALLING IT,it worked fine.

[jamin-hu]

Uninstalling the app and reinstalling it solved the same issue for me!

[essopsp]

Solution

String query = "CREATE TABLE "+TABLE_RejectList+"("+ COLUMN_NUMBER+"TEXT PRIMARY KEY);";

You forgot the space between COLUMN_NUMBER and "TEXT", it should be:

String query = "CREATE TABLE "+TABLE_RejectList+"("+ COLUMN_NUMBER+" TEXT PRIMARY KEY);";

[RubinTry]

@akwa-peter This is a amazing situation！It's may a bug on Android

[KurModi]

@essopsp You are right

[surajmaity1]

Solution

String query = "CREATE TABLE "+TABLE_RejectList+"("+ COLUMN_NUMBER+"TEXT PRIMARY KEY);";

You forgot the space between COLUMN_NUMBER and "TEXT", it should be:

String query = "CREATE TABLE "+TABLE_RejectList+"("+ COLUMN_NUMBER+" TEXT PRIMARY KEY);";

It worked for me..
Thanks a lot

[AsogwaTech]

Clearing the cache and deleting the app data storage. Then uninstalled the app, it works!