title: android.database.sqlite.SQLiteException: table X has no column named Y: , while compiling: INSERT INTO
body: <p>this is my error in console :</p>
  
  <pre><code>11-29 19:06:50.295: E/AndroidRuntime(333): android.database.sqlite.SQLiteException: table usuarios has no column named email: , while compiling: INSERT INTO usuarios(username, organizacion, email) VALUES(?, ?, ?);
  </code></pre>
  
  <p>This is the mainActivity, with a button that goes to an Activity for create a 'Perfil' (User)[btCrearPerfil] ... and one to see the listView with them [btEditarPerfil]...</p>
  
  <pre><code>public class MainActivity extends Activity implements OnClickListener {
  
      public static ArrayList&lt;Perfil&gt; lstPerfiles;
  
      @Override
      protected void onCreate(Bundle savedInstanceState) {
          super.onCreate(savedInstanceState);
          setContentView(R.layout.activity_main);
  
          lstPerfiles = new ArrayList&lt;Perfil&gt;();
  
          Button btCrearPerfil = (Button) findViewById(R.id.btCrearPerfil);
          btCrearPerfil.setOnClickListener(this);
          Button btEditarPerfil = (Button) findViewById(R.id.btEditarPerfil);
          btEditarPerfil.setOnClickListener(this);
  
      @Override
      public boolean onCreateOptionsMenu(Menu menu) {
          getMenuInflater().inflate(R.menu.main, menu);
          return true;
      }
  
      @Override
      public void onClick(View v) {
          Intent i;
  
          switch(v.getId()) {
              case R.id.btCrearPerfil:
  
                  i = new Intent(MainActivity.this, CrearPerfil.class);
                  startActivity(i);
  
                  break;
  
              case R.id.btEditarPerfil:
  
                  i = new Intent(MainActivity.this, ListaPerfiles.class);
                  startActivity(i);
  
                  break;
  
              default: break;
          }
      }
  
  }
  </code></pre>
  
  <p>This is the creator of Perfil , entered by btCrearPerfil : </p>
  
  <pre><code>public class CrearPerfil extends Activity implements OnClickListener {
  
  private Database datos;
  
  @Override
  protected void onCreate(Bundle savedInstanceState) {
      super.onCreate(savedInstanceState);
      setContentView(R.layout.activity_crear_perfil);
  
      datos = new Database(this);
  
      Button btGuardarPerfil = (Button) findViewById(R.id.btGuardarPerfil);
      btGuardarPerfil.setOnClickListener(this);
      Button btCancelar = (Button) findViewById(R.id.btCancelarPerfil);
      btCancelar.setOnClickListener(this);
  }
  
  @Override
  public boolean onCreateOptionsMenu(Menu menu) {
      // Inflate the menu; this adds items to the action bar if it is present.
      getMenuInflater().inflate(R.menu.crear_perfil, menu);
      return true;
  }
  
  @Override
  public void onClick(View v) {
  
      Intent i;
  
      switch (v.getId()){
  
          case R.id.btGuardarPerfil:
  
  
  
              EditText eNombre = (EditText) findViewById(R.id.txtUsername);
              EditText eOrganizacion = (EditText) findViewById(R.id.txtOrganizacion);
              EditText eCorreo = (EditText) findViewById(R.id.txtCorreo);
              CheckBox eFavorito = (CheckBox) findViewById(R.id.cbFavorito);
  
              if ((eNombre.equals("")) || (eOrganizacion.equals("")) || (eCorreo.equals(""))){
                  Toast.makeText(getApplicationContext(), "Rellena los campos", Toast.LENGTH_SHORT).show();
              } else {
  
                  datos.nuevoPerfil(eNombre.getText().toString(), 
                          eOrganizacion.getText().toString(), eCorreo.getText().toString());
  
  
                  Perfil p = new Perfil();
                  p.setUsername(eNombre.getText().toString());
                  p.setOrganizacion(eOrganizacion.getText().toString());
                  p.setCorreo(eCorreo.getText().toString());
                  p.setFavorito(eFavorito.isChecked());
  
                  MainActivity.lstPerfiles.add(p);
  
                  eNombre.setText("");
                  eOrganizacion.setText("");
                  eCorreo.setText("");
  
                  Toast.makeText(getApplicationContext(), "Perfil guardado", Toast.LENGTH_SHORT).show();
  
                  i = new Intent(CrearPerfil.this, MainActivity.class);
                  startActivity(i);
              }
  
              break;
  
          case R.id.btCancelarPerfil:
  
              i = new Intent(CrearPerfil.this, MainActivity.class);
              startActivity(i);
  
              break;
  
          default: break;
      }
  }
  
  }
  </code></pre>
  
  <p>And this one, the database for SQLite creator ...</p>
  
  <pre><code>public class Database extends SQLiteOpenHelper {
  
      private static final String BBDD_NOMBRE = "baseDatos.db";
      private static String[] FROM_CURSOR = {_ID, NOMBRE_USUARIO, NOMBRE_ORGANIZACION, NOMBRE_CORREO };
      private static String ORDER_BY = NOMBRE_USUARIO + " DESC";
  
      public Database(Context contexto) {
          super(contexto, BBDD_NOMBRE, null, 1 );
      }
  
      @Override
      public void onCreate(SQLiteDatabase db) {
          db.execSQL("CREATE TABLE " + TABLA_USUARIOS + "("
                  + _ID+" INTEGER PRIMARY KEY AUTOINCREMENT, " 
                  + NOMBRE_USUARIO + " TEXT NOT NULL, " 
                  + NOMBRE_ORGANIZACION + " TEXT NOT NULL, "
                  + NOMBRE_CORREO + "TEXT NOT NULL);");
      }
  
      @Override
      public void onUpgrade(SQLiteDatabase db, int a, int b) {
          db.execSQL("DROP TABLE IF EXISTS " + TABLA_USUARIOS);
          onCreate(db);
      }
  
      public void nuevoPerfil(String n, String o, String c){
          SQLiteDatabase db = this.getWritableDatabase();
  
          ContentValues value = new ContentValues();
          value.put(NOMBRE_USUARIO, n);
          value.put(NOMBRE_ORGANIZACION, o);
          value.put(NOMBRE_CORREO, c);
          db.insertOrThrow(TABLA_USUARIOS, null, value);
      }
  
      public Cursor getPerfiles() {
  
          SQLiteDatabase db = this.getReadableDatabase();
          Cursor c = db.query(TABLA_USUARIOS, FROM_CURSOR, null, null, null, null, ORDER_BY);
  
          return c;
      }
  
  }
  </code></pre>
  
  <p>NEED HELP PLEASE .. THANKS...</p>