table pets has no column named weight about ud845-pets HOT 11 CLOSED

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);";

from ud845-pets.

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

from ud845-pets.

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

from ud845-pets.

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

from ud845-pets.

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.

from ud845-pets.

clear your app data and cache and try again..

from ud845-pets.

uninstall the app and install it again

from ud845-pets.

@akwa-peter and @shaurya96

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

from ud845-pets.

@essopsp You are right

from ud845-pets.

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

from ud845-pets.

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

from ud845-pets.