Caused by: android.database.sqlite.SQLiteException: near "text": syntax error (code 1): , while compiling: create table contacts (id integer primary key , name text , email text , uname text , pass text)
Thought it might have been, spacing issues at first but doesn't seem to be the problem. keep having problems with this login/register activities.
public class DatabaseHelper extends SQLiteOpenHelper {
private static final int DATABASE_VERSION = 1;
private static final String DATABASE_NAME = "contacts.db";
private static final String TABLE_NAME = "contacts";
private static final String COLUMN_ID = "id";
private static final String COLUMN_NAME = "name";
private static final String COLUMN_EMAIL = "email";
private static final String COLUMN_UNAME = "uname";
private static final String COLUMN_PASS = "pass";
SQLiteDatabase db;
private static final String TABLE_CREATE ="create table contacts (id integer primary key , name text ," +
" email text , uname text , pass text ";
